network profile
| bio | website | ronpaul2012.com |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year |
| seen | Apr 2 at 16:19 | |
| stats | profile views | 2 |
email me to 8350@alpav.com and put so8350 anywhere in subject, otherwise I will not respond
Those who served in military represent smarter part of our society, I did not realize that until I watched this: http://www.youtube.com/user/EndorseLiberty?v=AwbBWEljyYE
|
Oct 23 |
awarded | Popular Question |
|
May 21 |
comment |
How to boost performance of virgin queries in MS SQL Server? @Remus: Your guess was good, my web site queries are 100% analytical. It allows users to construct any possible queries in UI to send any possible combination of filters, aggregates and groupings to SQL Server (which, of course, makes indexing tough). Yes, I could make them to run in async mode saving results for later retrieval, but the goal is to make any query to run so fast that result is immediately available after 2-10 seconds and also analytical querying is the only function of that website,I think making them async makes sense only if there are other queries that are not analytical. |
|
May 21 |
awarded | Scholar |
|
May 21 |
accepted | How to boost performance of virgin queries in MS SQL Server? |
|
May 21 |
awarded | Supporter |
|
May 18 |
comment |
How to boost performance of virgin queries in MS SQL Server? What do you mean by "this behavior" ? I didn't mention that something is going wrong. I just want to boost performance under my special circumstances. SQL Server is optimized to run in any situation, but it may or may not not run the best way in my situation. I am not sure if I can trust SQL Server to make balanced choice #1 vs #2. Every time I put new data on it I run sp_updatestats. |
|
May 18 |
awarded | Editor |
|
May 18 |
revised |
How to boost performance of virgin queries in MS SQL Server? clarification about read-only database, dedicated box, existing indexes, sql server 64 bit |
|
May 18 |
comment |
How to boost performance of virgin queries in MS SQL Server? ok, let's assume that there are already right indexes. I forgot to mention that this is read-only database with read-only queries and there are no other application running on SQl Server box. |
|
May 18 |
asked | How to boost performance of virgin queries in MS SQL Server? |
|
Apr 25 |
awarded | Student |
|
Apr 24 |
asked | Does it ever make sense to use RAM Disk to force RAM allocation for tempdb with SQL Server 2008 |
