Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Peter He profile

   Items 1 to 6 of 6   

Import Excel Spreadsheet to Database Tables

Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.  Read more...
By Peter He 2010/02/17 | Source: | Category: etl
Rating: |  Discuss |   Briefcase | 17,718 reads

Local Temporary Tables and Table Variables

Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.  Read more...
By Peter He 2010/01/15 (first published: 2008/09/01) | Source: | Category: table variables
Rating: |  Discuss |   Briefcase | 28,000 reads

View Column Resolving Issue in Sub-Query

Views are handy constructs for abstracting security and simplfying queries, but they can have unexpected results sometimes. Longtime DBA Peter He takes a look at subquery issues in views.  Read more...
By Peter He 2008/01/02 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,553 reads

CTE Performance

SQL Server 2005 brings a new feature to T-SQL with Common Table Expressions, which make it possible for more complex subquery expressions than in previous versions. Recursion is a common use and Peter He takes a look at how well these new structures perform.   Read more...
By Peter He 2007/05/08 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 16,728 reads

SQL Server Job Scheduling

The scheduling system in SQL Server is quite flexible and powerful, but can be confusing at times. Peter He looks at some of the advanced options you have in automating the various jobs on your server.   Read more...
By Peter He 2007/11/16 (first published: 2006/03/08) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 37,854 reads


SQL Server 2000 has table valued functions that are very useful in many ways. However when you try to limit results with the ROWCOUNT setting, you can end up with some strange results. Peter He brings us a comprehensive look at some of the unpredictable results that you can get and how to code around them.   Read more...
By Peter He 2005/12/21 | Source: | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 9,997 reads
   Items 1 to 6 of 6