Who is an expert?
Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid...
2014-04-16
409 reads
Blog Posts
[SQL Snacks Video] SQL Server Table Partitioning 102
Welcome back for part 2 of my SQL Snack Pack on Table Partitioning! If you have not watched the first...
2014-04-15
623 reads
A ever-increasing Clustered Key value doesn’t scale!
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-04-15
1,427 reads
April 2014 – SQL Server Monthly Maintenance Checklist
image source
Make sure you start the month right by taking the time to make certain your SQL Server environment is...
2014-04-15 (first published: 2014-04-07)
3,729 reads
Farewell Brook Ranne
For members of the SQL community in Orlando and Chicago you’ve probably heard that Brook Ranne died on March 29,...
2014-04-15
688 reads
MDX # 40 – CROSS JOIN does not return Cartesian product of two hierarchies from the same dimension
Correction
4/25/2014
Thanks to Chris Webb’s comment (see the comment section). I am making a correction on this blog.
The title of this...
2014-04-15
1,919 reads
Optional Parameters Causing Index Scans
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
729 reads
Overview of Published Articles – 2014Q1
Since I write at different places – this blog, Intense School and MSSQLTips.com - someone recently asked me if I could provide an...
2014-04-15
493 reads
Parallel Data Warehouse (PDW) AU1 released
Microsoft’s PDW has seen a big boost in visibility and sales over the past year, and part of the reason...
2014-04-15
1,375 reads
PASS SQLSaturday Events: May 2014
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2014-04-15
491 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers