Category: Performance Tuning
Is there any significant performance difference when joining tables across different databases on the same server?
My SQL Server seems to take memory from the operating system, but never releases it. Is this normal?
My application is very INSERT heavy. What can I do to speed up the performance of INSERTs?
What is the difference between DELETE and TRUNCATE? Is one faster than the other?
What happens when SQL Server executes a stored procedure or query ?
What happens during the rebuild of a clustered index?
Is it possible to keep the entire database in memory?
Why can it take so long to drop a clustered index?