Tips And Tricks For Advanced MS SQL Server Developers:
Use “TRUNCATE TABLE” statement instead of “DELETE” clause if you want to delete all rows from a table. It is much faster then “DELETE” statement without any conditions. “TRUNCATE TABLE” frees all the space occupied by that table’s data and indexes, without logging [...]
Filed under: SQL Tricks | Tagged: Advance SQL tips and tricks, Author Raghunath Bhandari, Database, Database Optimization Tips, dba, DBA help, MCP, Microsoft Certified Professional, Microsoft SQL server, MSDN Help, MSDN SQL News, MSSQL, MSSQL server, SQL, SQL Database Optimization Tricks, SQL Database Settings Optimization Tips, SQL developer tips, SQL Documentation, SQL help, SQL Indexing Service, SQL Optimization, SQL Optimization Tips, SQL Query, SQL Server, SQL server tips, SQL technology, SQL Tips, SQL Tips and Tricks, SQL tips for programmer, sqlhelp, sqlhelp news, sqlhelp WebSite Review, T-SQL, Technology News, Tips And Tricks For Advanced MS SQL Server Developers | Leave a Comment »
