Posts
Sort by recent activity
I'm curious which wait types are included in the metric 'Avg Lock Wait Time'.
This has proven to be a good 'canary in the coal mine' indicator on an old legacy system we have, and we would like to customize this for more specific purposes. Is this canned metric available f...
Minimum permissions needed for SQL Compare?
I'm sure this has been asked (and answered) before, but I can't find anything in the forums. What is the minimum security/role needed to run SQL Compare against a prod DB? Surely there must be ...
How to sync local source control folders on new laptop?
I recently had a drive crash on my laptop. I'm using a different machine for now, but discovered that after I re-linked to my dev DB (shared model), the objects I created are not correctly display...
Avoid deploying partition boundary definitions?
I've inherited the responsibility of DB deployment for several legacy databases. I see that partitioned tables, along with their schemes and functions are checked in to source control. When I tr...