Category: FAQ
How can I create a cluster out of two independent SQL Server boxes?
How do I deal with a SQL Server cluster that is not acting properly?
We have five SQL Servers and want to not only upgrade, but to cluster these servers as well.
I've been under the impression that joins are costly and should be kept to a minimum. Is this true?
How do I estimate how large a database will grow?
I don't know how to transfer an array to a table, and I even if I can, I don't know if it will be any faster than using INSERT INTO?
Is there any performance difference between using SET or SELECT to assign values in Transact-SQL?
I want to add an identity or unique identifier column to a table in order to ensure that each row is unique. For best performance, which one should I use?
When creating temp tables within a stored procedure, is it good practice to drop them as soon as they are no longer required?