SQLServerCentral - Guest Columnist: Wayne Sheffield

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 2009/06/10 | Source: SQLServerCentral.com | Category: Temporary Tables

Rating:

|

Discuss |

Briefcase | 18,512 reads

Automating Excel from SQL Server

How to have SQL Server drive Excel spreadsheets Read more...

By Wayne Sheffield 2008/12/05 | Source: SQLServerCentral.com | Category: Excel

Rating:

|

Discuss |

Briefcase | 25,326 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 | 8,609 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...

By Wayne Sheffield 2008/05/08 | Source: SQLServerCentral.com | Category: Reporting Services (SSRS)

Rating:

|

Discuss |

Briefcase | 6,275 reads