2008-02-13
4,101 reads
T-SQL
Computed Columns
Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.
2008-02-12
12,996 reads
2008-02-11
3,524 reads
2008-02-04
2,867 reads
2008-01-31
4,059 reads
DBCC Reindex with Statistics Information and table name optional
Reindex all tables, showing statistics before and after reindexing, table name optional.
2012-03-27 (first published: 2008-01-30)
3,109 reads
2008-01-30
3,307 reads
Revenge of the BLOB
Working with large images or other BLOB data can be a challenge for many DBAs. Andrew Sears brings us some code that can help you extract some of that data out of BLOBs and get it back into a more easy-to-work-with format.
2008-01-30
8,462 reads
2011-11-18 (first published: 2008-01-29)
2,901 reads
2008-03-14 (first published: 2008-01-29)
1,266 reads
Blogs
Back in the EU
By Steve Jones
I flew to Amsterdam last night and hopefully by the time this publishes I’ll...
The Feedback Multiplier: How Leaders Can Turn Input into Innovation
By Chris Yates
In every organization there is a hidden currency more valuable than capital, more enduring...
Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)
Update for SQL Server 2025: This post and the GitHub repo have been updated for...
Forums
how to use a variable in a CASE statement?
hi everyone I am getting an error when I add a variable to a...
How to Use SQL Server Features to Cut Web App Latency in Half
Comments posted to this topic are about the item How to Use SQL Server...
Choosing an AI in Sept 2025
Comments posted to this topic are about the item Choosing an AI in Sept...
Question of the Day
The New SQL Server 2025 Data type
In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?
See possible answers