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,200 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,036 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,361 reads

Blogs

Updating my Kubernetes Raspberry Pi Cluster to containerd

By

There’s been a lot of conversations happening on twitter over the last couple of...

Daily Coping 3 Dec 2020

By

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

SQL Homework – December 2020 – Participate in the Advent of Code.

By

Christmas. Depending on where you live it’s a big deal even if you aren’t...

Read the latest Blogs

Forums

Report based on dynamic columns

By ca4fil

Hi all, Can anyone help please? I am trying to do the below report,...

There are no SQL Server instances or shared features that can be updated -2017

By EasyBoy

Hi Please Assist. I am trying to install SQL SERVER CU 22 on SQL...

How can I exclude records from this table?

By NineIron

How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers