SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: December 2009

Reporting Services Licensing

Licensing models can sometimes make database modeling seem trivial. Per processor or per seat? Single core, dual-core, multi-core processors? Multiple instances on one server? Virtualizing servers on a single server? It can get very confusing, very quickly.

I’m regularly asked by a former students, clients, and people in the Forums…

Read more

11 comments, 2,526 reads

Posted in Joe Webb on 17 December 2009

Locking Scripts

Thanks to everyone who attended my TechNet Thrive! and Nashville SQL Server User Group presentations this week! I hope it was worth your while. As promised, here is the presentation.

And here’s the script I used to review the locks.

–examine the resources
WHEN resource_type =…

Read more

1 comments, 313 reads

Posted in Joe Webb on 11 December 2009

Locking & Blocking

On the gridiron, two opposing teams are contending for one very limited resource, the football. One team has it; the other team wants it. The team that has it, tries very hard to protect it by securing the football and blocking all others from getting to it.

The same can…

Read more

0 comments, 471 reads

Posted in Joe Webb on 8 December 2009