It's my turn for the Things You Know Now post thanks to Colin Stasiuk. The basic question asked at the beginning of the thread of posts...
This afternoon I'm pleased to say that I've released the Phase 1 Beta 2 build of the Standalone SQL Agent.
Today is my birthday, so no second technical post from me today. I'm out with friends having a blast. (I'm actually at home with my wife playing video games, as most of these blog posts are written well in advance, but it sounds good to say that I logged in to day and wrote this.) Denny
Why on earth to people want to go changing the rights on the system objects. Continued »
SQL Server has two basics kinds of indexes. They are clustered and nonclustered indexes. There are some fundamental differences to the two which are key to understanding before you can master index tuning.