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
601 reads
Blog Posts
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
[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
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
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...
Forums
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers