<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
index
Refine your search with one of the following additional tags (with number of items):
Maintenance
(4)
Indexes
(2)
Metadata
(1)
Sysobjects
(1)
SQL Server 2005
(4)
Database
(1)
Primary key
(1)
Usage
(1)
Defragment
(2)
DMV
(1)
SQL Server 7, 2000
(1)
Views
(1)
Fragmentation
(2)
dynamic
(1)
Sys
(1)
Search for
any
content tagged
index
Add a script
Items 1 to 8 of 8
Identify Obsolete Indexes
Drop indexes no longer being used.
Read more...
By
RCC-JAXDBA
2009/10/19
|
Source:
SQLServerCentral.com
|
Category:
index
Rating:
|
Discuss
|
Briefcase
|
670 reads
Table Index Store and Create
Query to save all index metadata
Read more...
By
Jorge Novo-396570
2009/07/17
|
Source:
SQLServerCentral.com
|
Category:
Indexes
Rating:
|
Discuss
|
Briefcase
|
439 reads
how get primary key in any database
drop the primary key name is different for each database
Read more...
By
Furanshizuku
2009/01/29
|
Source:
SQLServerCentral.com
|
Category:
Primary key
Rating:
|
Discuss
|
Briefcase
|
973 reads
2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
Read more...
By
Grant Fritchey
2008/12/09
|
Source:
SQLServerCentral.com
|
Category:
Fragmentation
Rating:
|
Discuss
|
Briefcase
|
1,216 reads
Aggregating Index usage information
This script aggregates index usage stats into a view.
Read more...
By
sql frenzy
2008/11/25
|
Source:
SQLServerCentral.com
|
Category:
index
Rating:
|
Discuss
|
Briefcase
|
609 reads
Checking fragmented indexes
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
Read more...
By
Gaby Abed
|
Source:
SQLServerCentral.com
|
Category:
index
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
581 reads
disable/enable indexes for table
This procedure disables or rebuilds indexes for a given tablename
Read more...
By
Wilfred van Dijk
2008/10/16
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
980 reads
SQL Server 2005 Index Maintenance
Index maintenance procedure using rebuild or reorganized based on fragementation level.
Read more...
By
Luke C
2008/05/29
|
Source:
SQLServerCentral.com
|
Category:
Maintenance
Rating:
|
Discuss
|
Briefcase
|
1,616 reads
Items 1 to 8 of 8
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
