Do you work with data? You’ve always got options.
She's ready for the future. Are you?
In preparing for the SQLPeople event, I thought about the role, motivation, and techniques...
2011-04-15
929 reads
She's ready for the future. Are you?
In preparing for the SQLPeople event, I thought about the role, motivation, and techniques...
2011-04-15
929 reads
Not too long ago, Andy Leonard (blog|twitter) dreamed up the idea to create the SQLPeople community. The community is forming...
2011-04-13
864 reads
Wondering what to do when you get a break from work email today?
Make your opening move in a fun contest.
What’s...
2011-03-31
1,894 reads
Careful what you say about cats, lady.
You know what’s crazy?
A comprehensive, technical, well thought-out, and ENJOYABLE document. One written with...
2011-03-30
1,769 reads
There’s a lot of dynamic management and system objects to keep track of in SQL Server.
We all sometimes have the...
2011-03-22
1,328 reads
The Goal
It’s often useful to be able to run a bunch of stored procedures in the background over a period...
2011-03-02
1,077 reads
This post is about two things:
1) Your Page Verification Settings are Critical
You should confirm you are running with the correct...
2011-01-25
1,221 reads
Corruption is so ugly it gets a lolworm instead of a lolcat.
Let’s make one thing clear from the start:
This Post...
2011-01-24
2,389 reads
Optimizing queries is the most fun when you don’t need to add indexes. There’s nothing quite so nice as finding...
2011-01-21
1,879 reads
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
2011-01-06
2,249 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