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 2010/04/09 (first published: 2009/06/10) | Source: SQLServerCentral.com | Category: temporary tables

Rating:

|

Discuss |

Briefcase | 19,817 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 | 25,655 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,679 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,430 reads