The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...
2010-05-07
6,240 reads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...
2010-05-07
6,240 reads
Question: Is Mirroring Supported by MS Access front-end?
The following question was posted on a SQL Server discussion group. My reply...
2010-05-07
2,298 reads
A Few Updates on the MCM: Plaques, Visitors, New Class, and New MCM’s
I just want to pass along a few...
2010-05-01
1,157 reads
Undocumented Capabilities of Extended Event Objects
The extended event objects (objects exposed by an event package) are listed in the system...
2010-04-28
2,158 reads
Looking forward to Optimize for Ad hoc Workloads in Sql Server 2008
One of the features of SQL Server 2008 that...
2010-04-23
3,194 reads
T-SQL Tuesday #005: Smart Card Login Breaks SQL Server Reporting Services 2008
This blog entry is participating in T-SQL Tuesday #005,...
2010-04-13
3,402 reads
2010-04-10
583 reads
5 Random Thoughts on the SQL Server MCM Program
I've had some random thoughts running through my head since I finished...
2010-04-10
3,502 reads
How do I Write a Backup Strategy?
DBA's harp about the need to have backups. The first thing many DBA’s do when they inherit...
2010-04-09
962 reads
Catching Transient CPU Spikes Using SQL Trace If there was one thing I wish everyone who works with SQL Server would...
2010-04-06
4,474 reads
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
By Steve Jones
This month is a great topic to me. I think growing and improving your...
Comments posted to this topic are about the item Creating Statistics on XML
Comments posted to this topic are about the item Managing SQL Agent in Azure...
Hi, I hope this isn't too long of a question- I tried to make...
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