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

Guest Columnist: Mike Byrd

SQLServerCentral.com profile

   Items 1 to 5 of 5   

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/14 | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 232 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,495 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 | 822 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,336 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,476 reads
   Items 1 to 5 of 5