Solved

how to check the  fragmentation in sqlserver 2000

Posted on 2010-09-03
6
252 Views
Last Modified: 2012-05-10
Hi Experts

how to check the  fragmentation in  sqlserver 2000  database (All tables).

Regards
sat
0
Comment
Question by:sateeku
6 Comments
 
LVL 11

Accepted Solution

by:
elbereth21 earned 167 total points
ID: 33595001
0
 
LVL 2

Assisted Solution

by:naushadkhan
naushadkhan earned 167 total points
ID: 33595113
0
 
LVL 5

Assisted Solution

by:ThakurVinay
ThakurVinay earned 166 total points
ID: 33609818
DBCC showcontig

check for "Scan Density" value

HTH
Vinay
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:sateeku
ID: 33722409
hi
0
 

Author Comment

by:sateeku
ID: 33722411
hi
0
 
LVL 11

Expert Comment

by:elbereth21
ID: 33722943
Not an objection, but I think naushadkhan's comment n°33595113, is actually a repetition of my previous comment. I don't think it can be considered an "assist".
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now