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,781 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
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,714 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,437 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
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
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
973 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
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,182 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
Blogs
Grinding Away: Mary Spender
By Steve Jones
A few years ago I stumbled on this video and loved it. That led...
PASS Summit 2024 – A new experience
I attended the PASS Data Community Summit held in Seattle in person this year...
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
Forums
How do I fix the, "Unable to process the existing user settings" error message?
I'm sure I've asked this question in either this forum, or another one, in...
Cannot restore new DB
I have made an empty DB called "HJEM_BB" I try to fill it from...
How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item How to Avoid Incorrect Results...
Question of the Day
The AG Secondary Logs
What happens when an AG secondary receives a log record from the primary?
See possible answers