Archives: April 2012
Has someone deleted a table?
Are you trying to track auto grow events? Problem scenarios such as Database autogrow and slow database recovery
When did SQL memory usage change? Read SQL Server Performance ,memory pressure and memory usage for SQL Server memory analysis
SQL Server security changes?
The default trace… Read more
Q. How can I obtain the members of a role within a database?
A. One method is to use sp_helprolemember
EXEC mydatabase.dbo.sp_helprolemember --returns DBRole MemberName MemberSID My_Admin_Role DOMAIN\muUser 0x010500000000000515000000313CF1C8B4034LF676BJA5EE7C0D0000
As a follow up to an earlier posts - SQL Server - BACKUP LOG WITH NO_LOG
As of SQL Server 2008 , BACKUP LOG with TRUNCATE_ONLY is discontinued. I still find plenty of SQL Server maintenance scripts using BACKUP LOG with TRUNCATE_ONLY.
In SQL SQL Server 2008 – an… Read more
This error message can appear in the SQL Server Error Log files .
Autogrow of file 'MY_DB' in database 'MY_DB' took 455320 milliseconds. Consider using ALTER DATABASE to set a smaller FILEGROWTH for this file.
What does this mean ?
1) Need to analyse how you are managing… Read more