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

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
Mar
16
reviewed No Action Needed NoSQL approach: design table “scheme”
Mar
10
comment db INDEX on ORDER BY FIELD in very simple query does not help - still slow response?
I dont know anything about db2, but assuming it is similar to SQL Server, did you try a clustered index instead of a non clustered index (since you are using a select * query)?
Jan
15
comment Fetch Records alternatively from database
hmm.. apparently theres no straightforward way to do it in MySQL since it doesn't have the equivalents of a CTE or RowNumber, so any method I suggest would be hacky. Probably try out Neo's answer if it works for you (and take ahofmann's advise for the future)
Jan
15
comment Fetch Records alternatively from database
Don't know if its possible in MySQL, but how about using a ROWNUMBER() over Date_Time , join the CTE with itself, with the join condition as rownumber+1 and a where condition to filter out records where the left rownumber is even or the right rownumber is odd
Jan
15
comment Stateful views in SQL Server
@despicable updated answer with more info
Jan
15
revised Stateful views in SQL Server
added 563 characters in body
Jan
14
comment How does paging work with ROW_NUMBER in SQL Server?
Ah, you're right, theres a performance difference. I had read this: blogs.technet.com/b/dataplatforminsider/archive/2011/11/01/… where he mentions no difference, but just saw channel9.msdn.com/posts/SQL11UPD03-REC-02 where he shows theres a lot of difference.. (though in the audio underemphasis the performance difference)
Jan
14
comment How does paging work with ROW_NUMBER in SQL Server?
Should be noted though that OFFSET/FETCH NEXT do not offer any performance benefits over the CTE method