Blog Posts

1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO

here we...

2012-10-29

2,627 reads

Virtualizing Your Business Critical SQL Servers Anthology

by kleegeek

Technobabble by Klee from @kleegeek

This week I completed a six-part blog series (more like five plus one) on the path to virtualizing your business-critical...

2012-10-29 (first published: 2012-10-24)

2,362 reads

Advanced TSQL training

by Dave Ballantyne

Dave Ballantynes blog

Over the past few years, Ive had it on my to do list to write and deliver and full-scale SQLServer...

2012-10-28

1,033 reads

Countdown to PASS Summit 2012 – 9 to Go – My First Summit

by DataOnWheels

DataOnWheels

We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to...

2012-10-28

589 reads

[off topic] I crossed a milestone today

by chuckboycejr

@chuckboycejr

Hey everyone,
I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat...

2012-10-26

801 reads

Database Mirroring Error

by Chris McGowan

SQL Server 365

I have been setting up multi instance database mirroring for the last couple of days along with some other DR...

2012-10-26

648 reads

DBA Question of the Day: Statistic

by SQLBalls

SQLBalls

http://www.flickr.com/photos/_barney/5177975707/Hello Dear Reader, yesterday I posed the question to you what are Statistics? We could get down and dirty of...

2012-10-26

1,066 reads