1,727 reputation
69
bio website
location Rochester, NY
age 53
visits member for 3 years, 7 months
seen Aug 13 at 12:17

Jun
5
comment TRANSACTION ISOLATION LEVEL SNAPSHOT vs. TRUNCATE?
Can you use DELETE FROM foo instead? That won't place the schema lock.
Jan
22
awarded  Yearling
Mar
29
comment SQL Server 2005 Unexpected Disk Usage during Backups
Sounds like a snapshot file or a temp file from 3rd party backup; is it a normal sql backup? Filemon should definitely have something jump out.
Mar
26
answered why would command text not execute at all?
Mar
26
answered Stored Procedures under Source Control, best practice
Jan
22
awarded  Yearling
Nov
30
comment How do I determine what MDF files are in use
I think one danger with this technique is if auto-close is enabled on any databases, you could probably delete an mdf that is still attached. Haven't tried it though.
Oct
27
answered overhead for INSERTS using change tracking and/or change data capture (CDC)
Oct
27
answered Execution plan results for sp_executesql suggests adding missing index for already existing index
Oct
27
revised How to test mirroring with a single Microsoft SQL Server license?
added 439 characters in body
Oct
27
answered How to test mirroring with a single Microsoft SQL Server license?
Jul
25
comment SQL Server 2012 Data Warehousing Overall Flow
Read The Microsoft Data Warehouse Toolkit by Joy Mundy, and also the Kimball books, they give very good guidance.
Jul
23
comment Always being logged in as SA and not Windows account
Is it because you are in the sysadmin group on your machine but not on the server? You could remove your account from sysadmin locally, but you have to be care to make sure you have another account to administer the server with.
Jul
21
comment Always being logged in as SA and not Windows account
sounds like the default schema is not set for the account; run "select default_schema_name , type_desc , name , create_date from sys.database_principals " on both and check your account.
Jul
20
comment Always being logged in as SA and not Windows account
Are you using Management Studio to connect? If so, check the properties on the connection. Or create a new connection in Registered Servers and specifiy Windows Authentication.
Jul
2
answered Optimising a query using hint locks
Jun
23
revised Why CDC records nothing while being enabled?
edited tags
Jun
23
revised Why CDC records nothing while being enabled?
edited tags
Jun
23
answered Why CDC records nothing while being enabled?
Jun
8
awarded  Constituent