Reputation
1,926
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 12 29
Impact
~138k people reached

Sep
25
comment Expanding contractions/number ranges into separate records
Funny, I meant perl above (both times) when I wrote ruby. Good luck.
Sep
25
comment Upgrading to SSMS with SQL Web Edition turned off Code Outlining : How do I get it back?
When 2008 first came out I remember there being issues with it not working depending on what engine you were connected to. There was a popular tool as a work around that you can find here: ssmstoolspack.com
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