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 4 years, 10 months ago by  Neil Burton.
• This reply was modified 4 years, 10 months ago by  Neil Burton.
• This reply was modified 4 years, 10 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 4 years, 10 months ago by  Neil Burton.

You could also configure a SQL Server Agent Alert to run a transaction log backup job when more than a specified percentage of the log is used.   I...

I went to see ROS with my brother-in-law and nephew between Christmas and New Year and I thought it was pretty good.  There were plot holes you could drive a...

• This reply was modified 4 years, 10 months ago by  Neil Burton.

What do you mean, Neil? The question states the data is encrypted in 2016, moved to 2017. There's no "up to date" here. The algorithm changes. You can't xfer...