Reputation
1,911
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
12 28
Impact
~129k people reached

Sep
25
answered Expanding contractions/number ranges into separate records
Sep
24
comment Alternative query to this (avoid DISTINCT)
good comments about providing optimizer with help to make the best use of it as is... very useful information. +1
Sep
21
answered Alternative query to this (avoid DISTINCT)
Sep
21
comment Consolidating data changes in SQL Server by team
Posted a follow up to my answer.
Sep
21
revised Consolidating data changes in SQL Server by team
added 607 characters in body
Sep
21
answered Consolidating data changes in SQL Server by team
Sep
21
asked Dropping One Computed Column Causes All Computed Columns To No Longer Replicate
Sep
20
awarded  Popular Question
Aug
28
comment Can't Restore DB Because of Active Connections
Are you using a 3rd party tool or scripts to do the restore? If your able to restore from a .bak file using SQL Management Studio there is a check box under options to 'Close existing connections to destination database'. Have you tried that?
Jun
29
comment SSIS Lookup Component Irregularities
What is your source... is it a full table or a query?
Jun
26
comment What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Hmmm, the issue wasn't appearing in the log until a couple weeks ago so if that was the cause... it was only something recent that made the symptom manifest as it doesn't appear in the log earlier than a couple weeks ago.
Jun
26
comment What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Negative... but good thought. We moved the whole server to a SAN storage model last summer, we restored everything during that move but that was months ago.
Jun
26
asked What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
Jun
14
comment Format 1,2,3,4 to roman letters for display purpose
Great link @gbn, that was a fascinating read.
Jun
11
comment Are SQL Server's Date values stored as a single int?
now that is nerdilicious +1
Jun
8
awarded  Caucus
Jun
1
revised how to config SSRS 2005 email setting with google apps
added 174 characters in body
Jun
1
answered how to config SSRS 2005 email setting with google apps
May
18
accepted Resource Waits: Mathematical link between Wait Time and Average Waiter Count
May
18
accepted Can you edit the context menu options?