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
1,934 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,692 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,412 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
927 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,135 reads
Len() and DataLength()
Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main...
2013-05-16
1,246 reads
Protect Yourself from Using DBCC WritePage
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
Attach Database with Missing NDF File
I wonder if you’ve had the situation that I had before where you have to attach a database with one...
2013-05-13 (first published: 2013-05-07)
2,739 reads
Bring Offline File Online — Modify SQL Server Metadata
In my last post, I demonstrated how to mount a database with missing NDF files. In the end, we still...
2013-05-09
1,526 reads
Fix Page Checksum
A checksum value is tagged with every data page in SQL Server. This is used to detect issues on the...
2013-05-02
1,576 reads
Blogs
Architect a disaster recovery for SQL Server on AWS: Part 1
New blog post - Architect a disaster recovery for SQL Server on AWS: Part...
Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.
New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...
Daily Coping 3 Aug 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
xml output from sql query
The script runs but gives me "no data to export" I see data in...
Dynamically Update A Parameter to Pass to Another Report
I have an existing SSRS Report which displays the following: UserName, UserID, DOB Bill...
Multiple Lambda Parameters in Python
Comments posted to this topic are about the item Multiple Lambda Parameters in Python
Ask SSC