Differences between SSMS Express & SSMS 2005 other editions

#11

Excellent. Thank you.

"Erland Sommarskog" wrote:

Quote:

BruceD (BruceD (AT) discussions (DOT) microsoft.com) writes:
Thank you again for the feedback. It may or may not be possible to defer
changes, but I'll keep what you have said in mind.

Is there a book, not necessarily from MS Press, that you would recommend?

A book for the stand-in DBA? Maybe this book, but it's for SQL 2008.
http://www.manning.com/colledge/
I have not read it, nor anything else from the author, so I cannot vouch
for it.

But if you really need to make database changes while the real DBA is
away, first implement them in a test environment which is decently similar
to producion in size. (And of course identical in schema.) Then you know
how long time they take. Adding a nullable column is very quick: since
it's a metadata operation. But other changes may require SQL Server to
rebuild the entire table structure, which can make the table unavailable
for a longer time.

And this also shows how important that it is to have it all in scripts.
If you have it all in scripts, you know that what you ran in test, will
also run in production.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Differences between SSMS Express & SSMS 2005 other editions

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Re: Differences between SSMS Express & SSMS 2005 other editions - 12-06-2009 , 08:03 PM