Do you use T-SQL debugging?
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up...
2011-07-13
1,208 reads
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up...
2011-07-13
1,208 reads
I was facing quite well-known issue today – I had to develop logic of duplicating (versioning) parent-child records. Because I was...
2011-07-12
1,923 reads
I continued to check SQL Server 2011 “Denali” for few things I dislike on 2008 R2 and tried to find...
2011-07-11
605 reads
While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...
2011-07-11
1,375 reads
On my current project, I am dealing with date intervals in T-SQL very heavily. I’ve hit interesting issue recently – how...
2011-07-08
2,090 reads
I’ve received interesting question/requirement few days ago:
“… When viewing a query plan graphically, we usually have to hunt for the...
2011-07-08
1,654 reads
My wife and kids are leaving for holiday (without me). Bad thing is that I will miss them, good thing...
2011-07-07
1,278 reads
I’ve started to play little bit with SQL Server 2011 CTP Denali to find out whether some open wounds were...
2011-07-06
457 reads
I wrote about some skeletons in the Denali’s closet here. Let’s also put some good on the table. Very handy...
2011-07-06
1,175 reads
I’ve faced pretty common situation recently – you need to work with huge data during development/testing. It’s good if you have...
2011-07-05
2,349 reads
By Steve Jones
flichtish – adj. nervously aware how much of your self-image is based on untested...
In a previous post we went through how to use Docker Build Cloud to...
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
Just came across something weird. Was wondering if anyone else has ever seen this....
My database was in suspect mode, and when I checked using DBCC CHECKDB, it...
Comments posted to this topic are about the item Creating Statistics on XML
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers