Reputation
2,001
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
2 13 32
Newest
 Announcer
Impact
~159k people reached

Oct
4
revised Dropping One Computed Column Causes All Computed Columns To No Longer Replicate
deleted 25 characters in body
Oct
3
comment Viable strategies for rebuilding indexes online in SQL Server 2008 R2 Standard edition?
Welcome to S.E. Ola - you get quoted on here all the time!
Sep
28
comment Merge Replication: Where are rowguids of conflict losers stored?
Too easy, thanks again. I'm almost embarrassed I had to ask now that its all done.
Sep
27
comment Merge Replication: Where are rowguids of conflict losers stored?
Interesting... I was looking in the distribution system tables, I didn't even think to look in the actual database system tables. Now that you've found it for me it all seems so logical.
Sep
27
accepted Merge Replication: Where are rowguids of conflict losers stored?
Sep
27
asked Merge Replication: Where are rowguids of conflict losers stored?
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.