Reputation
1,855
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
8 11
Newest
 Yearling
Impact
~206k people reached

Apr
22
comment Converting old SQL 2000 Non-Ansi code to SQL 2012 compatible
If it really is used only for read-only reference, I wouldn't convert it; virtualize the hardware if you haven't already; there's always the chance the conversion will introduce errors in an app that's been trusted for many years.
Feb
4
comment SSIS OLEDB Command not firing triggers
run profiler when the ssis package is running; check for errors; might be triggers are failing with permissions or some other error.
Jan
22
awarded  Yearling
Aug
25
awarded  Autobiographer
Jun
24
awarded  Nice Answer
Jan
22
awarded  Yearling
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
2
answered Optimising a query using hint locks
Jun
23
revised Why CDC records nothing while being enabled?
edited tags