Instead of removing the original question, you could have posted the solution so that if others hit it, they can benefit. Just a thought.

Personally (and I can hear the collective groans), I'd put Extended Events to work on the database. Capture all queries run against. The reason I say this, index usage stats...

I lean towards, let's try, as much as possible, to simply avoid linked servers. They're very attractive appearing. Looks like a simple, clean, quick, and most of all EASY, way...

An easy way? No.

There just isn't a mechanism that shows, this column, or this table was read. Instead, you can capture query metrics using Extended Events and filter that on,...

Since you aren't qualifying a single column as to who owns it, the optimizer will try to figure out what you're doing. I believe, in the end, that last query,...

"Not able to access the database..." It's a permissions issue. Your service account, or the account you're calling from, don't have access to the appropriate databases. That's it. Check your...

SQL Server is the backbone of the product I've been developing for most of my career.  I'm also in the 61 club.  I've even mentioned that retirement is on...

So anyone got suggestions on things to do in Seattle in two weeks, after the Summit is done for the day, for someone who won't have a...

Go...

FWIW : Scientists are currently busy recreating tissues or animals that have been extinct for millions of years. Perhaps that will be the fate for relational DBA and this...

We're not dinosaurs!  I saw a Star Trek movie (from the 23rd century mind you) where Spock said that a SQL injection attack was used to do nefarious stuff. ...

Thanks everyone for the feedback. Sorry for the late reply, I've been visiting Persian War battlefields in Greece the last couple of days (I love my job, yes, I'm in...

There are lists of exceptions to this as long as... well, very long. However, as a general rule, pick the clustered index based on the most frequently used path to...

There isn't a single true path through this.

Generally, a database gets one storage location. Depending on the tools I'm using (I work for Redgate, so Flyway is the tool of...

That's what I get for not using the GUI for backups.