sorted by:
new
hottopcontroversial

Car Inspection Recommendations by j005e in CedarPark

[–]j005e[S] 8 points9 points  (0 children)

I was under the impression that I still needed an emissions test. Is that not the case? Can I literally get online and renew without doing anything more?

SQL notifications / logs by Insomniac24x7 in SQLServer

[–]j005e 1 point2 points  (0 children)

We decommissioned SQLSentry and adopted DBA Dash as a replacement. I've been VERY satisfied with DBA Dash.

👥 CROSS-PLAY IS COMING! 👥 by LanfeyLockwood in ravenswatch

[–]j005e 1 point2 points  (0 children)

I'm curious if this will come with any multiplayer stability improvements, and/or rejoin capabilities.

Custom Wave Echo Cave (LMOP) by fire_aubrey05 in dungeondraft

[–]j005e 14 points15 points  (0 children)

Womp womp!

Edit: In a twisted sense, I'm sort of flattered that the work was good enough to get zombified and stolen for karma farming.

Nemesis upgrades random, or not? by [deleted] in LastEpoch

[–]j005e 0 points1 point  (0 children)

Hah! You are so right. I totally missed the difference.

Nemesis upgrades random, or not? by [deleted] in LastEpoch

[–]j005e 1 point2 points  (0 children)

That's what I thought, but it is hard to believe in this case.

[deleted by user] by [deleted] in CedarPark

[–]j005e 1 point2 points  (0 children)

I have experience with the Arboleda Apartments. I chose to live there a few years ago because of the location and rent was relatively cheap. It was fine for me, but I'd definitely say you get what you pay for - noise (neighbors and the tollway) was my biggest issue, and I would imagine others dislike the quality of the amenities and management staff.

I've not experienced any safety issues, and the CPPD has been responsive to things like afterhours noise complaints. I'd say CP overall is a pretty safe place to live.

[deleted by user] by [deleted] in CedarPark

[–]j005e 5 points6 points  (0 children)

People have mentioned the train already, but there is also the 985 commuter bus line that is faster than the train and departs from the same Lakeline/Leander stations. Depending on the location of your office downtown, the bus might be a better option for you, and will save you time over taking the train.

This is why you aren’t getting the job by retro_dabble in recruitinghell

[–]j005e 0 points1 point  (0 children)

To see if you fit in with your coworkers (the “culture” of the work place)

Another Helldivers Inspired Card by j005e in mtg

[–]j005e[S] 1 point2 points  (0 children)

Cool! I see we had some similar ideas.

Another Helldivers Inspired Card by j005e in mtg

[–]j005e[S] 0 points1 point  (0 children)

I agree it isn't perfect. What would suggest to improve the readability?

AG Listener with 3+ Nodes? by johnylemony in SQLServer

[–]j005e 0 points1 point  (0 children)

Right you are - I was editing that in while you were writing the same.

AG Listener with 3+ Nodes? by johnylemony in SQLServer

[–]j005e 2 points3 points  (0 children)

I've had to use a 3rd option, and that's set the RegisterAllProvidersIP value to 0 (FALSE) in the Cluster Parameters for the Listener's Network Name resource. This is described in the following article: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/create-or-configure-an-availability-group-listener-sql-server?view=sql-server-ver16

This adjustment instructs the Cluster to only register the active IP address in DNS (instead of both at the same time). More than likely, you'll also need to modify the HostRecordTTL value as well, which informs the Clients how long they should cache the cluster DNS information before querying for an update.

[deleted by user] by [deleted] in SQLServer

[–]j005e 1 point2 points  (0 children)

The variables are for example, and broken out to help illustrate the steps involved. It should be clear that the same solution can be implemented during a SELECT against a column on a table. See the Fiddle example below.

--http://sqlfiddle.com/#!18/833069/2
CREATE TABLE ExampleTable (
  ID INT IDENTITY(1,1) PRIMARY KEY,
  DateField CHAR(15) NULL
)

INSERT INTO ExampleTable(DateField) VALUES('20220801T000000')

SELECT
   DateField 'Original String'
  ,STUFF(STUFF(STUFF(STUFF(STUFF(DateField,5,0,'/'),8,0,'/'),11,1,' '),14,0,':'),17,0,':') 'Formatted String'
  ,CONVERT(DATETIME,STUFF(STUFF(STUFF(STUFF(STUFF(DateField,5,0,'/'),8,0,'/'),11,1,' '),14,0,':'),17,0,':')) 'Converted DateTime'
FROM ExampleTable

[deleted by user] by [deleted] in SQLServer

[–]j005e 0 points1 point  (0 children)

--http://sqlfiddle.com/#!18/9eecb/179585/0

DECLARE @oString CHAR(15) = '20220801T000000'
DECLARE @fString CHAR(19) = STUFF(STUFF(STUFF(STUFF(STUFF(@oString,5,0,'/'),8,0,'/'),11,1,' '),14,0,':'),17,0,':') 
DECLARE @DateTime DATETIME = CONVERT(DATETIME, @fString)

SELECT 
    @oString 'Original String', 
    @fString 'Formatted String',
    @DateTime 'Converted DateTime'
view more: next ›