Speaking about Indexing
I'll be presenting two sessions this week (February 9 and 11, 2010), both on SQL Server Indexing. The first is...
2010-02-08
343 reads
Blog Posts
T-SQL Speed Phreakery Explained
If you haven't seen the Simple-Talk newsletter (it's free, so sign up!) you may not have seen my article on...
2010-02-08
1,254 reads
Evolving Backups
I saw a post recently from my fellow Red Gate-er, Brad McGeHee, on backups. Brad’s got a ton of experience...
2010-02-07
422 reads
Service Broker, Triggers, CLR. and SSIS Threading Framework
I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I...
2010-02-07
544 reads
Service Broker, Triggers, CLR. and SSIS Threading Framework
I have been trying for a few days to implement a Service Broker implementation to, service the threading framework I...
2010-02-07
1,772 reads
Some Initial Insert Test Benchmarks on SQL Server 2008 R2
They say that imitation is the sincerest form of flattery. I have been following along as Paul Randal has been...
2010-02-07
4,335 reads
SQL Server Storage
This is a short post on SQL Server storage best practice and what i have learned over the years… Much...
2010-02-07
1,335 reads
SQL Server Waits and Queues
Useful link. This is a great best practice article/white paper from Tom Davidson and Danny Tambs.
The word document (880kb) can...
2010-02-07
584 reads
A New Season (A Networking Success Story)
I’d like to share a networking success story. Last year, I blogged about my experience at the PASS Summit of...
2010-02-05
1,177 reads
Another free tool for SQL Server...
Let me show you another free tool for SQL Server that is very usefull and thanks from the companies that...
2010-02-05
1,125 reads
Blogs
SQL Saturday Boston Slides and Code
By Steve Jones
Thanks to everyone who attended my sessions today at SQL Saturday Boston 2025. I’ve...
Scaling SQL Server 2025 Vector Search with Load-Balanced Ollama Embeddings
SQL Server 2025 introduces native support for vector data types and external AI models....
Advice I Like: Fear and Imagination
By Steve Jones
Fear is fueled by a lack of imagination. The antidote to fear is not...
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