First (trying to save your career here), if this column isn't encrypted with a lengthy salt, someone will beat on you soon.  Hopefully it will be an auditor and...

Hi Mr. Brian,

Thanks for your reply.

Since this is a non-production/non-critical database, it's in a development sandbox, I been running CHECKDB once a monthly or as needed.  Would you recommend...

Haven't tried it but looks great... Welcome aboard!

Did you ever think that Moses was the first person to download data to a tablet from the cloud?  And he got all the commands we'll ever need to...

i thought i responded to this already.  jeff i dont get what you are saying but a peer claims a synonym for the linked server name itself is forbidden. ...

Awesome!!!!!!!!!  Ed Wagner and I both have confirmed hotel reservations.  We'll be at the same...

I'm presenting so I could easily go either way for lunch but...

The OP has left the building!

That WAS a fun award party.  I still have the piece of real live rebar that they presented to me.  It was an awesome night.

The post brings back a memory...

How did you supposedly "learn" that they aren't allowed on linked servers?  I ask because I...

Heh... SQL Server 2017... the last and final version that had good speed.  They "Robo-Copped" 2019 and up with all sorts of "rules". 😉

(bumping the page 2 fault on this forum)

I used to be a front-end Developer... that's why I don't rebuild indexes all the time   ... The page splits that came after the rebuilds would slow down...

To be clear, I don't know how obvious or obscure the bug might be. It might be expected behavior to detect duplicate posts, though I'd expect it to say...

Hi Everyone, I have the data in the below form :

Desired output:

Here...