165 reputation
15
bio website ronpaul2012.com
location
age
visits member for 1 year, 11 months
seen yesterday

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


Mar
6
comment Is it possible to replicate wide table in MS SQL?
I agree. I've tried and could not even add wide table using sp_addarticle with , @vertical_partition = N'true'. It's also not allowed to add it MS SQL Studio UI.
Mar
6
accepted Is it possible to replicate wide table in MS SQL?
Feb
25
revised Is it possible to replicate wide table in MS SQL?
info about custom replication SPs, added transactional-replication tag
Feb
25
comment Is it possible to replicate wide table in MS SQL?
XML column will be my next possible choice, but I cannot index them and also cannot update them as separate columns.
Feb
21
asked Is it possible to replicate wide table in MS SQL?
Jul
11
awarded  Notable Question
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