We have an IBM Netfinity server with two network cards. One network connection changes from 100MBs to 10MBs. Is this normal? - 09 Oct 2006

How many indexes can I add to the table before performance degrades? - 09 Oct 2006

T-SQL code in script run faster than it does as a stored procedure. Why? - 09 Oct 2006

A view runs on our development server in 30 seconds, but it takes over 10 minutes on the production server. Why? - 09 Oct 2006

For best performance, should we install Analysis Service and the cubes as the same server as the production database? - 09 Oct 2006

Can I programatically tell SQL Server how to allocate CPU resources? - 09 Oct 2006

When should primary keys be used? - 09 Oct 2006

Our query used to take 30 seconds, and now it takes over 30 minutes. Why? - 09 Oct 2006

When I upgraded by database to the newest version, performance is now much slower. Why? - 09 Oct 2006

We have two stored procedures taking five minutes to run in our development database, but the same stored procedures run quickly on our QA database. Why? - 09 Oct 2006