SQL Tips and Tricks Archives - Page 269 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Quiz and Video – Introduction to Discovering XML Data Type Methods

May 11, 2012

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] This is follow up blog post of my earlier blog post on the same…

SQL SERVER – Quiz and Video – Introduction to SQL Error Actions

May 10, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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] This is follow up blog post of my earlier blog post on the same subject – SQL SERVER…

SQL SERVER – Quiz and Video – Introduction to Basics of a Query Hint

May 9, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros

This blog post is inspired from SQL Architecture Basics Joes 2 Pros: Core Architecture concepts – SQL Exam Prep Series 70-433 – Volume 3. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up blog post of my earlier blog post on the same subject – SQL SERVER – Introduction to Basics…

SQL SERVER – Quiz and Video – Introduction to SQL Server Security

May 7, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros

This blog post is inspired from Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners – SQL Exam Prep Series 70-433 – Volume 1. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up blog post of my earlier blog post on the same subject – SQL SERVER – Introduction…

SQL SERVER – Migrate a SQL Server Reports from one server to another server

May 5, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SQL Utility

How many time you have felt that there should be need of the tool which help you to migrate SQL Server Reports from one server to another server. Well, I am glad to see this migration tool for migrating reports from SQL Server 2008 R2 and later version. This tool…

SQL SERVER – Identify Columnstore Index Usage from Execution Plan

May 4, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

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…