Tag Info

New answers tagged

1

Paul White's answer is wonderful from the SqlServer point of view. I know this site isn't really about C# code review but I feel like I would be remiss if I didn't mention a couple of things about your data access code. Plus some errors in your C# code affect your stated assumptions. Firstly, your sample code may have been edited for brevity but just in ...


8

My guess is, that because I have an aggregation, the server has to process all rows anyways, therefore the impact is not that high. Speaking from a SQL Server perspective, it depends. Here is an overview of what it depends on, and why: Row Goals Adding a top-level TOP (n) clause (with or without ORDER BY) has the same row goal effect as if a FAST (n) ...



Top 50 recent answers are included