127 reputation
17
bio website
location
age
visits member for 2 years
seen 23 hours ago

Jul
21
awarded  Popular Question
May
7
awarded  Notable Question
Mar
4
comment why stored procedure performance is very high compared to plain select query
i've updated questions.
Mar
4
revised why stored procedure performance is very high compared to plain select query
added 262 characters in body
Mar
4
asked why stored procedure performance is very high compared to plain select query
Oct
26
comment storing overrideable hierarchical settings in sql server
I'm going to use second approach for gain perfomance, would you please tell me what records should i add to RelationshipDistance table? can i store Distance in Nodes table?
Oct
23
awarded  Commentator
Oct
23
comment storing overrideable hierarchical settings in sql server
I've used first approach;currently i have somthing about 1000 settings.getting setting for a hierarchy takes 0.1~0.3ms (with extra joins), can i improve it? can we use HierarchyId datatype with provided by sql server
Oct
21
comment storing overrideable hierarchical settings in sql server
thanks again. The query for the first method has a minor bug, i think it should have distinct in select [distinct] name ....
Oct
15
comment storing overrideable hierarchical settings in sql server
Thanks for your solution
Oct
15
accepted storing overrideable hierarchical settings in sql server
Oct
15
revised storing overrideable hierarchical settings in sql server
added 306 characters in body
Oct
15
asked storing overrideable hierarchical settings in sql server
Jul
10
awarded  Popular Question
Nov
11
awarded  Supporter
Nov
11
accepted how to calculate difference of first row and last row fields value in each group
Nov
11
comment how to calculate difference of first row and last row fields value in each group
Thanks for you complete answer. that's what i needed.
Nov
10
asked how to calculate difference of first row and last row fields value in each group
Aug
14
awarded  Scholar
Aug
14
comment CROSS JOIN with temp table and CASE statement
Thanks Mr. AlexKuznetsov, your code works fine.