Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...
2012-11-12
1,717 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...
2012-11-12
20 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...
2012-11-12
18 reads
Summit 2012 is over, but not forgotten
What a whirlwind last week was. There were so many sessions to attend and only one of me. I needed...
2012-11-12
743 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
Reblogged from Data on Wheels - Steve Hughes: I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window...
2012-11-12
627 reads
Surface Problems With Azure
I’ve been posting about the Surface over the last couple of weeks and I’ve tried really hard to be positive...
2012-11-12
999 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might...
2012-11-12
1,339 reads
November 2012 – Monthly SQL Server Checklist
Last week was the PASS Summit and there were a few cool announcements made. One in particular was the release...
2012-11-12
576 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at...
2012-11-12
1,038 reads
Book Review: SQL Server 2012 Analysis Services The BISM Tabular Model
I will start off by saying, whenever I see the names Marco Russo, Alberto Ferrari and Chris Webb on a...
2012-11-12
1,903 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers