Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   

HOME

 
Register / Join
Login
 
 
Events and Video
SQL Server Conference
Business Intelligence Conference
Sharepoint Conference
.NET Developer Conference
Watch SSWUGtv
Podcasts
Webcast Directory
Platforms
Microsoft SQL Server
Oracle Databases
IBM's DB2
MySQL Databases
For Developers
XML Technologies
Major Sections
Business Intelligence
White Paper Library
Product Directory
Database Script Library
FAQ System
Forums
Email Discussions
List Servers
Site Options
Employers: Post Jobs
Find a Job
Popular Articles
Browse Tags
About SSWUG.ORG
About SSWUG
Write for SSWUG
Request Product Review
Advertise on SSWUG.ORG
Contact Us
Other Resources
Office Users Group
MS SQL City
 

Editorial: Rebuild or Reorganize or Do Nothing to Indexes SP
Read thoughts, experiences from around the world, hear about other's work with SQL Server and much more.   Read More...


Feature Article  |  RSS
Rebuild or Reorganize or do nothing to indexes SP
The following stored procedure makes use of the index fragmentation information that resides in the dynamic management view sys.dm_db_index_physical_stats.it decides according to the pecentage of fregmenation if an index is to be rebuild, reorganized or left as is.



Other Articles by This Author

Tags: Rebuild, Reorganize indexes, sys dynamic management views
 
Past Articles  |  RSS
Corporate Computing Models
Creating a Random Test Dataset
Troubleshooting SQL Server 2005 Analysis Services problems (Part 2)
Oracle 2-Day DBA in x Days Post 16; Managing Tablespaces
Things Your Mother Never Mentioned About Setting Up an Oracle Database - Steps 6 and 7
Microsoft SQL Server Content  |  RSS
Managing multiple partitions in multiple filegroups in SQL 2005 for cleanup purposes
SQL Server 2008 Transparent Data Encryption
Rebuild or Reorganize or do nothing to indexes SP
Switching Stored Procedure Execution Context in SQL Server using the REVERT clause
Data Warehouse Partition Strategies
More Articles For This Area
Free Articles For This Area
 
IBM DB2 Database Content  |  RSS
DB2 9 for z/OS XML processing redirection to zIIP and zAAP
Concatenation of multiple row string values to one column in DB2
Integration of IBM Lotus Connection 1.0.1 with IBM Tivoli Access Manager V6.0
On DB2 and Table-Pinning
Testing for Valid Data Representation in SQL
More Articles For This Area
Free Articles For This Area
 
XML-Related Content  |  RSS
XML Execution Plans in SQL Server
Read an XML Document with the StAX Iterator API
Develop a dynamic location-based mashup
Using Ruby and ERB to dynamically create XML files from templates
Call a .Net assembly from custom XSLT
More Articles For This Area
Free Articles For This Area
 
Oracle Database Content  |  RSS
Shared_IO_Pool In SecureFiles Of 11g.
Simple Event Processing - Using SQL with Analytical Functions to detect traffic patterns
How to Develop, Maintain, and Support a Quality Management and Development Process
Constraints With Oracle Total Recall (Remember A Day)
The Oracle Database Buffer Cache should it be bigger
More Articles For This Area
Free Articles For This Area
 
Things You Should Know About
 
Developer-Oriented Content  |  RSS
SharePoint Applied: 10 Things You Wish They Had Told YouPart 2
ASP.NET 3.5 MVC Application
Getting Started with the .NET Task Parallel Library: Multi-Core Case Studies
Handling that Pesky Windows ControlBox
Doing it Faster: Delegate.CreateDelegate
More Articles For This Area
Free Articles For This Area
 
Open Source Database Content  |  RSS
Why you do not use GRANT ALL ON *.*?
Fighting MySQL Replication Lag
SHOW QUERY PLANS
A common problem when optimizing COUNT()
New innobackup feature: --slave-info
More Articles For This Area
Free Articles For This Area
 
Security-Related Content
SQL Injection in Classic ASP and Possible Solutions
SQL Server and the Windows Server 2008 Firewall
Provide login access to all databases in an instance
A Look At April's Mass SQL Injection Attack For ASP.Net / SQL Server Environments
Understanding Script Injection Attacks

   






 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2008, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004