Detecting and Removing Duplicate Indexes
Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...
2012-09-14
1,779 reads
Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...
2012-09-14
1,779 reads
In my last article “Introduction to Windows Azure SQL Database Services (Part 1)“, I’ve provided an overview of Microsoft Windows...
2012-09-06
1,229 reads
Microsoft SQL Server provides a variety of different options to monitor deadlocks. This includes Trace flags 1204 and 1222, SQL...
2012-09-03
1,478 reads
One of the security recommendation inside SQL Server Security Best Practice white paper for guest user is that, to disable...
2012-08-31 (first published: 2012-08-28)
5,267 reads
Database servers are configured in such a way that they can service multiple requests from multiple users. Obviously this increases...
2012-08-23
2,464 reads
Database security is essential for the organisations working in healthcare and financial sector because the databases in such organisations contain...
2012-08-23
1,732 reads
Today, my first article (ie. Different ways to audit SQL Server security) published on SearchSQLServer.com. In this article, I discussed...
2012-08-17
1,082 reads
Windows Azure SQL Database also known as SQL Server Data Services or simply SQL Azure is a Microsoft’s cloud services...
2012-08-16
1,918 reads
Today, I’m sharing the following T-SQL script which you can use to find which SQL Server Agent Jobs failed yesterday....
2012-08-15
2,285 reads
We can either use SQL Server Management Studio or use Transact-SQL query to find any SQL Agent jobs that have...
2012-08-12
2,533 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