Peter He


SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2008-03-14 (first published: )

18,015 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2005-12-21

10,103 reads

Technical Article

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)

You rated this post out of 5. Change rating

2005-11-11 (first published: )

1,828 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

Error message in launching web service url in sql report server

By Teewhy

I am getting the following error when I launch web service url in sql...

Report server login issue

By Teewhy

Trying to deploy reports in visual studio 2022, reporting service login is asking for...

Opening and closing with date filter is not giving me correctly output

By akhterhussain80

I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers