SQL In The City: London 2012, Recap
Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...
2012-07-17 (first published: 2012-07-16)
2,085 reads
The Scary DBA
Querying Information from the Plan Cache, Simplified
One of the great things about the Dynamic Management Objects (DMOs) that expose the information in plan cache is that,...
2012-07-02
1,497 reads
The New Phone Book Is Here!
I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....
2012-06-27
1,598 reads
Problems with my new book
First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...
2012-06-26
830 reads
Does Encryption Affect Seeing Statements in Deadlock Graphs?
Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:
CREATE PROCEDURE DL2e
...
2012-07-03 (first published: 2012-06-25)
2,252 reads
PASS Summit 2012
I sure hope you’re planning on attending the PASS Summit this year. If you’re not, you might want to reconsider....
2012-06-19
784 reads
PASS Nomination Committee
For some reason, which isn’t completely clear to me, we’re voting for part of the members of the Nomination Committee...
2012-06-13
805 reads
Guest Blog
I was given the opportunity to put together a guest blog post for the MVP blog. I did a little...
2012-06-05
939 reads
How to Drop One Plan from Cache
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,319 reads
Never, Ever Use Clustered Indexes
This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...
2012-05-31
2,359 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