SQL Archives - Page 349 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Win USD 11,899 worth MSDN Subscription 5 Days to go

July 21, 2010

Few days ago, I had posted content SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN. It has received tremendous response to them. This competition is still open for 5 more days. I am sure you can win the subscription if you leave the best comment. Win $…

SQL SERVER – SELECT * FROM dual – Dual Equivalent

July 20, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Oracle

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 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…