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...
2012-04-11
1,031 reads
- Interests: Performance Tuning Database Servers, Running and Coffee
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...
2012-04-10
956 reads
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...
2012-04-05
5,090 reads
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...
2012-04-04
3,395 reads
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...
2012-03-23
15,856 reads
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...
2012-03-22
7,011 reads
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...
2012-03-19
1,369 reads
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...
2012-03-15
1,322 reads
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...
2012-03-13
738 reads
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...
2012-03-12
1,263 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers