Does SQL Server support table partitioning? - 17 Oct 2006

When creating temp tables within a stored procedure, is it good practice to drop them as soon as they are no longer required? - 17 Oct 2006

Is there any performance difference between using SET or SELECT to assign values in Transact-SQL? - 17 Oct 2006

Can you tell me more about the processor queue length? - 16 Oct 2006

Is there any way to allocate processor utilization to SQL Server jobs? - 16 Oct 2006

Is it better to have one large server running multiple databases, or several smaller servers running one database each? - 16 Oct 2006

Is there any benefit for me in turning on the “lightweight pooling” SQL Server configuration option? - 16 Oct 2006

Is there a practical limit to the size of a table I can pin into memory? - 16 Oct 2006

Why isn’t my SQL Server taking full advantage of all the RAM I have available in my server? - 16 Oct 2006

We have recently added a second processor to our SQL Server box. How can I configure it to take advantage of the new processor? - 16 Oct 2006