Last night I spent 45 minutes composing a complicated question here. When I finished I started the review, and then Chrome, crashed. Thanks, Chrome. This isn't the only time...

...

I've sat in management meetings where people have expressed frustration that people don't auto-magically know stuff and that surely something is common sense.  The people outside of the...

I've into the questions posed here many times.  That's why I'm so careful at interviewing my future employers. 😀 😀 😀

To Steve's point, you should eventually get well-practiced enough to...

1. How many Megabytes does your current 50 million row table have for the Clustered Index?
2. How many rows per batch will typically be inserted into the table?

Is your friend using THROW along with a check on the number of transactions to force a ROLLBACK.  Also, is your friend using SET XACT_ABORT ON as a setup step...

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