SQL Server – default trace FAQ

Has someone deleted a table?
Are you trying to track auto grow events?  Problem scenarios such as Database autogrow and slow...

SQL Database roles and members

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...

BACKUP LOG with TRUNCATE_ONLY is discontinued

As  a follow up to an earlier posts - SQL Server - BACKUP LOG WITH NO_LOG
 As of SQL Server 2008 , BACKUP...

SQL Server - ALTER DATABASE to set a smaller FILEGROWTH for this file.

This error message can appear in the SQL Server Error Log files .
Autogrow of file 'MY_DB' in database 'MY_DB' took...

SQL Server RESTORE DIFFERENTIAL BACKUP WITH SIMPLE RECOVERY

First thing this morning – a request from a DBA to confirm if Differential BACKUPS can be restored on a database...

Event ID 7026 and i8042prt troubleshooting

Event ID 7026 and i8042prt is a recurring error in the Windows Event Logs. I usually see this error on...

Troubleshooting Event ID 9 - The device, xxxxx, did not respond within the timeout period.

The System logs returned :
 The device, xxxxxxxxxxxxxx, did not respond within the timeout period.
 Some common causes
1)      SCSI controller  firmware
2)      Incorrect...

Cached blocking history with sys.dm_db_index_operational_stats

Transactions generate IO, latching  and  locking on tables and indexes  , while attempting to access data. The sys.dm_db_index_operational_stats  DMV returns aggregated data...

DBA supertech . Specialise or generalise?

Specialise or a generalise?  It all depends on how you define these terms. 
A  SQL Server DBA may be considered to...

Factors that can delay Log Truncation – LOG BACKUP

When log records remain active for a long time – truncation can be delayed. The delays can cause the transaction logs...