Is Performance Better With LEFT JOIN or RIGHT JOIN?

I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...

Introduction to Azure DocumentDB

This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.

What is...

Database snapshot captures only data changes or it will also save real database from DDL changes ?

Question : Database snapshot captures only data changes or it will also save real database from DDL changes (like table structure,...

Fresh New Horror: PK on a Float Data Type

Here's a new thing to be scared about in the night, as if you weren't already terrified of floats after...

SQL Server 2016 Announced, and it stretches to the Cloud!

Last week during Ignite, Microsoft CEO Satya Nadella announced the next version(Till then it was called as SQL vNext) of...

Editing Table Rows in SQL

When you create a database driven website, you actually write SQL scripts to insert data into the database. You also...

SQL Server in Azure

There are two flavors of SQL Server in Azure: one is the traditional SQL Server platform hosted in Azure virtual machines,...

A Week to SQL Saturday #393 – Redmond

Only my second SQL Saturday of the year (wow), but SQL Saturday #393 is next week in Redmond, WA. This...

SQL SERVER Interview Questions

All you who wants to pursue professional life as  SQL SERVER DBA, its always hard to crack the interview . But...

Bringing Together Databases, Virtualization and Storage

A few weeks ago Bala Narasimhan from PernixData and I recorded a short conversation where we discussed the tips and tricks...