🙂

Thank you . I get new things again.

up~

🙂

Is there aslo an System...

distinct_values_count / all_values_count

sqlwars (5/6/2010)

---

I am a 5 years experienced SQL Server DBA.

As soon as I was out of college, I was trained on SQL Server 2000 and pushed into Database Administrations....

1000 rows is a small group of data, it only take little space in the database,so there are still some avaiable in the datafile ,so .mdf and .ldf will not...

Grant Fritchey (5/5/2010)

---

First you need to identify if you are seeing blocking as the primary source of your performance problems. The best way to do this is to monitor the...

Matt Miller (#4) (4/29/2010)

---

kinzent (4/29/2010)

---

Index rebuilding is a bit like disk defragmentation: the goal isn't to achieve 100% perfect defragmentation, it's to improve the performance of the index. So...

When we rebuild the index, can SQL Server make the physically and logically order to be corresponding?

And if the logically does not match the physically ,does it mean the fragements...

Thanks for your help~:-P

Very appreciate your answer~

You say "The fact is that data is neither stored nor retreived in precise order" , but when there is a clustered index on one column,will the...

thank you ~

But the tools you list are copyright software.

Is there a open-source software to monitor my MSSQL.:-D

I have the same error this day.

Is there somebody have got it?:-D

I don't think it is a good idea to use the xp_cmdshell to get the result on production DB.

It is other ways to achive the same reuslt?

A kind job by...

How much time it will take?

when I run on my personal DB,it completed in one minutes

but when i run on own product db,it took a long time ?

Who can tell...