SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you create must ensure that the workload reads the data quickly with a minimum of I/O. As well as a sound knowledge of the way that relational databases work, it helps to be familiar with the Dynamic Management Objects that are there to assist with your indexing strategy.
2012-10-23
4,324 reads
Stored proc for scripting out full CREATE INDEX statements from your table indexes with all filegroup, filter and WITH parameters.
2012-11-27 (first published: 2012-10-18)
2,238 reads
This script will provide a dynamic mechanism to decide between REBUILDING an index or simply REORGANIZING an index. Tested and approved for SQL Server 2005 & 2008 Standard or Enterprise or R2.
2012-11-26 (first published: 2012-10-18)
3,822 reads
This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.
2021-04-14 (first published: 2012-10-17)
1,231 reads
2012-08-30
2,700 reads
2012-08-06
2,792 reads
Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information.
2012-08-09 (first published: 2012-07-26)
1,635 reads
2012-07-05
2,822 reads
As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.
2012-02-08
4,386 reads
The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.
2012-01-30
4,672 reads
By Steve Jones
One of the cool things I’ve seen with the new Flyway CLI is that...
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Elevate your workspace with Highmoon’s luxury office furniture Dubai, where sophistication meets superior craftsmanship....
Hi Suppose someone gained unauthorized access to the physical SS data stored on my...
Comments posted to this topic are about the item The Weather Outside Is Frightful
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers