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...

I wouldn't suggest you empty the table, create the index and then load the table. That's actually the opposite of how most large scale loads are done. Instead, get every...

I wouldn't call it a tutorial, but I did write up my experiences doing this sort of thing. It will give you an idea of how you could approach it....

I think you're referring back to another set of posts where someone suggested that using the IN clause in the query eliminated the need for the DISTINCT clause. Am I...