Blogs

Browse by Tags

• SQL 2005
• SQL 2008

• Find The Heap Indexes

  I'm generally a convert to the congragation that all tables should have clustered indexes. It makes sense, helps performance, and in most cases is the best starting point for a tables. If you aren't part of the community of the faithful on clustered indexes, Read More... Posted Wednesday, August 13, 2008 9:41 AM by Jason | 0 Comments Filed under: DM Views

• Index Size and Usage

  Thought I'd share something I threw together for a client today. They were looking for index a list of indexes in a database with their associated sizes and usage. SELECT object_name ( i . object_id ) as table_name , COALESCE ( i . name , space ( 0 )) Read More... Posted Thursday, July 10, 2008 3:02 PM by Jason | 1 Comments Filed under: DM Views, SQL 2005, SQL 2008

• SQL Server 2005 Books Online

  The SQL team at Microsoft updated SQL Server 2005 BOL in July, so if you haven't heard or gotten around to it... make sure you download it . While I was there downloading this though I came across a link to download the SQL Server 2005 Systems View map Read More... Posted Tuesday, August 08, 2006 9:36 AM by Jason | 0 Comments Filed under: DM Views