Detaching and Updating Databases

Question

Detaching and Updating Databases

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
August 22, 2015 at 11:50 am

#73648

Comments posted to this topic are about the item Detaching and Updating Databases
August 24, 2015 at 12:18 am

This was removed by the editor as SPAM

Viewing 13 posts - 1 through 12 (of 12 total)

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

Never used this parameter b4 while detaching a DB, though it`s arguable as it will take some considerable time 4 huge database.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 2

Nice one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

michal.lisinski SSCertifiable Points: 6933 More actions · Answer 3

Nice warm-up question at the beginning of Week. Thanks.

Ed Wagner SSC Guru Points: 287024 More actions · Answer 4

A pretty easy way to start the week, but I'm sure some of us are still a bit tired from the weekend.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 5

Hany Helmy (8/23/2015)
Never used this parameter b4 while detaching a DB, though it`s arguable as it will take some considerable time 4 huge database.

If you have never used it, how can you give any information on how long it will take? 😛

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 6

Thank you for the easy Monday morning question Steve.

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Seems a bit obvious - if you want eveything to work cleanly then (a) don't use a non-existent parameter (although a third or people who've answered so far appear to think that's agood idea :woot:) and (b) don't tell it to skip checks (badly named parameter, as updating statistics isn't actually a check, but it's still something you ought to want to do).

Tom

Rob Schripsema SSCertifiable Points: 7469 More actions · Answer 8

Good question. Learned something already this week -- and it's only Monday!

Rob Schripsema
Propack, Inc.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 9

Never used this parameter before while detaching a Database.

Learnt something new. Thanks for the question.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 10

pmadhavapeddi22 (8/25/2015)
Never used this parameter before while detaching a Database. Learnt something new.

Me too

mhynds SSC-Addicted Points: 452 More actions · Answer 11

Pulled from the referenced article:

[font="Times New Roman"][ @skipchecks = ] 'skipchecks'

Specifies whether to skip or run UPDATE STATISTIC. skipchecks is a nvarchar(10) value, with a default value of NULL. To skip UPDATE STATISTICS, specify true. To explicitly run UPDATE STATISTICS, specify false.

By default, UPDATE STATISTICS is performed to update information about the data in the tables and indexes. Performing UPDATE STATISTICS is useful for databases that are to be moved to read-only media.[/font]

It seems to me running the base command is the same as adding the skipchecks=false option.

Comments?