I checked JUMPSTARTTV. Too complicated. He goes real quick. I wish there was a place where we had step by step instructions and a tutorial.

Hmm.. I see an icon with a picture but then the pciture has to be in a web site because they want us to type in a URL as a...

Ok,

Thanks everyone.

I do have to agree with what you said.

This weekend we ran a maintenance job on all indexes and the results

are in agreement with what some of you...

Here is a question to the SQL_DBA who presented us with how to run the DBCC command.

As you know there are 2 types of fragmentation.

1. External - results when...

Hello

This is a production database. I am not allowed to drop indexes and create them from scratch.

I guess the previous reply is correct to assume. He said when the

number...

Hello

The index is not small and not just 233 pages. Take a look. Only level 2 of the index has 233 pages. Level 3 has 38237 pages.

So it is a...

#1 The table is very large ( well above a million rows ).

#2 If the page count in small ( less than 1000 ) you said it would not fragment....

Not sure how to use the DBCC command. Any advice ?

Also this is a large table I don't want to slow down the system

if this command is resource intensive...

Yes

This table has about 18 indexes. I tried several of them ( Tried the Alter Index command using other indexes ) and some of them returned the same...

RE: SCHEMA

You are right. One of the main advantages of having a schema is for security reasons.

There are different rights that you can grant on objects to each user.

That is...

Sorry for not getting back......

Let's back up here and answer your first question

---You said -------

Hi MW,

I am impressed on your answer.

But can you please tell me one more thing,

As...

A login ID is also known as a principal in SQlsever.

loginID = Similar to a ID that you would use to enter a building.

There are 2 types.

1.) logins...

DONE !!!!!

😛

APEXSQL tool did the job. Great! It finds all the droped tables, then finds all the inserts that went to the table to a selected time period.

The tool comes...

Gail

Sorry, this is not related to the question in the forum.

I see that you have the credentials MCITP.

Would you mind if I ask you a few questions about the

credentials

My...

APEXSQL log seems like a promising software. Lets see how it goes.