Pinal Dave - SQL Server Performance Tuning Expert

SQLAuthority News – SQL SERVER 2008 R2 Pricing

March 8, 2010

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…