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: Two Great Webcasts on the Near Horizon
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
SQL Server Analysis Services Concepts
SQL Server 2005 Express Edition - Part 31 - Distributed Service Broker Environment - Routing
Help! My SQL Server Log File is too big!!!
Distinct Aggregation Considered Harmful
Managing multiple partitions in multiple filegroups in SQL 2005 for cleanup purposes
More Articles For This Area
Free Articles For This Area
 
IBM DB2 Database Content  |  RSS
Programmers Only: The Mystery of DB2 for z/OS Index-only Updates and Deletes
Collaborate and develop in real-time using Rational Team Concert
Assuring the Recoverability of Your DB2 Databases
DB2 9 for z/OS XML processing redirection to zIIP and zAAP
Concatenation of multiple row string values to one column in DB2
More Articles For This Area
Free Articles For This Area
 
XML-Related Content  |  RSS
Separate content from presentation with XSLT, SimpleXML, and PHP 5
Render XSLTs from another Item
XQuery is Important in a Multi-Platform World
XML Execution Plans in SQL Server
Read an XML Document with the StAX Iterator API
More Articles For This Area
Free Articles For This Area
 
Oracle Database Content  |  RSS
Hierarchical ADFTree with JDeveloper 11g
Using Oracle Business Intelligence Enterprise Edition with the OLAP Option to Oracle Database 11g
Upgrade Experience for Patchkit 11.1.0.7
Shared_IO_Pool In SecureFiles Of 11g.
Simple Event Processing - Using SQL with Analytical Functions to detect traffic patterns
More Articles For This Area
Free Articles For This Area
 
Things You Should Know About
 
Developer-Oriented Content  |  RSS
.NET Tip: Using a Nullable Value Type
Login Status Control in ASP.NET 3.5
Using VSTS Test and Profilers to troubleshoot a High CPU in GC issue
Windows Presentation Foundation ToolTip
SharePoint Applied: 10 Things You Wish They Had Told YouPart 2
More Articles For This Area
Free Articles For This Area
 
Open Source Database Content  |  RSS
Indestructible Cluster part 1
Why you do not use GRANT ALL ON *.*?
Fighting MySQL Replication Lag
SHOW QUERY PLANS
A common problem when optimizing COUNT()
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