SSISDB database Size is very large | SSIS Maintenance | How to reduce SSISDB size

Physical Join Operators in SQL Server

Factors Causing Latency in Replication

Tips to optimize replication in SQL Server

Script To Collect Performance Metrics From SQL Server Query Analyzer

How to Use Performance Monitor in Windows 2008

When Table Data Is Last Accessed And Modified in SQL Server

Frequently Used Queries In Sql Server

What is Statistic in Sql Server Part - 3

 Yes ! Auto update stats causing Performance issues??

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 2

What is Statistic in Sql Server Part - 2

Interview Question : Does sp_updatestats update the statistics of a table if I just run it or does it use specific formula??

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 3

How To Increase Performance Of Slow Insert In SQL Server

Difference Between Index Seek vs Index Scan

How To Enable Deadlock Trace in Sql Server

Frequently used DMV's in SQL Server

Query is running slow from client sql server, Real Time Performance Issue

Why SQL Server SPID is blocking itself

Hi All

Issue: SPID is blocking itself

Description: On one of our server SQL 2005 i have run one maintainence (update statistics)job in morning hours on a businessday and as it should not create any issues i was monitoring server health. After executing job i found spid 64(belongs to job)  is blocking itself.and after some time it went off

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 2

What is Statistic in Sql Server Part - 3

Affects of Snapshot Isolation Level and Tempdb datafile full

Affects of Snapshot Isolation Level on Tempdb

Last weekend we face an issue where we got alert due tempdb datafile is 95.05% full, which is as usual for weekend but there is one thing unusual we found that log file was only 4 % full.

We thought there could be 2 possible reasons.

1. Sorting.  
2. Row versioning