Our company wants to move its Web site to a new host. Our database server uses SQL Server 7.0, but we lease the SQL Server license from the host. Our Web site receives roughly 1 million page views per day, and we want to buy our own SQL Server...
I have a table that holds about 60 million rows. The primary key is an integer column that I maintain by using a NextID table. Because no columns in the table are subject to a range search, I chose a clustered index to maximize the performance of...