Reputation
541
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 3 15
Impact
~40k people reached

  • 0 posts edited
  • 1 helpful flag
  • 22 votes cast
Aug
18
awarded  Popular Question
Jun
17
awarded  Famous Question
May
1
answered How to manually invalidate a pull merge replication snapshot from the publisher
May
1
asked How to manually invalidate a pull merge replication snapshot from the publisher
Apr
17
awarded  Tumbleweed
Apr
10
revised Find unpublished columns via RMO
added 330 characters in body
Apr
10
asked Find unpublished columns via RMO
Oct
2
accepted Choice of clustered key when almost all columns would be part of a unique index anyway
Oct
2
revised Choice of clustered key when almost all columns would be part of a unique index anyway
edited title
Oct
2
asked Choice of clustered key when almost all columns would be part of a unique index anyway
Sep
24
awarded  Autobiographer
Jul
2
awarded  Curious
May
30
comment Converting RTF in a text column to plain text in bulk
Thanks for posting an answer detailing how to convert a library in to a safe library. I did not want to share what I did in my answer as the library I modified was GPL licensed (it appears to be COPL licensed now) and I was concerned sharing any changes could be "distributing" which would require me to do a lot more under the GPL.
May
30
comment Converting RTF in a text column to plain text in bulk
@user22279 See the answer by Ian for a very similar steps to what I performed to make the library able to be marked as "SAFE".
Apr
29
comment Is outputting to both a result set and a temporary table possible?
Your change changes the output, FooId on FooQueue is not constrained to be unique so your version will now cause duplicate records to be returned. The select would need to be select distinct FooId, FooData from #t to get the same behavior as my original query.
Apr
29
asked Is outputting to both a result set and a temporary table possible?
Apr
22
comment List all database containing table and value
One change I would suggest, replace ''' + name + ''' with ' + QUOTENAME(name,'''') + ' this will protect you in the event someone is weird enough to put a ' in their database name.
Apr
8
revised Should I include as much information as possbile to help the optimiser?
deleted 196 characters in body
Apr
8
comment Should I include as much information as possbile to help the optimiser?
Oh yea, I am an avid user of SQL Sentry Plan Explorer.
Apr
8
revised Should I include as much information as possbile to help the optimiser?
deleted 14 characters in body