2,794 reputation
1315
bio website
location
age
visits member for 2 years, 4 months
seen 1 hour ago

1d
awarded  Revival
Jan
3
answered What is the most efficient method of performing the FIZZBUZZ test in SQL Server?
Dec
29
comment Sql Server 2014 IO Resource Governor
Have you created your own resource pool, workload group, and classifier function? Doing something like altering the default resource pool or workload group could cause something like this. Please post your resource pool, workload group, and classifier function.
Dec
23
comment use an Index correctly to optimize queries
Thanks for clarification @PaulWhite and Merry Christmas to you!
Dec
23
revised use an Index correctly to optimize queries
Note on SQL Azure Database added after OP added version info.
Dec
23
answered use an Index correctly to optimize queries
Dec
19
comment Exclude a User From an Audit
I'm thinking keep it simple: include them in the audit, exclude them from your analysis.
Dec
18
revised Excessive sort memory grant
KB / MB columns added
Dec
18
answered Excessive sort memory grant
Dec
18
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 ; )