Ha! Probably a true statement.

Sure, you can pull from sys.dm_exec_text_query_plan. That requires a statement start offset and a statement end offset, both of which are available from sys.dm_exec_query_stats or sys.dm_exec_requests. It does return the...

That's fine. You can name variables the same thing between procedures and other stuff. It's not like creating a permanent table or a global temporary table. The scope of these...

There just aren't very many hard and fast rules for how to put this together. Yes, if a given column isn't used that is in an index key, that might...

GilaMonster (2/8/2013)

---

Selectivity should not be the primary indicator for choosing index columns. Putting the most selective column first would be stupid if nothing filters by it. The decision as to...

I'm surprised you were getting dedup through the encrypted databases. Really surprised. I figured that would work more like trying to compress them (where the size sometimes goes UP). Any...

But state and status are not the most selective, they are the least selective.

Selectivity is how unique the data is. The most selective column would be the column with the...

If you've had a consistently good experience with the Tuning Advisor, I'd say you're the exception that proves the rule. Mostly, I've seen the DTA giving questionable suggestions or useless...

jcrawf02 (2/7/2013)

---

Huh, I wonder how many situations like that would actually have been helpful....

PiMané (2/7/2013)

---

Grant Fritchey (2/7/2013)

---

That calculation is for a minimum healthy value but even that is to be measured against your server over time. But the biggest key word there is:...

That calculation is for a minimum healthy value but even that is to be measured against your server over time. But the biggest key word there is: minimum. A higher...

Excellent!

Gail also covers setting up server-side trace in her articles on query tuning[/url].

Just be sure you're using no data types in the newer server that can't exist in the older (or other code constructs). You should be able to export the scripts...

I won't say bad things about the competition, but be sure you do a VERY thorough evaluation of the Quest/Dell offerings. Just saying.