222 reputation
210
bio website mansandersson.se
location Sweden
age 27
visits member for 2 years, 4 months
seen Oct 17 at 7:26

Oct
4
awarded  Popular Question
Sep
8
awarded  Notable Question
Jul
2
awarded  Curious
Oct
8
awarded  Popular Question
Sep
27
awarded  Popular Question
Sep
4
awarded  Popular Question
Jun
11
awarded  Yearling
Jan
7
accepted How much do foreign keys affect performance?
Dec
28
comment How much do foreign keys affect performance?
@IanYates Yes, there are performance problems. Foreign Keys are just one thing that could be the problem...have already fixed index rebuild and statistics updates and such.
Dec
28
comment How much do foreign keys affect performance?
@MartinSmith Yes I think so. The database has many tables and I have no real idea of how they join together so I can't swear it's true for all of them, but at least for some it is.
Dec
28
asked How much do foreign keys affect performance?
Nov
29
accepted SELECT multiple sensor values in one query
Nov
29
comment SELECT multiple sensor values in one query
You've got skills. Have cut the loading times of some pages by more than 50% thanks to your solution. Thank you very much! (answer upvoted and accepted)
Nov
27
comment SELECT multiple sensor values in one query
@JNK I suppose you mean something like this made2mentor.com/2011/04/calendar-tables-why-you-need-one. But I can't actually see how that would help me. I would certainly get rid of the partition lookup but I would still have trouble getting the latest value for each sensor, wouldn't I? I'm using the partition lookup to speed things up since I have a couple of million values per sensor. And a couple of thousand sensors. I.e. it's a large table and I'm using it to help SQL Server to pinpoint which partition to look at and not to look at.
Nov
27
asked SELECT multiple sensor values in one query
Jun
20
revised SELECT every nth value by Date from large table
Rewrote the question for better clarity of what I have, I do and I want to achieve.
Jun
18
comment SELECT every nth value by Date from large table
My bad, Date is integer but can be represented (by recalculation) as a string which I displayed for easier interpretion. I've also improved my example.
Jun
18
revised SELECT every nth value by Date from large table
improved example
Jun
18
comment SELECT every nth value by Date from large table
I'm truly sorry, must have interpreted your messages wrongly. I appreciate any help I get and tries to improve my question based on all input I get and will keep doing so (my question is updated with the above information).
Jun
18
revised SELECT every nth value by Date from large table
improved description of problem