Go to your first post above.

Click on your name.  That will take you to a different screen at the top level of your profile.

Click on "Edit Profile".

Follow your nose to...

I have to ask... are the middle two letters in the author name indicative of what wrote this article?

Interesting.  I've never using the SET OFFLINE...

Please obfuscate the database name and then post the exact command(s) you're using to do the restore.

Quick interuption: 5+ gallons of blueberries from my bushes. First picking. And oh, do they taste good.

More berries to come in a few weeks, possibly just as many.

What to...

Here's just one of the many proofs... Both the direct conversion from DATETIME2 to DATETIME and the faulty answer above produce the "silent failures" that I'm...

I thought I had a good one but then found a "silent...

Yes, well ChatGPT generates its responses one word at a time, using each preceding word and the context of the conversation, including its own partially completed sentences, to predict...

I haven't got Copilot, but I thought I'd try it on ChatGPT

Heh... ask it how to convert a DATETIME2 value to a DATETIME value in SQL Server. 😉

Post links that go to the wrong post because spam notifications are no longer considered to be posts and are not counted in...

All of the other folks have brought up great points on this thread and there's really nothing to add.  To emphasize, though...

1. Partitioning does not improve query performance and will...

What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums.  Apparently even Steve has zero pull with them.  Sorry...

What I'm seriously miffed about is that no one at Redgate seems aware nor gives a damn about these forums.  Apparently even Steve has zero pull with them.

Two short paragraphs...

Obvious question, why does this person have the ability to do this in prod in the first place, kill this and you resolve 99.9% of the issues

Put delete triggers...