Good question

See the steps below

1.) I am going to delete most of the data from the tables and have only 10 customers

This will cut the size of data in the...

Can somebody help me with a command syntax here please ?

I know there is a command where you just specify only a table name and then SQL server

will rebuild...

RE: Rebuild Indexes ?

Is there one single command that will start to rebuild all the indexes ?

(We have about 2000 tables. Some of the tables have upto 20 indexes. )

How do I shrink the size of the database.

Is there a command that I can use ?

All right,

Now that secutity is an issue, I need help on the following:

1. Need to create a user

2. The user should only have read priviledges.

3. Be able to...

Can you give some details here.

Ok, so I get into SQL Server Managerment Studio and then ???

Open a new quesry window and type a command ??

I need some clarity here....

How would I do that ?

This is a great example!

Thanks for the effort. Was helpful!

Just out of curiosity, is there a bulk command that I can issue that will take care of all the indexes

in the database ( I am just wondering how...

In one of the posts above you mentioned the following:

There's no guarantee that any index rebuild of any form will leave you with 0% fragmentation. Don't worry about small amounts...

Please ignore my question above. I found the answer. There is a field by the name "page_count"

that is returned by the query.

Question: So you are saying if a index has...

So is there a command out there that I can use to count the size of the index in pages ?

You mentioned the size of the above index may be...

OK here is my point.

Lets go to the begining of this thread.

Here is what I did

1. Ran the following command

ALTER INDEX ALL ON APPOINTMENTS Rebuild;

2. Ran the following query

select index_id,...

What would be the command to use to drop a particular index and then recreate it ?

What I mean is I'd like to build the index but not have...

You will be surprised. This table does not have more than 100 rows.