SQLShare SQL Channel

The SQL Channel

Tags

Most Watched Videos

	Speak Like a SSIS Developer (Watch it Later!)

	Windows and SQL Server 2005 Clustering Architecture (Watch it Later!)

	Clustering SQL Server 2005 (Watch it Later!)

	Looping Through and Loading Files with SSIS (Watch it Later!)

	Change Data Capture with SSIS (Watch it Later!)

This channel is dedicated to SQL Server and the technologies that surround it. You'll find videos about SSIS, Replication, Performance and more. Check back daily for updated content.

Using Index Hints in a Query (Watch it later!)

	Featured Video
Date Published: Thursday, September 02, 2010 Author: Andy Warren Rating: 4.30

Description: Index hints are a way to force SQL Server to use a particular index to process a query. It won't change the results you get, but it can dramatically change performance in a very few cases where the optimizer fails to find the right index. It can cause queries to fail if the index is renamed or deleted. It's a tool that you will rarely use, but when you need it, it's a very nice thing to know about.

New Releases

Creating a Plan Guide for a Parameterized Statement (Watch it Later!)

Date Published: August 31, 2010

Author: Andy Warren

Rating: 4.17

Description: Plan guides are a great tool to know, providing a simple way to tweak the behavior of a query when you're not able to change the source statement directly. Today we'll show you how to create a plan guide for a parameterized statement executed via sp_executesql, and we'll throw in a demo of using OPTIMIZE FOR as a bonus!

Controlling Plan Guides (Watch it Later!)

Date Published: August 31, 2010

Author: Andy Warren

Rating: 4.24

Description: Plan guides enable you to add or remove OPTION hints from a query, giving you the ability to tweak the behavior of queries emitted from third party applications. In this lesson we're going to do a very quick demo of creating a plan guide, and then show you how you can control when they run by using sp_control_plan_guide to enable, disable, or drop them as needed.

	Reporting Services Formatting Codes (Watch it Later!) Date Published: July 27, 2009 Author: Jessica Moss Rating: 4.20 Description: Formatting data in a Reporting Services 2008 report is as simple as typing a couple of letters! SQL MVP Jessica Moss will show you how this is done.

Multistatement UDF's in SQL Server (Watch it Later!)

Date Published: January 28, 2009

Author: Andy Novick

Rating: 4.39

Description: Multistatement user defined functions are an interesting way to package and reuse code. This video by well known author Andy Novick shows you what multistatement user defined functions are and how to create them in your SQL Server database. Worth watching!

Explaining The Properties Window in SQL Server Profiler (Watch it Later!)

Date Published: October 13, 2008

Author: Jack Corbett

Rating: 3.88

Description: This video explains the options available in the properties window when creating a new trace in SQL Server 2005 Profiler. Do you know what server processes trace data means? Or what file rollover is? SQL Jack explains the basics!