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: )

16,941 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,024 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,098 reads

Blogs

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Bring Your Own Key to Azure SQL Database Managed Instance TDE

By

Last year Azure SQL Database Managed Instance saw the introduction of bring your own...

Read the latest Blogs

Forums

How to update status with conflict data where chemical temp table have same chem

By ahmed_elbarbary.2010

How to update status with conflict data where chemical temp table have same chemical...

Blob to ADF to Stored proecure

By SQL_Surfer

I'm reading file from BLOB through ADF and I would like to pass the...

RTO 15 minutes with differential backups

By DBANewbie

Hi. I'm working through the official exam reference book for 70-764 by Isakov and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers