Redundant Query Plan Branches
Consider the following “basic_member” view definition from the Credit database: A simple SELECT from this
Consider the following “basic_member” view definition from the Credit database: A simple SELECT from this
On the week of April 8th, in the MGM Grand in Las Vegas, I’ll be
SQLServerCentral.com just published the following article: Windows Server 2012 Deduplication – Should you use it
My last post about nonclustered Columnstore indexes was written back on February 25th, 2012 (Exploring
I’ve had a couple of months at home, focusing on consulting engagements, and now I’m
In this post I’ll just share the results of a simple set of tests regarding
My latest online course, “SQL Server: Troubleshooting Query Plan Quality Issues” was published today by Pluralsight. The short
I’ve been mulling over a potential Microsoft Connect item regarding selectivity guess warnings, but I’m
My prior post demonstrated the influence of row and page counts on estimated CPU and
In this post I’ll step through a few scenarios regarding row and page counts –
SQL Server 2008 R2 SP1 and SQL Server 2012 RTM+ includes actual row count statistics
SQL Server 2012 introduces the new inaccurate_cardinality_estimate extended event, and I had a few miscellaneous
Keeping up with SQL Server is tough.
We don’t just know SQL Server; we also know what it’s like to sit in your chair. Trying to stay ahead of the industry curve is overwhelming, and the pressure to perform is substantial. We created SQLskills so you can keep your knowledge current and your infrastructure moving forward.
You’ll take a quick assessment as part of the registration process so you’ll know you’re starting at the right level.
Our courses are based in real-world practicality, which means you can start solving problems right away.
Grow your problem-solving capacity, elevate your team’s capabilities, and become invaluable to your organization.