Category: FAQ
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?
Does running the SQL Server Index Wizard or the Database Engine Tuning Advisor find all of the tables in my database that need indexing?
How do I restore a Master Database in a SQL Server 7.0 or 2000 clustering environment?
Is there any significant performance difference when joining tables across different databases on the same server?
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?