All Articles - SQL Authority with Pinal Dave

SQLAuthority News – SQL Server Modeling CTP – Nov 2009 Release 2 (formerly Oslo)

March 6, 2010

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Note : Download SQL Server Modeling CTP – Nov 2009 Release 2 (formerly Oslo) by Microsoft SQL Server Modeling (formerly code name “Oslo”) is a set of future technologies that provide significant productivity gains across the lifecycle of .NET applications by enabling developers, architects, and IT professionals to work together…

SQL SERVER – Order of Columns in Update Statement Does not Matter

March 5, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

I recently received few comments that I have not written on simple subjects recently. In fact, this blog is dedicated to all those who are really learning SQL Server and almost all the articles and posts are posted here keeping this goal in mind. One of the questions in the…

SQL SERVER – Rollback TRUNCATE Command in Transaction

March 4, 2010

Pinal Dave

SQL Tips and Tricks

DML Operation, SQL Scripts, SQL Server, Transaction Log

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

March 3, 2010

Pinal Dave

SQL Performance

SQL Index, SQL Scripts, SQL Server

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

March 2, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

CDC, Database, MVP, SQL Index, SQL User Group, SQLAuthority Author Visit

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…

SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement

March 1, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Index, SQL Scripts

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…

SQLAuthority News – Hyderabad Techies February Fever Feb 11, 2010 – Indexing for Performance

February 28, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Index, SQL User Group

I recently presented in Hyderabad User Group on the subject of The Other Side of SQL Server Index: Advanced Solutions to Ancient Problem , you can read more about this event here SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review. I really had…

SQL SERVER – INSERT TOP (N) INTO Table – Using Top with INSERT

February 27, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Scripts

During my recent training at one of the clients, I was asked regarding the enhancement in TOP clause. When I demonstrated my script regarding how TOP works along with INSERT, one of the attendees suggested that I should also write about this script on my blog. Let me share this…

SQLAuthority News – Keeping Your Ducks in a Row

February 26, 2010

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Last year during my visit to SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2 I have received ducks from the event. Well during the same event I had learned from Jonathan Kehayias the saying of ‘Keeping Your Ducks in a Row‘. The most popular theory suggests that…

SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review

February 25, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQL Index, SQL Training, SQL User Group, SQLAuthority Author Visit

Earlier this month, I was very fortunate to visit Microsoft User Group Hyderabad lead by Hima Vindu Vejella. Hima is a very enthusiastic leader and kind person. I had a wonderful time meeting her as well her husband during my visit to Hyderabad. I had presented session on Index, which…