I'm not entirely sure I understand the problem. From the sounds of it, you think the compile doesn't affect CPU. It does.

If you can, can you post the query, an...

I'd be focused pretty much on the hardware and configuration issues. I remember the time we were troubleshooting a production performance problem. I backed up the database, moved it to...

I think if you go over to Red Gate you can still get a copy of my book on execution plans for free. You'll have to poke around. I don't...

Ramesh (2/18/2009)

---

By default, users on Windows Vista that are members of the Windows Administrators group are not automatically granted permission to connect to SQL Server, and they are not automatically...

If you can pay for it, Solid Quality [/url]offers several good courses that will move you ahead.

Ours is tied to company performance. They make a series of predictions at the beginning of the year. Depending on how well we do versus the predictions, we get a...

GilaMonster (2/17/2009)

---

You can't. Plan guides are limited to the hints that appear...

Addresses are a pain in the tucas, and yeah, complex storage can be confusing, but I've just found that the more complex storage mechanisms provide a level of versatility on...

Jeff Moden (2/17/2009)

---

I agree... especially when the someone who writes the document is really a frustrated novelist and includes no code samples. Or worse... incorrect code samples and code...

Jeff Moden (2/17/2009)

---

Heh... "STAR"... Start Thinking And Reading. ...

Bruce W Cassidy (2/17/2009)

---

[font="Verdana"]A friend of mine wrote a book on why IT projects fail. One of the points he made (which I remember vividly) was that there are...

GSquared (2/17/2009)

---

Something that was really helpful to me when I was first learning how to build databases and code them was Microsoft's wizards for various things. I'd open the...

Getting the statistics update away from the index rebuilds is great, but dropping the statistics maintenance entirely might not be the best idea. You should monitor your queries to see...

You can query the cache to see what procedures are in it and compare that against the list of procedures. However, just because a procedure is not currently in cache...

Starting from ground zero is hard. I'd concentrate more on learning what everything is and how it works and less on getting certified. Certification counts in some ways, but experience...