Re-blog – August 12-August 18
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-08-19
752 reads
StrateSQL
PASSMN Presentation – The Creepy DBA
Last night I spoke at the PASSMN August user group meeting. The topic was The Creepy DBA and how you...
2011-08-17
661 reads
Can You Dig It? – Researching Index Scans
Follow the rest of this series at the Can You Dig It? – Plan Cache series introduction post.
"She can dig it!"...
2011-08-12
630 reads
Re-blog – August 5-August 11
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-08-11
465 reads
Re-blog – July 29-August 4
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-08-05
557 reads
August Monthly SQL Server Checklist
First day of the month and first Monday of the month. The list is coming out a bit late due...
2011-08-02
781 reads
Minnesota SQL Server Study Group (August)
Last month, I started using Meetup to schedule SQL Server Study Group events. The idea is to meet twice a...
2011-08-02
937 reads
Re-blog – July 22-July 28
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-29
1,512 reads
I’ve Got A “SQLSat” In Kalamazoo
Last night I received an e-mail letting me know that I’ll be presenting at SQL Saturday #84 in Kalamazoo, MI. ...
2011-07-22
522 reads
Re-blog – July 15-July 21
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-07-22
621 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