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,299 reads
john_wong_ca@hotmail.com
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
5 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
992 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
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,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,552 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
28 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
6 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,918 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
5 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...
Databricks Data Intelligence Platform: Unlocking the GenAI Revolution
Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking...
Storytelling with Data: Let's Practice!
Comments posted to this topic are about the item Storytelling with Data: Let's Practice!
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers