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

Guest Columnist: Mike Byrd

SQLServerCentral.com profile

   Items 1 to 6 of 6   

Index Column Order – Be Happy!

Ever wonder about index column order; this piece should give some insight.  Read more...
By Mike Byrd 2019/02/28 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 1,236 reads

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/21 (first published: 2019/01/14) | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 1,662 reads

TOP vs Max/Min: Is there a difference?

Is there a difference between using TOP and MAX/MIN to return and end value to a table?  Read more...
By Mike Byrd 2018/12/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,572 reads

Scalar Functions with Query Plans: Not all is obvious!

Scalar functions in Query Plans just don't always show the whole story!  Read more...
By Mike Byrd 2018/06/04 | Source: SQLServerCentral.com | Category: query performance
Rating: |  Discuss |   Briefcase | 824 reads

Covering Indexes: Not Just for SELECT but also for UPDATE statements

Covering indexes help UPDATE performance also 
By Mike Byrd 2018/05/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,347 reads

A Collaborative Approach To Table Compression

A start at identifying and creating TSQL statements for tables that may benefit from compression.   Read more...
By Mike Byrd 2011/01/13 | Source: SQLServerCentral.com | Category: table compression
Rating: |  Discuss |   Briefcase | 4,481 reads
   Items 1 to 6 of 6