257 reputation
112
bio website
location
age
visits member for 1 year, 11 months
seen 13 hours ago

Sep
22
comment Query slower than the sum of its parts
@Aaroninus use statistics IO and TIME, even the %ages on the actual plan are only estimates
Sep
22
comment Query slower than the sum of its parts
From a transaction overhead perspective, your 2nd code is worse than the 1st one. In the first, each statement is an implicit transaction. In the 2nd, you also have a transaction overall, leading to possibly larger transactions and extra commits which are not required
Sep
7
comment Undo SQL UPDATE Azure DB
@kin ah.. that info was added later. I'll still let this be here if anyone using the new editions stumbles on this question...
Sep
7
answered Undo SQL UPDATE Azure DB
Aug
15
accepted Why is my filtered index being ignored?
Aug
15
comment Why is my filtered index being ignored?
Got it.. I presume this would be applicable in a scenario where the index is created on (a,xyz) WHERE a IS NOT NULL, if xyz contains 100's of values for each a, SQL would still be able to filter out the a's where it a IS NULL trivially during the query due to the tree structure of the index?
Aug
15
comment Why is my filtered index being ignored?
@AaronBertrand I went through the 1st link just now, but the situation described there is virtually the same as mine, (except that IS NULL is used in the blog, but IS NOT NULL is used in my query. However, thats the situation for both the index and query) The optimizer did use the filtered index in the blog. In my case it does not (except when the filtered index is the only one)
Aug
15
revised Why is my filtered index being ignored?
added 4 characters in body
Aug
15
asked Why is my filtered index being ignored?
Aug
9
awarded  Curious
Aug
8
comment Should I check for existence of temp tables in Stored Procedures?
Exactly what I was looking for, esp the code segments! I'll read through the links and post a separate question if I have specific doubts
Aug
8
accepted Should I check for existence of temp tables in Stored Procedures?
Aug
8
comment Should I check for existence of temp tables in Stored Procedures?
@AaronBertrand What sort of code will cause an error where the SP fails, but the tables persist? I tried a trivial procedure and it doesnt exhibit this behaviour (call with 1, then 0 (which fails after creating the temp table due to a divide by 0), then 1 as parameters from the same SSMS query window) pastebin.com/yW7D4SgJ
Aug
8
comment Should I check for existence of temp tables in Stored Procedures?
Got it.. any examples of what sort of issues could creep up?
Aug
8
asked Should I check for existence of temp tables in Stored Procedures?
Jul
25
awarded  Tumbleweed
Jul
18
asked When there is a Type 1 and type 2 SCD in a dimension table, how are updates to the type 1 column handled after the type 2 column is updated?
Nov
12
awarded  Yearling
Mar
16
awarded  Custodian
Mar
16
reviewed No Action Needed MySQL user created via command line can't access PHPMyAdmin