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

Guest Columnist: Wayne Sheffield

SQLServerCentral.com profile

<< Newer    Items 21 to 24 of 24   
 

Comparing Table Variables with Temporary Tables

This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.  Read more...
By Wayne Sheffield 2012/06/08 (first published: 2009/06/10) | Source: SQLServerCentral.com | Category: temporary tables
Rating: |  Discuss |   Briefcase | 56,605 reads

Automating Excel from SQL Server

How to have SQL Server drive Excel spreadsheets  Read more...
By Wayne Sheffield 2010/02/19 (first published: 2008/12/05) | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 35,420 reads

Using XML to Enhance the Performance of String Manipulations

This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.  Read more...
By Wayne Sheffield 2008/08/20 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 9,522 reads

Using XML to pass Multi-Select parameters from SSRS to SQL Server

How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 8,332 reads
<< Newer    Items 21 to 24 of 24