Categories

Doing compressed snapshots, watch your temp directory

So I was brought into a problem yesterday at a client where replication hadn’t been working for a few days.  It’s a straight forward SQL 2005 sp2 transactional replication setup with no special filters, just replicates 35 articles.  However as it had been down for a few days a new snapshot had to be generated.  [...]

Another SQL 2005 SP2 Cumulative Update

Well it’s been about 6 weeks since the last Cumulative Update so it must be time for a new one.  So as of today (6/16/08) we now have 8 Cumulative Updates for SQL 2005 SP2 which you can get here.  I haven’t downloaded it yet, but I can tell you that I can’t wait until [...]

SQL 2005 Current Query Activity

SELECT    sder.session_id AS [SPID],    sdes.login_name AS [Login],    sd.name AS [DBName],    sder.start_time AS [Start Time],    sder.status AS [Status],    sder.command AS [Command],    sdet.text AS [SQL Text],    sder.percent_complete AS [Pct Cmplt],    sder.estimated_completion_time AS [Est Cmplt Time],    sder.wait_type AS [Wait],    sder.wait_time AS [Wait Time],    sder.last_wait_type AS [Last Wait],    sder.cpu_time AS [CPU Time],    sder.total_elapsed_time AS [Total Elpsd Time],    sder.reads AS [...]