John Huang, Microsoft Certified Master in SQL Server, SQL Server MVP, is an independent SQL Server consultant in Vancouver BC, Canada. He started using SQL Server for his projects in year 1994. He has architected and implemented many SQL and BI applications serving different industrial areas. He loves talking about SQL Server and discussing SQL Server technologies with others. He blogs at http://www.sqlnotes.info.

Run T-SQL in Parallel

by john_wong_ca

John Huang’s Blog

Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations...

2015-12-03

2,018 reads

Print Long String

by john_wong_ca

John Huang’s Blog

Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When...

2015-11-26 (first published: 2015-11-19)

1,695 reads

Get All Referenced Tables and Columns

by john_wong_ca

John Huang’s Blog

I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which...

2015-11-19

1,413 reads

Changed SoundEx Disables Index While Upgrading to SQL 2012

by john_wong_ca

John Huang’s Blog

Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in...

2013-12-17

941 reads

Create Semaphore in Sybase

by john_wong_ca

John Huang’s Blog

It seems like I am going to write another none SQL stuff again. No. This is a real life scenario....

2013-11-07

1,140 reads

Len() and DataLength()

by john_wong_ca

John Huang’s Blog

Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main...

2013-05-16

1,247 reads

Protect Yourself from Using DBCC WritePage

by john_wong_ca

John Huang’s Blog

I blogged DBCC WritePage a year ago here http://www.sqlnotes.info/2011/11/23/dbcc-writepage/. It’s an extremely dangerous command especially with the last parameter “directORbufferpool”...

2013-05-14

964 reads