Follow me !
Search this blog
-
Recent posts
Tags
- AIX
- Apple
- automation
- backup
- best practices
- Bootcamp
- cloud
- cursor
- db2
- db2 compression
- db2 hadr
- db2 performance
- db2 tuning
- db2 v9.5
- db2 v9.7
- db2move
- db2pd
- indexes
- install
- iPad
- iPhone
- linux
- Macbook
- memory
- NULLID
- Oracle
- package
- performance
- restore
- runstats
- script
- shell script
- sql
- SQL805N
- SQL Server
- stored procedure
- tablespace
- time machine
- tuning
- ubuntu
- ubuntu 9.04
- upgrade
- Windows on Mac
- wordpress
Disclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
Tag Archives: index fragmentation
Script check the index fragmentation in SQL Server
Today I had a need to find the index fragmentation on one of my sql server database and I found this script buried on my computer, thought I will share it here: DECLARE @DatabaseID int SET @DatabaseID = DB_ID() SELECT … Continue reading
Posted in database, how to, sql server
Tagged check index, index fragmentation, reorganize index, SQL Server
Leave a comment