All Articles - SQL Authority with Pinal Dave

SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting

March 10, 2010

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

Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort Link to Amazon (Worldwide) Link to Flipkart (India) Brief Review: Having a book on internal and associating that with real life is “almost” an impossible task. The reason for using the word…

SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index

March 9, 2010

Pinal Dave

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

SQL Index, SQL Scripts

This blog post is in the response of the T-SQL Tuesday #004: IO by Mike Walsh. The subject of this month is IO. Here is my quick blog post on how Cover Index can Improve Performance by Reducing IO. Let us kick off this post with disclaimers about Index. Index…

SQLAuthority News – SQL SERVER 2008 R2 Pricing

March 8, 2010

Pinal Dave

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

I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing. Official site: What’s New in SQL Server 2008 R2 Editions Editions Per Processor PricingRetail Per Server Plus CAL PricingRetail Parallel Data Warehouse $57,498 Not offered via Server CAL Datacenter $57,498…

SQLAuthority News – Office 2010 Readiness Check – Are you ready for Office 2010?

March 7, 2010

Pinal Dave

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

Business Intelligence, Office2010, PowerPivot

PowerPivot for Excel is a data analysis tool that delivers unmatched computational power directly within the application users already know and love—Microsoft Excel. Office 2010 is the next version of Office 2010. We all know Office 2010 is on the verge of getting released and the reviews available online say…

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

March 6, 2010

Pinal Dave

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

SQL Documentation, SQL Download

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…