167 reputation
4
bio website
location
age 43
visits member for 1 year, 9 months
seen 2 hours ago

Aug
15
comment How to add a missing database to an AlwaysOn Availability Group
This is more of a one time instance. Although looking through your script we may use it going forward, to keep this from happening again(we don't create DBs very often). Thanks for the heads up on the link/script!
Aug
15
asked How to add a missing database to an AlwaysOn Availability Group
Jun
16
comment “Wide” vs “Long” Database Structure - Is there a logic when to use which?
I agree w/Colin Hart, here's a link that stopped me from doing the EAV. stackoverflow.com/questions/2403387/…
Nov
1
awarded  Popular Question
Jun
21
comment Running functions in parallel
That's a great example. Thanks guys, I learned a lot reading through it.
Jun
21
accepted Running functions in parallel
Jun
20
revised Running functions in parallel
added 2039 characters in body
Jun
20
comment Running functions in parallel
Given that scalar functions are, generally, a hit on performance(much more than I realized initially), how would you recommend I approach the problem of fixing mangled dates(that won't cast/convert neatly) w/out having to copy/paste code everywhere?
Jun
20
asked Running functions in parallel
Mar
26
comment Write differences between varchar and nvarchar
Good answer, I like the example.
Mar
26
accepted Write differences between varchar and nvarchar
Mar
6
awarded  Editor
Mar
6
revised Write differences between varchar and nvarchar
added 99 characters in body
Mar
6
asked Write differences between varchar and nvarchar
Jan
18
comment How to create an object and then alter it
@AAron, I was using a scalar function as an example. This script(template) would apply to other objects as well.
Jan
17
awarded  Scholar
Jan
17
accepted How to create an object and then alter it
Jan
17
comment How to create an object and then alter it
That looks like it will work. Thanks for the help, and yea, SQL Server really should have Create or Replace functionality.
Jan
17
awarded  Student
Jan
17
asked How to create an object and then alter it