SQL Server Add Not Null Column to Existing Table
Most of you must have come across the pain of adding a not null column with a default value to an existing big table. It takes minutes to SQL Server Add …
Read MoreTag: Performance tuning and optimization
SQL Server Stored Procedures – Use of Recompile Clause
Hi Friends, Today here, I am explaining the Use of Recompile Clause in SQL Server Stored Procedures. We use stored procedures in sql server to get the benefit of reusability. Some …
Read MoreSQL Server 2012 – “Denali” Database Tuning Advisor (DTA): Tune a database using Plan cache.
Hi friends, Just came across Database Tuning Advisor new feature in SQL Server 2012. It can now tune the events from the plan cache directly. This is a very good option …
Read More