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,305 reads
John Huang’s Blog
Len() and DataLength()
Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main difference of those 2 is that Len() gets the...
2013-05-16
6 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
994 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” of this command turned on. I also showed you...
2013-05-14
3 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,554 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 have issues removing tables created over missing files, the...
2013-05-09
30 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)
3,752 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 or few missing .ndf files. It seems pretty common...
2013-05-07
7 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,919 reads
Fix Page Checksum
A checksum value is tagged with every data page in SQL Server. This is used to detect issues on the storage system to ensure what has been read from...
2013-05-02
6 reads
Blogs
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers