Viewing 5 posts - 271 through 275 (of 275 total)
Books Online for SQL 2000 has an example script in it under DBCC SHOWCONTIG, but it does an indexdefrag based on a parameter for the logical fragmentation. It should...
June 11, 2008 at 1:12 pm
#827482
or you could have done the following:
1. ALTER DATABASE SET OFFLINE;
2. Move/copy the database file to the new location
3. ALTER DATABASE ');
4. ALTER DATABASE SET...
June 1, 2008 at 4:49 am
#822712
Have a look at http://www.microsoft.com/sql/downloads/trial-software.mspx#EIB
May 29, 2008 at 10:53 am
#821868
You can download a trial version of SQL Server which will run on XP or some of the books come with it on CD.
Personally, I prefer the study...
May 29, 2008 at 10:52 am
#821867
Only thing to think about is that SQL Server in the Cluster may not be able to see all the disks that are in the server - it can only...
March 17, 2008 at 1:31 pm
#790532