Category: FAQ
When I upgraded by database to the newest version, performance is now much slower. Why?
Our query used to take 30 seconds, and now it takes over 30 minutes. Why?
When should primary keys be used?
Can I programatically tell SQL Server how to allocate CPU resources?
For best performance, should we install Analysis Service and the cubes as the same server as the production database?
A view runs on our development server in 30 seconds, but it takes over 10 minutes on the production server. Why?
T-SQL code in script run faster than it does as a stored procedure. Why?
How many indexes can I add to the table before performance degrades?
We have an IBM Netfinity server with two network cards. One network connection changes from 100MBs to 10MBs. Is this normal?