EMarkM (3/25/2015)

---

Yeah it's nasty.

Pretty much the first step in any installation document I write (if the organisation doesn't have one, or amend if they do) is to create a Windows...

Since INTERSECT does distinct values, why would you also need the DISTINCT word in each of your queries?

But, what Gail said. No way to tell you what's going on without...

You could shut down the service (although if you can do that, you ought to be able to connect to it) and the copy the database files to a safe...

I guess I misunderstood the question. I'm with Gail.

If you can't connect as a windows logon, it's gone. I sure hope this isn't your production server.

Yeah, it can be. sp_updatestats is an OK way to update statistics on most systems for most statistics. But some systems and some statistics are going to need a more...

The indexes may be fragmented AND the stats are out of date. Rebuilding indexes takes care of both. But, the most likely issue is that the stats are out of...

I don't use the GUI much myself, but I demo it regularly and I've had to use it for screen captures and other functions. I haven't had problems with it...

Not sure. Maybe the index is corrupt. I've only hit that error on hints when I was attempting to force the optimizer to do something it just couldn't do.

By the...

I suspect there was something up with that index, possibly it wasn't even there. You'd only get an error if a hint suggested something that simply couldn't be done, which...

CXPACKET is just an indication of parallel processing going on. As a wait, it's not indicative of anything other than that, you have parallel query processing. You need to look...

It's really going to come down to testing to see if making modifications to the key values hurts performance, and if so, how much. Just having an index on the...

Everything Cadavre said.

Tuning queries requires understanding what the T-SQL statement you have is doing and understanding how the optimizer works with your T-SQL. The way to do that is to...

Jakub.Janda (3/24/2015)

---

Auto update for statistics is not disabled; they are even manually updated in a nightly maintenance job, however, the query does not want to use the PK index. I...

I'm...