Reputation
373
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 16
Impact
~5k people reached

Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
You seem to want to do an update, not insert
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Can you post the schema of PurchaseInfo as well?
Feb
25
suggested approved edit on Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Feb
25
answered Check if query will cause duplicate row
Feb
11
awarded  Nice Question
Feb
2
accepted Can I fail the current transaction from within a trigger?
Feb
2
comment Can I fail the current transaction from within a trigger?
Just tried on your suggestion and it works :)
Feb
2
asked Can I fail the current transaction from within a trigger?
Jan
16
awarded  Peer Pressure
Jan
13
asked Where are connections to databases made from when using SSRS?
Dec
1
comment SQL Server job - powershell Where does “log to table” save logs
Thanks, I dont have help configured correctly I think, pressing F1 leads to help about the help viewer :)
Dec
1
accepted SQL Server job - powershell Where does “log to table” save logs
Dec
1
asked SQL Server job - powershell Where does “log to table” save logs
Nov
16
suggested rejected edit on With SSD's and in memory tables, does a snowflake schema become preferred over a star?
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