Browse by Tags

• Covered Indexes
• DDL
• Index
• MetaData

• Performance Effects on Column Type Changes Another Point

  In a previous blog http://blogs.sqlservercentral.com/ken_kaufman/archive/2008/05/14/performance-effects-on-column-type-changes.aspx I talked about how SQL handled switching data types and lengths of the same data type, in particular increasing a varchar... Posted Jun 10 2008, 11:28 AM by Ken Kaufman with | with no comments Filed under: Performance, DDL

• Leveraging Clustered Indexes in a Covered Index

  In my last blog I talked about covering indexes. In doing so I slightly touched up non-clustered indexes containing a pointer to the clustered index of the table. There are often times when you want to cover a portion of the a composite clustered index... Posted Jun 06 2008, 06:28 PM by Ken Kaufman with | with no comments Filed under: Performance, Index, Covered Indexes

• Performance Effects on Column Type Changes

  The other day I was given a request to change a field from varchar(6) to varchar(10). Not thinking it was a big deal I said just give me the checked in code and I'll make the change. One of our sharper dev's (Bill Carlson) was concerned with the... Posted May 14 2008, 06:47 PM by Ken Kaufman with | with no comments Filed under: Performance, DDL, MetaData