When you think if Profiler, you think of capturing specific events occuring within SQL Server, usually in a very crude format that is not always easy to understand. In SQL Server 2005, Profiler has added a new feature that is not only very powerful, but easy to use and interpret. It is called the Blocked...

Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to updates and delets on the table and the golden rule...