Viewing 15 posts - 76 through 90 (of 217 total)
Reindex organizes the pages but does not release the space on the files back to OS. So your file size will not decrease.
But when you restore the database on to...
October 14, 2009 at 11:15 pm
1. An error in the query results for the 2000 instance (maybe a SQL 2K bug).
May be, I'm not sure.But How can we prove that its a bug?
2. An indexing...
October 14, 2009 at 10:35 pm
system databases shouldnt need changing
Is that means, we should NOT change the compatibility mode to 90 for MASTER database after doing in-place upgrade from sql server 2000 to 2005??
thanks
October 14, 2009 at 10:13 am
plz advice
thanks
October 14, 2009 at 9:44 am
We have a/a/p setup of SQL Server 2005 EE x64 with SP3 on Windoes 2003 EE R2 x64 with SP2.
Node1 has 2 instances
Node2 has 4 instances
Node3 is passive.
We need to...
October 12, 2009 at 10:11 pm
Can we rebuild indexes, and perform dbcc updateusage and sp_updatestats for MASTER database after changing the compatibility mode to 90?
I went through this link http://msdn.microsoft.com/en-us/library/ms175527.aspx which...
October 12, 2009 at 9:49 am
Change page verification to CheckSum (from Torn page)
why this step required?
Rebuild all indexes (individually)
can I use Maintenance plan Rebuild task to rebuild the indexes?
Perform test by the application team(s)
If...
October 8, 2009 at 9:11 pm
Hi,
We have 16 GB of RAM on the server.Max memory is set to 12 GB , Min memory is set to default value and 4 GB is left for OS.
I'm...
October 7, 2009 at 6:49 pm
I don't see why you would want a separate group for a disk assigned to backups, assuming you are using native SQL backup.
hth.
Actually, we ran out of the Drive...
October 7, 2009 at 1:36 pm
rebooting the server may resolve the issue (may remove enterprise manager)
October 6, 2009 at 8:00 pm
disk resources shouldn't be added to the SQL Server Group. [Tongue]
SQL Server Group contains, SQL Server services, Agent service, Analysis services (if you have one n place), SSIS etc.
While installaing...
October 6, 2009 at 11:48 am
Could you please advice as I'm unable to find RSClientPrint 2005 class in C:\windows\downloaded program files...
October 2, 2009 at 12:06 am
Viewing 15 posts - 76 through 90 (of 217 total)