SQLBits Review
I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find...
2017-04-26
495 reads
I promised a recap/review on my first SQLBits event so I finally got around to it, hopefully you will find...
2017-04-26
495 reads
I seriously finding searching for objects within SQL Server Management Studio (SSMS) via object explorer slow, manual and fiddly especially...
2017-04-25
441 reads
I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade, if...
2017-04-24
351 reads
Imagine this scenario, you are a database professional at your place of business and you look after a mountain of SQL...
2017-04-12
509 reads
This month’s T-SQL Tuesday entry hosted by Koen Verbeeck (http://sqlkover.com/t-sql-tuesday-89-invitation-the-times-they-are-a-changing/), a blog post about how we feel about the ever...
2017-04-11
312 reads
I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...
2017-04-04
576 reads
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
364 reads
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...
2017-03-28
983 reads
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...
2017-03-27
301 reads
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...
2017-03-24
380 reads
Yes, you’re reading that right, we’re going to download a report that cannot be...
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
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