This account is temporarily suspended to cool down. The suspension period ends on Feb 10 '15 at 16:48.
1 reputation
139
bio website
location
age
visits member for 2 years, 10 months
seen Apr 18 at 9:44

Apr
3
comment How do I tell the actual IOPS used by Oracle?
Let's move the question to the dba's.
Apr
1
comment How to increase application performance with Centralised SQL Server
I agree with Rowland. And get a book. your questions has tons of data that is totally irrelevant and npo relevatn sthigns -llike you do not now anything about SQL you did not pull via copy / paste. A good intro book would help (SQL for dummies) with the obvious stuff. Like indices.
Feb
28
comment SQL Server- Table partitions on SSD
Well, says a lot about your systems. Check stackoverflow.com/questions/2701143/… for the reality.
Feb
28
comment SQL Server- Table partitions on SSD
Actually it is not - at least not signiciantly. It is faster because it forces the clustered index to be sensible - but if you do the same on a non-clustered table you have pretty much the same performance. BUt deletion is different. Care to read for example stackoverflow.com/questions/2701143/…
Feb
28
comment SQL Server- Table partitions on SSD
MANAGING LARGE DATA is ot querying. It is deleting. Try deleting 100 million rows of a 10 billin table. Compare that to swapping out the partition and using truncate on it. That is management. Not making a select faster which is executed based on the partition index statistics anyway.
Feb
28
comment SQL Server- Table partitions on SSD
-1. Because that is what the INDEX in the partition does. Funny enough it also does do without the partition, so it won't be MUCH faster. PArtitioning is about fast deletes of a complete partition.
Feb
28
answered SQL Server- Table partitions on SSD
Feb
16
awarded  Fanatic
Feb
10
answered Difference between oracle database desktop and server class
Feb
10
answered Query hangs forever at first but works after one day
Feb
10
comment Best practices for configuring the Drive/Filegroup setup for Microsoft SQL 2008
Yes. But if someone says "SCSI drives" then I assume he means that. YOu know. SCSI like SCSI bus with terminator. Do you know what SCSI stands for?
Feb
9
comment Copy a large data from sql query result
Are you aware that Excel can nicely just directly connect to Sql Server?
Feb
9
revised Best practices for configuring the Drive/Filegroup setup for Microsoft SQL 2008
added 42 characters in body
Feb
9
answered Best practices for configuring the Drive/Filegroup setup for Microsoft SQL 2008
Feb
7
comment what is best configuration for 50Gb database for mysql server 5.5
Windows. So, check performance counters and tell us whether you are ram problematic or have an IO problem or are CPU bound. Given that you put the data on the C drive I am inclined to assume this is not what most admins would consider a database server (with carefully planned IO patterns) and the typical low end installation is very likely to just get overloaded in the IO side.
Feb
5
comment Is there a well-known name for this “poor man's ref. integrity” schema design pattern?
Hm, the answer to that likely is "Misunderstanding" to something that could get censored here ;)
Feb
5
comment InnoDB: very bad performance on INSERT/UPDATE
If you care about tx efficiency all the way you need a bigger IOPS budget (if an IOTOP analysis shows that - please so that one). If you go that way, anything besides ssd is utterly stupid financially. THe next step up would be enterprise level SAS drives, and if you go IOPS/USD on those - dead. Like dead. By a factor of 100. SSD - a good one - is the best deal. Totally taking over the db space.
Feb
5
comment What are the SQL standards
WHat is your question here? You ask what they are - a standard and you already link to a complete answer. So the question is answered. What to make of them os basically opinion based - not a good topic on a site that does not like such questions. Besides that every product expands the standard anyway and I Think hardly any major db implements the complete one, so you can not even seriously try to be standards compliant outside smaller projects anyway.
Feb
5
answered InnoDB: very bad performance on INSERT/UPDATE
Feb
5
comment InnoDB: very bad performance on INSERT/UPDATE
Have you tried adding more cache? Your memory stats counter looks like the server is rather not using things.