Category: Performance Tuning
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?
Does SQL Server support table partitioning?
Which is faster when using SQL Server 2000 or 2005, temp tables or the table datatype?
My application makes heavy use of temp tables. Should I be creating temp tables as needed, or should I be using a permanent table over and over instead?
Is is more efficient to use SELECT DISTINCT or GROUP BY to perform the same function?
Should I use the old Microsoft JOIN syntax, or the ANSI JOIN syntax for the best JOIN performance?
I don't like to delete records in our production database, even though we will never need them again. Does this affect performance?