Are your index statistics up to date? The SQL Server database engine uses statistics to determine which execution plan to use when a query is compiled. Index statistics are used to help the SQL Server engine determine the cardinality of different column values in a SQL Server table. If you want to give SQL Server a fighting chance at picking an optimal execution plan then you need to make sure you maintain your index statistics.
2011-09-14
3,901 reads
Managing Data removal During ETL. First of Comprehensive tools designed for ease of use especially in enterprise Projects.
2011-09-13
4,472 reads
2011-09-13 (first published: 2009-09-30)
8,063 reads
owerShell can be used to for many SQL administrative tasks; this tip walks through how to run T-SQL code and admin tasks on remote servers.
2011-09-13
3,153 reads
This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.
2011-09-12
3,501 reads
Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.
2011-09-12
5,092 reads
To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez explains the essentials, in a broad sweep through a complex subject, in an article taken from his new book 'Inside the SQL Server Query Optimizer'.
2011-09-09
4,876 reads
This article will show you how to determine which network port that SQL Server is listening on for connections
2011-09-08
10,560 reads
2011-09-08 (first published: 2009-09-23)
6,754 reads
You need to configure transactional replication for a very large SQL Server database. Instead of running the snapshot agent to initialize the subscriber, in this tip we look at how you can initialize the subscriber from a SQL Server backup.
2011-09-08
4,025 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers