Table Space updated again
Today we have another update for an age old script on this site. You can find the last update to...
2014-03-28
791 reads
SQL RNNR
Table Space updated again
Today we have another update for an age old script on this site. You can find the last update to the script here. This time we have a bit...
2014-03-28
3 reads
T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been...
2014-02-19
1,782 reads
T-SQL Tuesday #051: Bets and Results
The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made. At close, we saw 17...
2014-02-19
Locks, Blocks, and Deadlocks Oh My!
Abstract
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out...
2014-02-12
827 reads
Locks, Blocks, and Deadlocks Oh My!
Abstract Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this...
2014-02-12
4 reads
Risking Health, Life and Family
Since announcing the topic last week for T-SQL Tuesday, I have thought about many different possibilities for my post. All...
2014-02-11
827 reads
Risking Health, Life and Family
Since announcing the topic last week for T-SQL Tuesday, I have thought about many different possibilities for my post. All of them would have been really good examples. The...
2014-02-11
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been...
2014-02-06
821 reads
Murder in Richmond
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on...
2014-02-06
1 reads
Blogs
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Back at Small Data SF in 2025
By Steve Jones
Today I’m in San Francisco at Small Data SF 2025. I went to the...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers