SQL Server Archives - Page 149 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Identify Columnstore Index Usage from Execution Plan

May 4, 2012

I think there was a time when lots of questions were coming via either email or blog comments. Nowadays, the trend seems to change. Most of the question I receive is through social media. Here is the latest question I received through Twitter. The best or worst part of Twitter…

SQL SERVER – A Tricky Question and Even Trickier Answer – Index Intersection – Partition Function

May 3, 2012

Pinal Dave

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

SQL Index, SQL Scripts

During yesterday’s evening, I asked a very simple question on my Facebook Page. The question was written in a jiffy and in a very light mood. While writing the question, I left a few things out, and the question did miss a few details about setup. However, as the question was…

SQL SERVER – Video – Step by Step Installation of SQL Server 2012

May 2, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database

SQL Server 2012 launched on March 7, 2012. SQL Server 2012 was available on April 1, 2012 for General Availability. Recently I have received quite a few queries that they are facing issues with SQL Server 2012 installation. I have tried to solve quite a few problems and I figured…

SQL SERVER – A Brief Introduction to expressor Studio 3.6

April 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Data is powerful. Data drives businesses. Data supports decision making and fuels progress. But managing data—making data work for us—isn’t inherently easy. And if there is one thing that is certain, it’s change—meaning that data systems created yesterday will need to be adapted to fit ever evolving needs. Since we…

SQLAuthority News – Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments – Part 1

April 28, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download, SQL White Papers

Migration is always a challenge. How many times we have stayed away from migrating product to another server or next version because we are worried what will happen once we migrate. There are two main reasons we stay away from migration 1) Everything is working fine at this moment. 2)…

SQL SERVER – Introduction to Discovering XML Data Type Methods – A Primer

April 27, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Joes 2 Pros

This blog post is inspired from SQL Interoperability Joes 2 Pros: A Guide to Integrating SQL Server with XML, C#, and PowerShell – SQL Exam Prep Series 70-433 – Volume 5. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] What are XML Data Type Methods The XML data type was first introduced with…

SQL SERVER – Introduction to SQL Error Actions – A Primer

April 26, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Joes 2 Pros

This blog post is inspired from SQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 – SQL Exam Prep Series 70-433 – Volume 4. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] Introduction to SQL Error Actions Most people believe that when SQL Server encounters an error severity level…