Need Best Maintenance plan

Question

Post reply

Need Best Maintenance plan

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Attaf_T SSC Veteran Points: 205 More actions · Answer 1

1- Is (Shrink database or Shrink files) speed up the queries or update ?

2- Is (Shrink database or Shrink files) cause a damage in database ?

3- Is (Shrink database or Shrink files) speed up Backup time ?

if not, why we don't use it to decrease the size of files.

Thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Attaf_T (3/13/2011)
1- Is (Shrink database or Shrink files) speed up the queries or update ?

No. Generally it will sow queries down due to fragmetnation

2- Is (Shrink database or Shrink files) cause a damage in database ?

No

3- Is (Shrink database or Shrink files) speed up Backup time ?

No

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Attaf_T SSC Veteran Points: 205 More actions · Answer 3

Attaf_T

SSC Veteran

Points: 205

March 13, 2011 at 7:01 pm

#1298166

Helpful information, Thanks

FTdenali SSCertifiable Points: 5362 More actions · Answer 4

Hi,

Thanks 1000 terabyte times, you guys are really helpful. Lets keep up the knowledge sharing. After all a man is not an Island. We need each other indeed.

FTdenali SSCertifiable Points: 5362 More actions · Answer 5

What about Update Statistics?

Is it a necessity in the maint plan?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Maybe.

Not an easy question to answer.

If you have reason to believe that the auto update stats is not adequate, and the database is small enough that the update stats won't take forever, then sure.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Attaf_T SSC Veteran Points: 205 More actions · Answer 7

Science is boxes and its keys is question.

When we execute CheckDB Without any option what this command do?

Read only the database structure Or change any thing as allocation or index or any thing i don't know ?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

And books online is your friend

http://msdn.microsoft.com/en-us/library/ms176064%28v=SQL.100%29.aspx

DBCC CHECKDB
Checks the logical and physical integrity of all the objects in the specified database by performing the following operations:
* Runs DBCC CHECKALLOC on the database.
* Runs DBCC CHECKTABLE on every table and view in the database.
* Runs DBCC CHECKCATALOG on the database.
* Validates the contents of every indexed view in the database.
* Validates link-level consistency between table metadata and file system directories and files when storing varbinary(max) data in the file system using FILESTREAM.
* Validates the Service Broker data in the database.

It then goes on to list all the options and switches and what effect they have

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass