SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag index Rss

Search for any content tagged index

   Items 1 to 3 of 3   
 

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 738 reads

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.  Read more...
By Additional Articles 2017/02/28 | Source: SQLPerformance.com | Category: index
Rating:  Rate this |   Briefcase | 5,475 reads

Reclaiming Space After Column Data Type Change

A brief overview of how to reclaim storage space after altering the data type of a column.  Read more...
By David Fundakowski 2016/08/09 | Source: SQLServerCentral.com | Category: data type
Rating: |  Discuss |   Briefcase | 1,712 reads
   Items 1 to 3 of 3