SQL RNNR

Blog Post

Database Ghosts

Recently you may have seen my first article on this topic over at SQL Solutions Group.  If not, here is...

2014-11-04 (first published: )

7,083 reads

Blog Post

Database Ghosts

Recently you may have seen my first article on this topic over at SQL Solutions Group.  If not, here is the link so you can read that article first...

2014-10-22

2 reads

Blog Post

Murder In Utah

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-10-14

Blog Post

Microsoft, Me and the MVP

October 1st is one of the quarterly dates that Microsoft announces all of the new people into the MVP program.  It is also a day in which Microsoft recognizes...

2014-10-02

3 reads

Blogs

Export a Power BI Report that cannot be Downloaded

By

Yes, you’re reading that right, we’re going to download a report that cannot be...

Query Intelligence in SQL Server 2025: What Developers Need to Know

By

When Microsoft announced SQL Server 2025, I was curious about what would truly change...

Finding and Killing Blockers with Redgate AI Tech

By

Redgate has a research arm, called the Foundry, that has been experimenting with AIs...

Read the latest Blogs

Forums

Poor Name Choice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Poor Name Choice

Getting the Indexed Columns

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Indexed Columns

T-SQL in SQL Server 2025: Substring Changes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Visit the forum

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