You may have read the blog posts a few weeks ago regarding indexed views and MERGE statement usage and incorrect results. If not, please see the following blog posts: If you are using indexed views and MERGE, please read this! (blog | @AaronBertrand) NOEXPAND query hint returns wrong results – CU fix now available (blog | @jamiet) [...]
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
Validating Instance-Level Index View and MERGE Optimization Activity
Posted on: March 11, 2013 1:57 pm
New Course: SQL Server: Transact-SQL Basic Data Modification
Posted on: September 18, 2012 5:16 am
As Paul recently announced, the entire SQLskills team will be rolling out SQL Server content across several subjects on Pluralsight.com. My latest course, “SQL Server: Transact-SQL Basic Data Modification”, which is the companion to “SQL Server: Transact-SQL Basic Data Retrieval”, was just published today by Pluralsight.com. The course description is as follows: “If you need [...]
New course: “SQL Server: Transact-SQL Basic Data Retrieval”
Posted on: August 1, 2012 3:07 am
Today I learned that the video course I’ve been working on these last two months has been published on Pluralsight: SQL Server: Transact-SQL Basic Data Retrieval The general description from Pluralsight of this course is as follows: “If you need to retrieve data from a SQL Server database then you need to know how to [...]
Hash Partitioning with SQL Server 2012’s SEQUENCE object and CYCLE argument
Posted on: January 25, 2012 4:44 am
When I first heard about SQL Server 2012’s SEQUENCE object – I thought it was an interesting feature to be added and one that I have been asked about by customers in the past (from those who had worked on different database platforms). But when I looked at the CYCLE argument of SEQUENCE, that’s when [...]
Contained DBs and collation conflict
Posted on: December 6, 2011 1:47 am
The SQL Server 2012 contained database feature has an interesting behavior when it comes to collation considerations between the SQL Server instance default collation and a user database collation. I see this new behavior as a benefit, but rather than tell you about it, I’ll step through a demonstration instead. First of all, this demonstration [...]
