Exploring the Varbinary Type
A brief look at the Varbinary data type and its uses in SQL Server for beginners.
2013-02-07
12,669 reads
Timothy A Wiseman
- Interests: SQL Server, Python, Go, Mathematics, Legal Issues
Single User Performance of SQLite v. SQL Server
A look at the performance of SQL Server compared to SQLite for single user applications.
2012-07-19
7,043 reads
An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,474 reads
Going From Many Schemas To One Schema
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,398 reads
Undocumented Extended and Stored Procedures
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,420 reads
2008-12-02
9,120 reads
2008-09-09
12,783 reads
CTEs in Report Creation
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.
2008-03-31
6,156 reads
Reading Ad Hoc Text Files with OpenDataSource
Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.
2007-12-13
10,371 reads
Blogs
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers