Welcome to SQLShare

Hot Topics

Backup & Restore

SQL Azure

Featured Video

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.

This is a preview.
Click the title above to see the whole video.

Upcoming Events

Event Date

Title

Description

iCal

Sep 8 2010 2:00PM Central

Webinar: Building a Data Mart with Integration Services (Free)

Understanding current trends in business conditions often requires asking a lot of questions, but allowing users to run query after query against your operations databases causes more problems than it solves. By creating a data mart, you can maintain a separate data store that can withstand the heavy query load that business analysis demands.

SQL Blog Posts

Title

Summary

Blog

Feed

Free SQL Server Training for the Week of August 16, 2010

Have you registered for the 24 Hours of PASS (September 15-16) yet? Tuesday SQL Lunch - Policy Based Management in a Nushell - Jorge Segarra Pragmatic Works - Using Microsoft BI (PowerPivot) for...

K. Brian Kelley - Databases, Infrastructure, and Security

http://www.sqlservercentral.com/blogs/brian_kelley/rss.aspx

SQL Server 2008 SP1 Too Old for Replication?

SQL Server 2008 SP1 To Old for Replication? We are in the middle of a platform upgrade project at work, and I was setting up replication on a newly flattened and rebuilt server with Windows Server 200...

SQL Server Soldier :: News from the frontlines of the database wars

http://www.sqlservercentral.com/blogs/robert_davis/rss.aspx

A Quick Look at the MPP World

David Poole takes a look at the Massively Parallel Processing world for database servers.

SQLServerCentral

Using Dynamic Management Objects to Monitor I/Os Against an Instance of SQL Server

To ensure that queries run as efficiently as possible, the database administrator needs to monitor performance to find inefficient queries. This article focuses on exploring how a DBA can monitor the ...

SQLServerCentral

Check Sharepoint Version with SQL

No summary available

This Blog Linked From Here The Web This Blog Linked From Here .The Web . SQL Tact

The Impact of Non-Updating Updates

From time to time, I encounter a system design that always issues an UPDATE against the database after a user has finished working with a record – without checking to see if any of the data was in fac...

Page Free Space: Paul White

http://sqlblog.com/blogs/paul_white/rss.aspx

ISV Applications versus In-House Applications

I've written a series on creating an Application Profile for your organization, which allows you to create a strategic plan on everything from Business Continuity to Disaster Recovery, but many of us ...

Carpe Datum

http://blogs.msdn.com/b/buckwoody/rss.aspx

Error connecting to SQL Azure - “An error has occurred while establishing…”

You might get the following error when connecting to SQL Azure: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused ...

Lee Everest's SQL Server, etc, weblog

Index Tuning Advisors

One of the benefits I have working for Confio is that I get some exposure to multiple database platforms (Oracle, DB2, SAP Sybase, and MS SQL). And along with those multiple platforms I also get to lo...

SQLBatman.com

Backup SQL with Powershell (long)

No summary available

This Blog Linked From Here The Web This Blog Linked From Here .The Web . SQL Tact

Latest Featured Videos

Most Watched Videos

Using Index Hints in a Query (Watch it Later!)
	Date Featured: September 02, 2010 Author: Andy Warren Length: 3 Minutes 35 Seconds Rating: 4.31 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, ...

Creating a Plan Guide for a Parameterized Statement (Watch it Later!)
	Date Featured: September 01, 2010 Author: Andy Warren Length: 2 Minutes 56 Seconds 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 ...

Controlling Plan Guides (Watch it Later!)
	Date Featured: August 31, 2010 Author: Andy Warren Length: 2 Minutes 19 Seconds 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 em...

Reporting Services Formatting Codes (Watch it Later!)
	Date Featured: August 26, 2010 Author: Jessica Moss Length: 3 Minutes 46 Seconds 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 sh...

Multistatement UDF's in SQL Server (Watch it Later!)
	Date Featured: August 25, 2010 Author: Andy Novick Length: 4 Minutes 1 Seconds Rating: 4.39 Description: Multistatement user defined functions are an interesting way to package and reuse code. This video by well known author Andy ...

Speak Like a SSIS Developer (Watch it Later!)
	Date Featured: June 10, 2006 Author: Brian Knight Length: 11 Minutes 51 Seconds Rating: 4.24 Description: In this first video of the series, you'll learn what SQL Server Integration Services does and a little about the environment....

Looping Through and Loading Files with SSIS (Watch it Later!)
	Date Featured: August 29, 2006 Author: Brian Knight Length: 9 Minutes 10 Seconds Rating: 4.52 Description: In this presentation, you'll learn how to use the ForEach Loop Container to loop through a folder and load each file in the d...

Change Data Capture with SSIS (Watch it Later!)
	Date Featured: January 12, 2007 Author: Brian Knight Length: 14 Minutes 3 Seconds Rating: 4.40 Description: In this presentation, Brian Knight shows you how to use canned SSIS components to detect data changes in a source table and o...

PIVOT using the CASE statement (Watch it Later!)
	Date Featured: November 03, 2008 Author: Plamen Ratchev Length: 3 Minutes 0 Seconds Rating: 4.18 Description: Pivoting data in SQL Server is a feature used mostly by reporting queries and interfaces. This video shows you how to PIVOT d...

Performance Tuning Quiz #3 - Part 2 (Watch it Later!)
	Date Featured: June 01, 2010 Author: Andy Warren Length: 2 Minutes 50 Seconds Rating: 4.45 Description: We're back with Part 2 of Quiz#3, showing you how to make SELECT COUNT(*) go faster against a simple table. As is often the c...