Partitions only help performance in some cases -- it depends on your indexes vs. your partition function and the kind of locking you need. Looking...
As I said, one thing that will affect performance in a very significant way is to move your database log onto its own disk. Having the log on the...
The fact that you have log files on the same drive as data files will explain why write operations are slow. Regarding read operations, you might try...
The size of the main DB doesn't directly affect how much tempdb space you need. It depends on the queries that you're issuing, including things like...
It's hard to say anything too meaningful unless you can post your table and index definitions. Memory and disk details would be helpful too, as...
That's like saying "I don't feel well, what might be wrong?" There are too many possibilities for a short response on a forum to be useful. You...
Your SP may be able to just have 5 different INSERT statements. Same for UPDATE and DELETE. You can also have 5 SELECT statements, although that...
I think you mean "precision" ...
The set isolation level command sets the per connection isolation level, not per server or per login. If you can catch the system when it's behaving...
You can use an argument for TOP, but it needs to be in parens. Like this: declare @nrows int select top (@nrows) YourColumn from YourTable
Another thing to consider is that you may not need SQL Enterprise everywhere. Are there places in your shop where you can use SQL Standard or...
With a US$1500 budget, you don't have too many options. For SSAS only, maybe something like a fast Core-2 Duo with two 15k rpm disks, plus enough...
The other idea I had in mind was to reorganize your drives in a way that would increase IOPS. Something like this: Volume A: 14x750 GB, RAID 5,...
What concerns me about the IOPS you posted is that SQL write performance is largely determined by log disk speed (at least until RAM fills up), and...
OK, to summarize, is this correct? Volume A: 7x750 GB, RAID 5, 1 TB partition, data only Volume B: 7x750 GB, RAID 5, 1 TB partition, logs only...
It might help if you could post your schema as well, but a common reason for such a big jump in execution time is because the query needs to do a...
There is definitely overhead for each DB query round-trip. With LINQ, there is also additional overhead to process the generated dynamic SQL. If...
How are you closing your connections? Do you have all SqlConnection objects wrapped in using statements or try/finally blocks? Are you calling...
I prefer joins over subqueries. The SQL optimizer can sometimes transform a subquery into a join, but not always. Plus, I think the join more...
Are the two systems running the same edition of SQL and Win 2008? Do they have the same amount of RAM? Same/similar disk subsystems? Are you...
Separate names with a comma.
