Peter He


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.

4.67 (18)

2008-03-14 (first published: )

17,301 reads

SET ROWCOUNT and TVFs

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.

2005-12-21

10,044 reads

Generate script for extended properties

The stored procedure generates insert script for table and column extended properties in the current database. The generated script checks whether a property exists, if it exists, drop it first. The stored procedure assumes table owner is dbo. It can be easily changed to other users.

5 (1)

2005-11-11 (first published: )

1,430 reads

Blogs

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Daily Coping 3 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Datacenter Downtime and SQL backups

By stevec883

I was wondering what others are doing in regards to a datacenter outage and...

Installing missed items in SQL Server

By itmasterw 60042

Hi, Someone, prior to me, installed SQL Server 2019. and missed a few things...

Redesign of old Table

By bobski

Hi, I am working on an old database table which stores emails, including From,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers