Script Generator
It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
567 reads
Split Function
This is another type of split function which disects 8000 byte varchar with given delimeter and returns table with disected values.It does that with single select statement (internally looped), without using explicit while loop.Works pretty fast
2007-02-06 (first published: 2006-08-18)
395 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
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
SSRS shared dataset parameters not showing in expression builder
I am creating shared datasets that our executive staff can use for creating reports...
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:...
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