I was on Poland recently, but no one let me drive a tank... as far as I can recall.

To really deal with this, you need to get some input and insight into the load process. I know you say you have zero control over it, but, that's where...

Let's start with the last question first, yes, an index rebuild will reduce the level of fragmentation.

First question, is fragmentation of indexes bad?

Well, probably not, no. Fragmentation hurts in a...

I'd need to see more specifics around this. There's nothing magically or uniquely bad or dangerous about a LEFT JOIN when manipulating data, so there's got to be more to...

Defining "used" may lead you to different ways of checking this. I would first get this definition so that you can understand what you then need to do to ensure...

Oh, god. It's really Dynamics. People were cracking jokes about this on Twitter.

Yeah, there is literally no easy way around this. Microsoft purchased this horrible piece of software and then...

The only one of those that offers the slimmest of hopes is the log explorer. However, you better not have the log on simple recovery or that's a lost hope...

It won't...

You're missing Availability Groups and then all the third party solutions through software and hardware. Also not mentioned, just backing up the database on one server and restoring to another....

You are in a world of pain. There is literally no easy way out. At all. So very sorry.

If, and it's probably a huge "IF", you are lucky and they...

Query said:

...WHERE 1=0...

Comment in front of the query said:

-- WHERE 1 = 0

No explanation for it at all.

• This reply was modified 7 years, 4 months ago by Grant Fritchey.

I have a bit of bittersweet news. After more than a decade of coaching youth soccer I am finally hanging up the whistle (although I never actually use one...

Just saw a joke.

Coach calls over little 8 yo player:

Coach: You know that I substitute everyone so you call get some time to play right?

Player: Yes

Coach: And you know we're...

sys.dm_db_index_usage_stats would be a good way to generally understand how data is accessed. It's not perfect. Here's a good article on it.

This is a resource I trust very much talking about this topic. His suggestion is to change the keys every two years. Read the article for more details.