- keep in mind to rebuild all tables / indexes and to run sp_updatestats and DBCC updateusage.

- indeed sp1 takes longer than the actual upgrade

- IMO dts-migration has been enhanced...

... 5. Concerned about something I read in the Resource Guide. It seemed to indicate that any syntax referencing something like dbname.dbo.tablename would need to be corrected to boname.sys.tablename. Yet,...

- you can deny the users rights to any object in the database. Check BOL !

DENY

    { ALL [ PRIVILEGES ] | permission [ ,...n ] }

    {

        [ (...

Scott Coleman explained it very clearly

may i add that you cannot index a varchar(max) column...

- I hope you're performing SQL backups using the T-sql backup statement or a maintenance job from sqlserver

- If a db is "to big" that my have two causes :

  ...

Thanks for the feedback.

in this case, you didn't get the answer overhere, but now others will !

actualy you can name your backup files whatever you want.

And in fact, you can also name your sqlserver db-files whatever you want.

If you stick with the guidelines of using the...

Thumbs up for Collin !

In theory it should be done using Cluster Administrator.

"How to change the network IP addresses of SQL Server virtual servers" :

http://support.microsoft.com/kb/244980/

http://support.microsoft.com/kb/230356

SQLServer itself does...

indeed sp_updatestats and dbcc updateusage should be part of your maintenance job !

and like you experianced, should also be the first step when...

Keep in mind dbcc dbreindex will keep a lock on your table, so others may not be able to use it during the reindex !

If you have updates/deletes on your...

- Did you define indexes for this table ?

- Lets hope you also defined a (unique if possible) clustering index.

- you may want to schedule maintenance for the database/table

(or write...

Books online "Maximum Capacity Specifications"

---> Standard Edition max 2Gb

just my 2 Ct

-

Avoid predicates containing functions !!! (e.g. SUBSTRING