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

SQL SERVER – Introduction to Basics of a Query Hint – A Primer

April 25, 2012

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

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] Basics of a Query Hint Query hints specify that the indicated hints should be used throughout the query. Query hints affect…

SQL SERVER – Introduction to Hierarchical Query using a Recursive CTE – A Primer

April 24, 2012

Pinal Dave

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

Joes 2 Pros

This blog post is inspired from SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008 – SQL Exam Prep Series 70-433 – Volume 2. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] What is a Common Table Expression (CTE) A CTE can be thought of as a temporary result…

SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties

April 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Filestream, SQL Scripts, SQL Server

Read Part 1 Working with FileTables in SQL Server 2012 – Part 1 – Setting Up Environment
Read Part 2 Working with FileTables in SQL Server 2012 – Part 2 – Methods to Insert Data Into Table
In this third part of the series, we will see how we can retrieve various information from the FileTable database.

SQL SERVER – Performance Tuning – Part 2 of 2 – Analysis, Detection, Tuning and Optimizing

April 20, 2012

Pinal Dave

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

SQL Utility

This second part of Performance Tuning – Part 1 of 2 – Getting Started and Configuration. I suggest you read the first part before continuing on this second part. Analysis and Detection If you have noticed that configuration of the data source and profile is a very easy task and if you…

SQL SERVER – Performance Tuning – Part 1 of 2 – Getting Started and Configuration

April 19, 2012

Pinal Dave

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

SQL Utility

Performance tuning is always a complex subject whenever one has to deal with it. When I was beginning with SQL Server, this was the most difficult area for me. However, there is a saying that if one has to overcome their fear one has to face the fear first. So…

SQLAuthority News – Select the Best SQL in Sixty Seconds Episode – Help us Improve

April 18, 2012

Pinal Dave

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

Database

It has been more than 3 months since we have started experimenting with a new concept in SQL in Sixty Seconds. Every Wednesday, we putt a fresh new interesting concept out via video. Rick Morelan, Vinod Kumar and myself – the three of us decided to do something new and something exciting. We decided to…

SQLAuthority News – Presenting at Great Indian Developer Summit 2012 – SQL Server Misconception and Resolutions

April 16, 2012

Pinal Dave

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

SQLAuthority Author Visit

Earlier during TechEd 2012, I presented a session on SQL Server Misconception and Resolutions. It was a pleasure to present this session with Vinod Kumar during the event. Great Indian Developer Summit is around the corner and I will be presenting there once again with the same topic. We had…