Indexing Strategies
Ramesh writes about various indexing strategies that you might use to improve performance.
2004-01-07
10,694 reads
Indexing
Why the SQL Server Optimizer Uses a Nonclustered Index Instead of a Cl
Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.
2003-11-04
1,286 reads
Stabilize Index
This sp is used to update index in a database. This sp has got three optional varchar parameters. First parameter will take the tablename. Second parameter will take the indexname. Third parameter will take the fillfactor. The following option we can execute the sp in a user database.1. exec StabilizeIndexIt will update all index in […]
2003-10-29
288 reads
Cluster That Index - Part 2
Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.
2003-10-08
8,595 reads
CreateDBREINDEX
This script will generate a set of DBCC DBREINDEX commandsthat can be executed to rebuild the indexes. Additional information is provided to assist with sizing of the fillfactors.
2003-10-03
620 reads
Cluster That Index! Part Two
Chris discusses questions raised by his first article on clustered indexes. Few subjects more important to master than clustered indexes, this is good reading!
2003-08-12
9,989 reads
Find Duplicate Indexes - Episode 1 (The Early SQL Versions)
The excellent script contributed by G.R. Preethiviraj Kulasingham (Preethi) Sri Lanka (contributed 2/20/03, modified 5/22/03) identifies duplicate indexes for the database on which the script is run. It requires User Defined Functions, a feature restricted to SQL Server 2000.This version achieves similar results without using UDFs or creating any other permanent objects. It therefore works […]
2003-05-28
777 reads
Rebuild indexes, update stats and shrink
For each user database rebuild indexes, update statistics and shrink. The script will use the system catalog to produce a list of databases. If you want to excluce a database add the excluded db name to the 'not in' list. You can also adjust the target fillfactor.
2003-05-07
1,869 reads
Unattended Reindexing of all user tables
I see scripts all the time on how to reindex all the tables in a db but they are usually too generic and may cause issues. For instance they typically cause the log file to grow very large and may even fill the hard drive. This is intended to be run off hours when db […]
2003-04-24
655 reads
DB Reindex all Databases
This script reindexes all tables in all databases. Execute the script with the desired fill factor and it will do the rest. There is an option to exclude databases from the reindex. This makes it easy to reindex all newly created databases. Great for the Development environment when Developers are creating database all the time.
2003-03-23
1,988 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Call Center BCA Bisnis Telp.0817877114
Untuk nasabah BCA Bisnis, hubungi Halo BCA Layanan KlikBCA Bisnis 0817 877 114...
CS halo BCA bisnis Telp.0817877114
hubungi Layanan KlikBCA Bisnis 0817 877 114atau WhatsApp di nomor 0817-877114 KlikBCA Bisnis Halo...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers