2,639 reputation
1314
bio website
location
age
visits member for 2 years, 3 months
seen 7 mins ago

21m
answered Help with SQL Query to XML output
Dec
14
answered Create copy of Azure SQL Database using SQL Server Management Studio
Dec
10
answered Incorrect query results for execution plan, unsure of exact cause of problem
Dec
10
answered SQL Server 2012 Table Partitioning - Have I done it correctly?
Dec
4
answered Generate Schema and Data to SQL script and Run it on another DB programmatically
Dec
3
answered How to Select all child elements of a given Node in SqlHierarchyId?
Dec
3
answered How to select top 10 records from each category
Dec
3
awarded  Custodian
Dec
3
reviewed Approve Trying to install sql_server_2014_enterprise_edition_x64_dvd Windows 7(Ultimate) 64Bit OS
Dec
3
answered Trying to install sql_server_2014_enterprise_edition_x64_dvd Windows 7(Ultimate) 64Bit OS
Dec
2
comment SQL Server 2008R2 XML Column Index strategy for large tables?
You're right @MikaelEriksson, there are certainly some situations where they won't be semantically equivalent and some when they are. The correct message then is be careful with your semantics! The tip is from that Performance Optimizations article which is still fantastic 9 years on! It's sad in a way as it shows the feature hasn't moved on that much since then with the exception of Selective XML Indexes. Good to know you are looking over these with a well-informed critical eye ; )
Dec
2
comment SQL Server migration using a replica
HyperBac is discontinued as I tried to get hold of it a few years ago. Never knew why as its 'mount db from backup' ability honestly looked cool. I have in the past resorted to manually zipping uncompressed SQL Server backup files for transfer, which actually has quite a good effect. Zipping already compressed files has no effect and is a waste of time! : )
Dec
2
answered ROW_NUMBER() without PARTITION BY still generates Segment iterator
Dec
2
answered SQL Server migration using a replica
Dec
2
answered SQL Server 2008R2 XML Column Index strategy for large tables?
Dec
2
awarded  Fanatic
Nov
29
comment If a database is in memory does it still need indexing?
Regarding the SQL Server In-memory OLTP feature, the tables must have at least one index.
Nov
28
answered How to save and then restore permissions after refreshing a database
Nov
28
comment SELECT with lots of left join is very slow in SQL Server 2014
Regards refactoring, I can reproduce this problem locally and successfully refactored using NOT EXISTS instead of LEFT JOIN ... NOT NULL. Normally I would expect these to behave the same, however this did work in my simple test rig, no query hints required.
Nov
28
comment SELECT with lots of left join is very slow in SQL Server 2014
I would read the Joe Sack whitepaper I link to in my answer. It has a great discussion of the new feature, where it will benefit you and where it might not, plus all the options for enabling / disabling it at different levels.