This is a very common concept that truncate cannot be rolled back. Let us learn in today’s blog post that Rollback TRUNCATE is possible.
SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT
Recently I wrote about SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT I mentioned about how TOP works with INSERT. I have mentioned that I will write about the performance in next article. Here is the performance comparison of the two options.
SQLAuthority News – Excellent Event – TechEd Sri Lanka – Feb 8, 2010
TechEd Sri Lanka was held at Waters Edge, Colombo between Feb 8 and Feb 10, 2010. It was one of the largest successful technical event in Sri Lanka. I was extremely surprised to how technically sound this event was and how excited the TechEd attendees were. I presented there on…
Read MoreSQL SERVER – Data and Page Compressions – Data Storage and IO Improvement
The performance of SQL Server is primarily decided by the disk I/O efficiency. Improving I/O definitely improves the performance. SQL Server 2008 introduced Data and Backup compression features to improve the disk I/O. Here, I will explain Data compression. Data compression implies the reduction in the disk space reserved by…
Read More