Run T-SQL in Parallel
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,912 reads
john_wong_ca@hotmail.com
Run T-SQL in Parallel
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations and I have written and improved it many times...
2015-12-03
4 reads
Print Long String
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,732 reads
Get All Referenced Tables and Columns
I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which...
2015-11-19
1,514 reads
Get All Referenced Tables and Columns
I was always challenged when my customers asked me what tables and columns are referenced by a stored procedure which was written many years ago by the guy who...
2015-11-19
9 reads
Print Long String
Quite often, I output information through PRINT command. It works well only when message is shorter than 8000 bytes. When the message is greater than 8000 bytes, extra-characters will...
2015-11-19
8 reads
Changed SoundEx Disables Index While Upgrading to SQL 2012
Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in...
2013-12-17
982 reads
Changed SoundEx Disables Index While Upgrading to SQL 2012
Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in SQL Server 2012 is C561 whereas the result of...
2013-12-17
5 reads
Create Semaphore in Sybase
It seems like I am going to write another none SQL stuff again. No. This is a real life scenario....
2013-11-07
1,213 reads
Create Semaphore in Sybase
It seems like I am going to write another none SQL stuff again. No. This is a real life scenario. I am writing an ETL for my customer to...
2013-11-07
7 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers