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
603 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
628 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,432 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,739 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
691 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,923 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
740 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
496 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,388 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
494 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers