Viewing 15 posts - 241 through 255 (of 451 total)
Very helpful link and very good question.
March 25, 2008 at 8:30 pm
Check this earlier post http://www.sqlservercentral.com/Forums/Topic453480-146-1.aspx
March 25, 2008 at 8:17 pm
Litespeed backup is compressed. When the backup is restored, it will be decompressed first then restored. Depends on the database size, it may take a while for the...
March 25, 2008 at 8:04 pm
Restore the backup and transaction log backup if needed to a NEW database, either on the same server or another server.
Then you can use either DTS to transfer...
March 25, 2008 at 6:37 pm
Do you have to reindex or DBCC INDEXDEFRAG can be an alternative?
BOL: search Server FAQ INDEXDEFRAG:
DBCC INDEXDEFRAG is an online operation, so it does not hold long-term locks that can...
March 25, 2008 at 2:21 pm
I was surprised that no new HW is involved. Considering the size of your organization and many users, buying a new HW is not a big deal. Unless...
March 25, 2008 at 10:21 am
In addition, deleting a smaller batch is faster. This helps to avoid blocking the other processes as the deletion will not hold the table for too long.
May add...
March 24, 2008 at 9:27 pm
Thank you. Wondering why databasename is there but does not really work, or if it does not work why need to be there.
March 24, 2008 at 1:51 pm
Good to know this column.
March 24, 2008 at 10:33 am
SQL2005 Books online "Creating Indexes on Computed Columns" mentioned about the set option on/off.
This link may help although it is for 2000. http://support.microsoft.com/kb/301292/
March 24, 2008 at 9:39 am
Check this link http://support.microsoft.com/kb/902388
It is for SQL2000 SP4, not sure whether it applies to SQL2005.
I had a similar problem in a SQL2000 maintenance plan (optimization), the workaround worked.
March 24, 2008 at 9:04 am
BTW, I am wondering this question "what are the alternate ways to upgrade?"
---> Why look for alternate ways rather than Microsoft suggested/supported?
March 24, 2008 at 8:47 am
May start from this checklist: http://technet.microsoft.com/en-us/library/ms143695.aspx
For more details, "SQL Server 2005 Upgrade Technical Reference Guide"
Important thing is to fully TEST in your environment, including application testing....
March 24, 2008 at 8:38 am
Update statistics, etc. Check this link and see whether need to apply to your case.
http://msdn2.microsoft.com/en-us/library/ms144267.aspx
"After upgrading the Database Engine to SQL Server 2005, complete the following tasks:"
March 23, 2008 at 10:59 pm
SQL Server 2005 Upgrade Technical Reference Guide
Section 2.04: Upgrading Replicated Databases
Happy reading English 😉
March 23, 2008 at 11:12 am
Viewing 15 posts - 241 through 255 (of 451 total)