Reputation
Next tag badge:
121/100 score
19/20 answers
Badges
5 91 153
Newest
 Nice Answer
Impact
~3.2m people reached

Feb
3
awarded  Nice Answer
Jan
23
awarded  Yearling
Jan
19
awarded  Enlightened
Jan
19
awarded  Nice Answer
Jan
4
awarded  Nice Answer
Dec
7
comment How to use transactions with SQL Server DDL?
@buckley: SET XACT_ABORT ON aborts the batch (until the next GO) so the 2nd function will be created (it is a separate batch). The SET command also rolls back, so you should test with XACT_STATE before rolling back
Dec
3
awarded  Famous Question
Nov
12
awarded  Enlightened
Nov
12
awarded  Nice Answer
Nov
7
awarded  view
Oct
26
awarded  Popular Question
Oct
23
awarded  Nice Answer
Oct
22
awarded  Good Answer
Oct
21
awarded  Good Answer
Oct
19
awarded  Nice Answer
Oct
8
comment SQL Server execution plan is using PK instead of index
Probably not, but I did not say drop any existing indexes. And any query with Unit_Id won't use the current indexes either for the same reasons I gave
Oct
7
answered SQL Server execution plan is using PK instead of index
Oct
7
comment How can I call a remote User Defined Function with Parameters?
:@Quandary: what do you mean? EXEC (@SQL) execute the string as a query. No UDFs ndded
Oct
7
revised Performing efficient searches over two columns
added 254 characters in body
Oct
7
answered Performing efficient searches over two columns