Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – SELECT * FROM dual – Dual Equivalent

July 20, 2010

This blog post is for all the Oracle developers who keep on asking for the lack of “dual” table in SQL Server. Here is a quick note about DUAL table, in an easy question-and-answer format. What is DUAL in Oracle? Dual is a table that is created by Oracle together…

SQL SERVER – Identifying Statistics Used by Query

July 19, 2010

Pinal Dave

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

SQL Scripts

“Can I know which statistics were used by my query?” Recently, someone asked this question in my training class of query optimization and performance tuning. I really liked the question. The answer for me is very simple. “No.” Well, if I stop here suggesting only “No,” it will be an…

SQLAuthority News – SQL Server Quickstart Downloads from Microsoft

July 18, 2010

Pinal Dave

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

SQL Documentation, SQL Download, SQL White Papers

Here are few recent published by Microsoft. Application Platform Optimization SQL Server Migration QuickStart The SQL Server Migration QuickStart includes a comprehensive set of technical content including presentations, whitepapers and demos that are designed to help you get details about how to approach your customers who want to improve the…

SQLAuthority News – Community TechDays, Ahmedabad – July 24, 2010

July 17, 2010

Pinal Dave

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

SQL Spatial, SQLAuthority Author Visit

Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Build real connections with Microsoft experts and community members, and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. What more… you…

SQL SERVER – Datetime Function TODATETIMEOFFSET Example

July 16, 2010

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

Earlier I wrote about SQL SERVER – Datetime Function SWITCHOFFSET Example. After reading this blog post, I got another quick reply that if I can explain the usage of TODATETIMEOFFSET as well.

SQL SERVER – Datetime Function SWITCHOFFSET Example

July 15, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I was recently asked if I know how SWITCHOFFSET works. This feature only works in SQL Server 2008. Here is quick definition of the same from BOL: Returns a datetimeoffset value that is changed from the stored time zone offset to a specified new time zone offset. What essentially it…

SQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010

July 14, 2010

Pinal Dave

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

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

I will be presenting two SQL Server advance level sessions at SQL Data Camp @ Chennai. I am very excited for this event as I am going to meet my friends Sugesh, Deepak, Vidhya and Madhivanan at this event. All of them are SQL Server MVPs. I have come to…