307 reputation
212
bio website none
location Belgrade, Serbia
age 39
visits member for 1 year, 6 months
seen 16 hours ago

Nothin' much


Aug
14
awarded  Yearling
Jul
2
awarded  Curious
Aug
9
revised How to Join Two Result sets to query on output came from Two statements
added 162 characters in body
Aug
9
comment How to Join Two Result sets to query on output came from Two statements
You are right. Though it looks to me it might be quicker with joins depending on data.
Aug
9
comment How to Join Two Result sets to query on output came from Two statements
Are you sure this is correct ? You don't have join in subquery.
Aug
9
revised How to Join Two Result sets to query on output came from Two statements
added 466 characters in body
Aug
9
answered How to Join Two Result sets to query on output came from Two statements
May
29
comment Is it a bad practice to always create a transaction?
So you are saying that 100000 transactions are slower than one ? Just kidding, interesting test. Looks logical now but had you asked me to look at queries I would have guessed wrong.
May
28
comment Is it a bad practice to always create a transaction?
Transaction for select ? As if you are gonna rollback select ?
May
26
awarded  Critic
May
26
revised Linked Servers pointing to same server (localhost) causing “Transaction context in use by another session” error
added 71 characters in body
May
26
answered Linked Servers pointing to same server (localhost) causing “Transaction context in use by another session” error
May
20
comment IIS takes longer to run queries than SMSS
@AaronBertrand True.
May
11
awarded  Enthusiast
May
9
awarded  Vox Populi
May
9
awarded  Suffrage
May
9
comment Automatic decimal rounding issue
What do you mean "Don't do calculations in SQL language" where would you do them ?
May
9
revised How can I reliably track stored procedure ( and functions ) use over time?
added 597 characters in body; edited title
May
9
comment How can I reliably track stored procedure ( and functions ) use over time?
I get that I need to monitor activity over a period of time, lets say two months. I could use profiler, I could use procedure stats ( but need to know if there are cases when procedures are not written or deleted from planed_cache ), I could modify every stored procedure to write when its being used... In any case, question is not the same and is far from being answered even if it is same !
May
9
revised How can I reliably track stored procedure ( and functions ) use over time?
added 1 characters in body