It looks very much like a bug. I think that you could install the latest cumulative update package and see if that changes anything. If it doesn't...
I have tested this on version 9.00.3042.00 (Developer Edition X86). I think that it looks like it's working correctly. A [Change free space per page...
In Books Online Microsoft is writing 30% as a threshold for index rebuild. http://msdn.microsoft.com/en-us/library/ms189858.aspx I have a stored...
SELECT SERVERPROPERTY('LicenseType') Ola Hallengren http://ola.hallengren.com
I'm using Event Notifications to log DDL changes. In Event Notifications all events and event groups can be defined on the server scope....
techbabu303, I have a backup stored procedure that is checking the state of your databases. It's useful if you have databases that are taken offline...
>I don't need to do anything else like rebuild procedures or anything else of that sort? SQL Server automatically does recompilation of stored...
Maybe you should consider daily differential backups. This will simplify and reduce the time needed for a point in time restore. I also thought about...
I think that when you have a database of that size then you'll need a lot of space for the log file. In my view you should be able to rebuild your...
>The log file on the primary server is growing enormously high How large is the log file growing? >Please help me out to find a solution to maintain...
If you grant execute rights on a stored procedure you should normally not have to grant permissions on objects in the stored procedures. However this...
Microsoft has as whitepaper on this. "Generally, you should not be concerned with fragmentation levels of indexes with less than 1,000 pages. In the...
You can use the command RESTORE HEADERONLY to check the dates and times for the backup files. http://msdn2.microsoft.com/en-us/library/ms178536.aspx...
One more thing. If you're using the Maintenance Plans to do integrity check of your databases, there is a critical fix that you have to apply post...
SQL Server 2005 with Service Pack 2 has support for this. "What's New in SQL Server 2005 SP2" "Multiple schedules. The Maintenance Plan Designer...
I know that there are a number of bugs related to the Maintenance Plans that are fixed in SP2. I think that you should install that both on the SQL...
>The sql server service account is SQLADMIN. However, SQLADMIN is not being used to run the job. What is the sql server agent service account? Ola...
I have a stored procedure that could help you with this. The stored procedure does index rebuild online or offline, index reorganization, statistics...
I think that you should read about Ownership Chains in SQL Server. http://msdn2.microsoft.com/en-us/library/ms188676.aspx If the stored procedure and...
I think that if you use a RAISERROR () WITH NOWAIT with severity 10 you don't get any Msg 50000. RAISERROR('TEST', 10, 1) WITH NOWAIT Ola Hallengren...
Separate names with a comma.
