T-SQL Tuesday #051: Place Your Bets
Place Your Bets
All bets on the table please. This is the last call for bets, no new bets will be...
2014-02-07 (first published: 2014-02-04)
2,299 reads
SQL RNNR
T-SQL Tuesday #051: Place Your Bets
Place Your Bets All bets on the table please. This is the last call for bets, no new bets will be allowed. This marks the 51st invitation for TSQL...
2014-02-04
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a...
2014-01-21
841 reads
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database. As I pulled out the script from the...
2014-01-21
1 reads
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a...
2014-01-14
683 reads
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a bit behind. Why? Well, that was due in part...
2014-01-14
January 2014 S3OLV and Tabular Models
This is really late notice. We had some extenuating circumstances this month and then a last minute cancellation. Now that...
2014-01-09
650 reads
January 2014 S3OLV and Tabular Models
This is really late notice. We had some extenuating circumstances this month and then a last minute cancellation. Now that everything is squared away, we have some great news....
2014-01-09
2 reads
Day 12 – High CPU and Bloat in Distribution
This is the final installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-06
629 reads
Day 12 – High CPU and Bloat in Distribution
This is the final installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-06
12 reads
Blogs
Export a Power BI Report that cannot be Downloaded
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 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...
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