Some of the special Jacks are much better.  I don't think they're...

OK, so I'm curious and interested in expanding my repertoire when it comes to liquor...

Whiskey / whisky vs scotch, and, what's so bad about Jack D?

(Note, I've only...

Haggis is great though! Haven't had it in ages mind, but I've enjoyed it every time I have. In...

Careful with that 'e' there Mike.  It's normally 'whisky' you have with haggis.

I'm planning on doing another belly this summer when I do 2 pork shoulders and 6 chickens for my daughter's grad party.  She's undecided on the smoked macaroni and cheese. ...

The one time I met Grant in person, we chatted about...

The question asks for text mode, rb will open the file in binary mode.

SELECT DATEADD(SECOND,1575944000000/1000,'1970-01-01 00:00:00.000')

Does this work?

I think the problem is that it is needed serialized update (order by Eff_Date) and some kind of recursive (The first line should updated 4 times using this flow: "Person...

If you're after 36 individual matrices a loop may indeed be the way to go.  However, you can't just create loop to execute a SELECT statement with 36 different values,...

With regard to the recovery  model, I'd forgotten about Bulk-Logged.  It's definitely something to consider.  Another part of the standardisation is to review the backup policies and procedures...

I somehow managed to miss having more than one schedule for a job.  All the research I did was about varying the schedule rather than having more than one.  The...

p.s.  And stop using REORGANIZE for your index maintenance.  It doesn't work the way most people think (actually sets up indexes for perpetual fragmentation) and it's not the tame little...

• This reply was modified 5 years, 8 months ago by Neil Burton.
• This reply was modified 5 years, 8 months ago by Neil Burton.
• This reply was modified 5 years, 8 months ago by Neil Burton.

I have my production databases set to be "exposed" to the possibility of a transaction log backup every 15 minutes, but it's stupid to do an actual T-Log backup...

I like the idea of it picking up automatically, I must say.

It's an out-of-the-box method too and I think the higher-ups will like that.  It might be time for a...

• This reply was modified 5 years, 8 months ago by Neil Burton.