Monthly Archives: February 2011

Find references in all stored procedures on server (2005+)

Imagine you have some text in a stored procedure somewhere and you can’t remember where it is or maybe it is in numerous places and you need a list of all the DBs and objects that contain it. This will … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | Leave a comment

LOCK_ESCATATION and partitioned tables

Did you know that by default lock escalation on a partitioned table is to table level and not to partition level. This is a bit weird (IMHO) as the whole point of partitioning a table is to split the data … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , | Leave a comment