Hello Jeff. Thanx for reply. I have never come across synonyms. Read some info on it. I am not really sure it will work. Anyways the old data will...

Have two tables... for example, TableA1 and Table A2.

Start out with a synonym called TableA and have it pointing at TableA1.

Have another synonym called TableAWork and have it pointing at...

Might just be me but the only time I'll look at any missing index recommendations is when there's a slow query that could really use some help.  Adding indexes is...

What is supposed to happen to the 5 million rows in Table A AFTER you've copied them to Table B and is Table B on the same database and on...

I agree with David Poole.  To put it all in less formal terminology, I've found that tools like ChatGPT are nothing more than a very sophisticated consensus engine and, sadly...

So, are you leaving all of this up to us to contact @marketing, etc?

IMHO, true experts have enough knowledge about a particular subject to know when they don't know something about that subject and aren't afraid to say so.  Saying "I don't know"...

Lordy... even that response seems artificial, especially considering that the author supposed posted that response.  Doesn't pass the "Turing Test", IMHO.

I also expected to see some actual data in this...

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...