SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Labor Day 2013

It's a holiday in the US today. It's Labor Day, and many in the US have a break. With a holiday late last week, this turns into a 5 day weekend for me. That's unusual for me as I struggle to take time off. I enjoy my job, and it seems that I have no shortage of tasks I can find during the week. I'm trying to do better. Vacation is important, and I'm hoping to fit in more across the next few months.

Most of us work as labor for some enterprise. Whether it's an employer or our own business, we work to earn an income, support our families and, hopefully, find some sense of purpose in our efforts.

Work is hard, and every job is work at some point, but I hope you enjoy your employment more days than you don't, especially the work in technology. The tools, capabilities and amazing things we can do in the digital world are very exciting.

I've got a blooper real for the podcast that I hope you enjoy today if you're reading the newsletter. For those of you around the world, I know many of you may be working today, but I hope you have your own holiday at some point during the year that recognizes the efforts you put in.


Watch in WMV or MP4 formats.

Steve Jones from SQLServerCentral.com

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

SQL Source Control

Get your SQL Server database under version control now!

Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

Top 5 Hard Earned Lessons of a DBA

Top 5 Hard-earned Lessons of a DBA

‘10 Tips for Efficient Disaster Recovery’ by Steve Jones. Prepare for any future disaster by reading Steve’s tips today.

SQL Compare

Need to compare and sync database schemas?

Let SQL Compare do the hard work. ”With the productivity I'll get out of this tool, it's like buying time.” Robert Sondles. Download a free trial.

Featured Contents


Common table expressions and circular references

Geoff Norman from SQLServerCentral.com

Finding circular references that are stopping your CTE from working. More »


SQL Saturday #251 Paris, France

Press Release from SQLServerCentral.com

SQL Saturday is coming to Paris on September 14th 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday will include a track on Business Intelligence, SQL Server, and something for beginners. More »


Test Your SQL Server Backups with PowerShell

Additional Articles from SimpleTalk

The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White shows how, with PowerShell. More »


From the SQLServerCentral Blogs - Make the PASS Summit Work For Your Employer

Grant Fritchey from SQLServerCentral.com

It was pointed out to me that since PASS is such a huge networking event, any employer would be crazy... More »


From the SQLServerCentral Blogs - A Rickety Stairway to SQL Server Data Mining, Part 14.2: Writing a Bare Bones Plugin Algorithm

SQLServerSteve from SQLServerCentral.com

By Steve Bolton …………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one... More »

Question of the Day

Today's Question (by Steve Jones):

It's Labor Day in the US. Today's question is "how many points are the fun, holiday questions worth?"

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

We keep track of your score to give you bragging rights against your peers.
This question is worth 7 points in this category: humor.

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


Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Sean Smith):

You wish to enable xp_cmdshell. You run the following code:

EXECUTE sys.sp_configure
     @configname = 'show advanced options'
    ,@configvalue = 1
EXECUTE sys.sp_configure
     @configname = 'dsh'
    ,@configvalue = 1

What is the outcome?


  • The first call to sp_configure succeeds
  • The second call to sp_configure succeeds

Explanation: Even though the full configuration name is xp_cmdshell, SQL Server will only find 1 unique entry for the characters values of "dhs" and be able to link it to xp_cmdshell. From BOL: "The SQL Server Database Engine recognizes any unique string that is part of the configuration name."

Ref: sp_configure - http://technet.microsoft.com/en-us/library/ms188787.aspx

» Discuss this question and answer on the forums

Featured Script

SQL Powershell Script to check Server's disk space Remotely

Raushan Srivastava from SQLServerCentral.com

Steps to run this script..

1) Save the script in file "c:\ServerDiskSpaceReport.ps1"

2) Open Run --> sqlps

3) Run the script on sqlps command prompt like below..

PS SQLSERVER:\> C:\ServerDiskSpaceReport.ps1  ServerName

You will get the results like below.

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 2012 : SQL 2012 - General

SQL Refactor Studio - useful addin for Microsoft SQL Server Management Studio 2012 - Good day! We would like to present you SQL Refactor Studio [url]http://sqlrefactorstudio.com[/url] - Addin for Microsoft SQL Server Management Studio 2012 (SSMS). This...

SQL Server 2012 developer tools - Hi all, I have a quick question for you. What software would i download to get a database developer access to...

Transactional replication - can't create publication - Hi all, I have a newly created Windows 2008R2 (64bit) server with MSSQL 2012 standard edition installed, acting as it's own...

SQL Server 2012 : SQL Server 2012 - T-SQL

Improving performance with INSERT statement - The following code uses a WHILE loop to Insert a row in table2 with every ClientID in table1 and every...

SQL Server 2008 : SQL Server 2008 - General

export to csv - Hi Professionals I have a script thats exports to a csv file [code] exec exporttocsv 'select top 5 * from newtable', 'test.csv' [/code] the problem I...

BIDS Debug issue with single solution - This is driving me nuts. I hope someone can assist me with the resolution. Out of the dozens and dozens of...

windows installer fot sql installation - why do one require windows installer for installing sql 2005/2008 setup.

Not able to select match and non match by left join - I would like to check category by lob that exists or not on the basis of @Match Parameter. I can do...

How to get how many memory is used for each T-SQL ? - Dear All, Please kindly help below, Many thanks! 1. how do you know that how many memory is used for each...

List objects to move - In one database(Order), all my objects (in this db, some objects are not my app) for a app have to...

SQL Server 2008 : T-SQL (SS2K8)

Query - I need a T sql query which should read and load text files data from the directory one file after...

sql query - Hello friends, Please help me in writing a query!! Question: Write a query based off of the following data stored in the AccountingEntry...

sql query - Hello friends, Please help me in finding the correct query!! Question: You need to find duplicate account’s in an Account table. The Account...

SQL Server 2008 : SQL Server Newbies

Help - I am DBA with two year of experience on SQL server 2008 R2, i have some questions that should i stick...

SQL Server 2008 : SQL Server 2008 Administration

SSIS - Need Recommendations - I need to copy a number of tables from an ERP system's Progress database to a SQL Server database that...

SQL Server 2008 : Data Corruption (SS2K8 / SS2K8 R2)

Errors from CHECKDB - Last night I got paged with the 2 errors below: [b]First[/b] [quote]SQL Server Alert System: 'Severity 017 - Insufficient Resources' occurred on ServerA During...

SQL Server 2008 : SQL Server 2008 Performance Tuning

Simple Index question - Good Morning All, Just a quick question... I have a table which updates on a daily basis after 11pm when no-one is...

SQL Server 2005 : T-SQL (SS2K5)

Division by zero on a SQL Instance while a different Instance run correctly - Hi I run the same query against two DB, one is the publisher and other is the subscriber. The two DB should...

SQL Server 2005 : SQL Server Newbies

Barcodes Code128 generator function - I'm looking for a [b]barcode generating Function[/b] (in SQL 2005), that uses the standard [u]Code128[/u]. The result of calling the...

Reporting Services : Reporting Services

Regenerate SSRS Subscription Agent jobs - Hi gurus. We have a method in place for disaster recovering SSRS (from a production primary to log shipping secondary). The...

Programming : Connecting

Connection Failed: SQL STATE: '01000' Server Error: '10060' [ODBC SQL Server Driver][TCP/IP Sockets] - Hi, My Server has installed with SQL 2000 and iam trying to connect to SQL Server through ODBC and iam getting...

Programming : SMO/RMO/DMO

Problems connecting to SQL Server 2012 using 2005 SMO - Should 2005 SMO be able to access SQL 2012 please? We are currently performing a large migration to SQL Server 2012....

Data Warehousing : Integration Services

How do I write Precedence Constraint Editor Expression to execute when a value is false? - I have two sequence containers. When I set Bln_runWithOverrideDates to True I want to run my SEQC_Historical container. That part...

Catastrophic failure while deploying SSIS packages to SQL server - Hi, I am getting the following error when deploying the SSIS packages to SQL Server. =================================== Could not save the package "D:\abc\Cancellations ETL...

Data Warehousing : Analysis Services

Issue with huge CrossJoin - Improving a Query - i got a query that consists of a cross join between 3 dims . dim1- has 15,000 members dim2- this is the...

SQLServerCentral.com : Anything that is NOT about SQL!

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...

To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com