In this issue

Featured Contents


Featured Script

SQL Monitor SQL Monitor v3 is even more powerful
Use custom metrics to monitor and alert on data that's most important for your environment, easily imported from our custom metrics site. Find out more.
SQL Source Control The best way to version control T-SQL
SSMS plug-in SQL Source Control connects SVN, TFS, Git, Hg and all others to SQL Server. Learn more.
SQL DBA Bundle Top 5 hard-earned lessons of a DBA
In part one, read about ‘The Case of the Missing Index’ and learn from the experience of The DBA Team. Read now.

In This Issue

Disaster Recovery Week

This week we highlight the practice of being prepared for disasters at SQLServerCentral. More »

Data Distribution with SQL Server Replication

This paper provides a foundation for understanding data replication as well as a discussion of the criteria for selecting an appropriate replication technology.  More »

What’s in YOUR Recovery Plan?

Author Craig Outcalt gives advice on preparing for the worst with a look at what you should consider putting in your disaster recovery plan and why. More »

Disaster Recovery Planning for Data: The Cribsheet

Planning for disaster recovery and business continuity aren't amongst the most exciting IT activities. They are, however, essential and relevant to any Database Administrator who is responsible for the safety and integrity of the companies' data, since data is a key part of business continuity. More »

Fixing Gatekeeper Row Cardinality Estimate Issues

The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator in order to select the best query plan from the most likely alternatives. Sometimes these estimates can go so wildly wrong as to result in a very slow query. Joe Sack shows how it can happen with SQL Queries on a data warehouse with a star schema. More »

From the SQLServerCentral Blogs - Management Studio Database Diagram Owners

If you're working in an environment as a developer without sysadmin privileges, and you are creating database diagrams using Management Studio... More »

Editorial - Grace Under Pressure

I once worked at a large, 10,000+ person company. We had a large data center with hundreds of machines, where we one day we lost power. Not power from the electric utility and had our UPSes and generator kick in. We lost power when some maintenance caused all of our UPSes to trip off line and cut power to all the servers. 

I was in the data center, surprised by the sudden quiet. Unfortunately one of our senior executives was also in the data center and proceeded into the raised floor area. As various technicians and sysadmins attempted to restore power and reboot systems, this senior executive watched, commenting, questioning, and often berating the employees. Not a good situation for anyone, least of all the people trying to reconnect high voltage wires together.

Most of you will never experience a large disaster and need to recover your systems. Even fewer of you will recover from disasters with anyone other than your peers or a direct manager watching you. However you shouldn't count on being that lucky. Whether the disaster is small or large, your fault or a natural occurrence, I hope that you are able to successfully restore your systems with some professionalism and grace under pressure.

The key to a strong performance in a stressful situation is the same in technology as it is in sports, music, and almost any other endeavor with an audience. They key is practice.

Simulate disasters, pretend that refresh of a development system is really a restore after a fire. Think about the various possible scenarios that might require you to recover a system and incorporate practice time into your daily routine.

Steve Jones

The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at Comments are definitely appreciated and wanted, and you can get feeds from there. Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at

You can also follow Steve Jones on Twitter:

» Join the debate, and respond to today's editorial on the forums

» To submit an article, rant or editorial, log in to the Contribution Center

Question of the Day

Today's Question:

I have the following T-SQL

DECLARE @str VARCHAR(6) = 'ServeR'


I execute the follow T-SQL:

-- S-1
SELECT STUFF(@str, 1,6,@stx) AS 'S-1' 

-- S-2
SELECT STUFF(@str, 0,5,@stx) AS 'S-2'

What is returned by the T-SQL statements (S-1 and S -2)?

Think you know the answer? Click here, and find out if you are right.

This question is worth 1 point in this category: STUFF. We keep track of your score to give you bragging rights against your peers.

We'd love to give you credit for your own question and answer. To submit a QOD, simply log in to Contribution Center.

SQL Server 2012 Integration Services Design Patterns

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution.

Get your copy from Amazon today

Yesterday's Question of the Day

Suppose I have two schemas: person and beneficiary. I create multiple tables with the name of "malls" with different schemas. Which statements will succeed? The answers are given as success or failure in the order of the statements listed below.

create table person.malls(id int)
create table beneficiary.malls(id int)
create table malls(id int)

Answer: Success,Success,Success

Explanation: Object name is unique only for particular schema.

» Discuss this question and answer on the forums

SQL Server 2012 Data Integration Recipes

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.

Get your copy from Amazon today.

Featured Script

String Split

Generate table from comma separated string More »

Database Pros Who Need Your Help!

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2005 : SQL Server 2005 Strategies

Object Relational Modeling (ORM) Examples - I really need some help on this one. One of our development teams is looking into ORM as a way...

SQL Server 2005 : SQL Server 2005 Performance Tuning

Sp performence. - Hi, I am facing one issue in SP at prod. which is running at QA and staging within 1-2 mins. But...

ORMs and Indexes with Included Columns - I'm using LINQ to SQL, but I think this question may apply to any ORM tool. L2S entities are mapped from...

SQL Server 2005 : SQL Server 2005 Integration Services

Demanding and difficult logic qns. Sorry but i need help. - Hi pros out there, I am introduced to SSIS to do ETL for repporting in SSRS very recently. I am given...

Data conversion in SSIS - Hi everyone, I am newbie to SSIS, just picked that up ytd. Currently i am given a sample view table to...

SQL Server 2008 : SQL Server 2008 - General

Unexplained web disconnect - Hi experts, I'm using IIS as web server and SQL Server 2008 R2 as Database engine. I don't know why my...

Log backup question - Hello, My transaction log backup today took longer time to complete than usual. Daily it runs at 1:00PM for about 2...

SSIS Derived Column question - I'm moving data from a text file to a table using SSIS. Below is an example of my data and how...

Continually running SQL Trace - Hi, I am planning to run a server side trace on server. I am bit worried about the trace file growing...

Appropriate range for partitioning - Hi I have a large table which there is just select and insert on it.It has a field named 'TranType'(int)...

sign of corrupt database? - When I manually run this insert script below I'm usually expecting to see (2 lines due to a trigger that...

Memory usage - HI In our server when we have time out in select & insert we have lack of memory. the total memory is 24G,and...

First Post with a very basic query request - Hello all but i'm trying to make a very basic query and i'll give an example of the db here...

TSQL question (join tables) - Dear all, I have a question concerning a view UI need to create. Let's me explain the situation. I have 5 tables Reports...

SQL Server 2008 : T-SQL (SS2K8)

Delete records in group - but not all - Hello all, I think that my question is quit simple, but hope someone can help me. I have a table that looks...

Update Gaps - I'm trying to update gaps in a table using a set based approach, but have been struggling with the solution....

SQL Server 2008 : SQL Server 2008 Administration

move db files to another directory - I would like to move database files to another drive. I used sql like below: ALTER DATABASE Z_20090501_coreSPSS MODIFY FILE ( NAME = coreSPSS,...

Career : Employers and Employees

Money vs Job Satisfaction, where is the balance? - Im currently in a job i really enjoy. As a consultant for a small specialized database consultancy firm I get...

Data Warehousing : Analysis Services

Loading change data from AS400 (or other source systems) - Greetings all! So I will keep this concise as I can; I have a source as400 system I am extracting data...