24 Hours of PASS Recordings Online
This just in… the 24 Hours of PASS sessions are in and available for streaming. If you missed an hour...
2012-10-11
1,029 reads
Blog Posts
DAX IsFiltered Function
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on...
2012-10-11
2,038 reads
Do you Dream?
You ever have those nights consumed by all things SQL?
I do. It happens more than I might like sometimes. Usually...
2012-10-11
937 reads
Do you Dream?
You ever have those nights consumed by all things SQL? I do. It happens more than I might like sometimes. Usually it happens when there is a work problem...
2012-10-11
8 reads
Find Duplicate (and covered) Indexes
A while back, I wrote a simple little query that lets you Get Index Included Column Info (because sp_help and sp_helpindex only...
2012-10-11
1,674 reads
Interacting with Master Data Services (MDS)
There are four different way to interact with Master Data Services (MDS) to do things such as create a model, load...
2012-10-11
3,143 reads
Lost in Translation – Deprecated System Tables – sysfilegroups
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-11
775 reads
MS12-070 - Should I patch more than Reporting Services?
If you're dealing with a version of SQL Server greater than SQL Server 2000, at this point I'm going to...
2012-10-11
1,985 reads
Multiple CTEs
Multiple CTEs
It’s somewhat obscure in BOL and I wasn’t able to find any examples but it turns out you can...
2012-10-11 (first published: 2012-10-09)
4,575 reads
Performance Tuning Presentation from October 2012 BRSSUG Meeting
Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night! I hope everyone...
2012-10-11
758 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers