In this issue

Featured Contents


Featured Script

SQL Monitor "It really helped us isolate where we were experiencing a bottleneck"
- John Q Martin, SQL Server DBA. Get started with SQL Monitor today to solve tricky performance problems - download a free trial
Red Gate Deployment Manager NEW! Automate your .NET deployments
Deploy ASP.NET applications and SQL Server changes fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try it now.
SQL Backup Pro Disaster Recovery is made quick and easy with SQL Backup Pro
Use SQL Backup Pro's restore wizards and scripts to get your database back online as quickly as possible following a disaster scenario. Download a free trial today.

In This Issue

Data Mining Introduction

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world. More »

Day 3 of The OLAP Sprint

Day 3 was a pre-con on Business Intelligence. More »

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through CU#4. More »

Viewing VMware Counters in PerfMon for SQL Server

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more. More »

From the SQLServerCentral Blogs - Looping through multiple servers in SSIS part 2

Last week I posted a quick example of looping through multiple servers using SSIS and being in a bit of... More »

Editorial - Monitoring is Essential

An old phrase used in business is that knowledge is power. When you understand more about a particular situation, you can develop solutions and better understand which ones would both suit your environment better and solve any issues faster.

As someone that has worked in a variety of production environments managing all different types of platforms, I have found it extremely career-enhancing to have knowledge about the entire environment. Knowing what is happening at any point in time has allowed me to answer pointed questions about the applications. With comprehensive monitoring set up in database servers, I have often found myself in a position to proactively prevent issues, or make preparations for a quick response when I do find problems.

Over the years I developed a variety of techniques to monitor my own servers, often using third party solutions, enhanced with my own queries. I have learned that each system has its own idiosyncrasies, which often require custom queries to keep an eye on the pulse of the system. I've also learned that a regular exception report is the most valuable tool for me as a DBA. I assume most of my applications and scheduled tasks are working well; I just want a list of those things that have broken, or are not performing as expected sent to me every day, using the data from my various monitoring tools.

I have found that tracking metrics and analyzing the data is a valuable tool in my DBA tool belt. I would go so far as to say that monitoring the systems that you work with is not only a best practice, it's essential if you want to be an exceptional DBA. 

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

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:

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

Question of the Day

Today's Question:

I have the following table

, UserName VARCHAR(8)
, Sales Decimal(6,2))

Which contains the following data:

UserId UserName Sales

1      Joe      100.00

2      Baker    700.00

3      Charlie  400.00

4      Able     800.00

5      XRay     1000.00

6      Easy     50.00

I then execute the following T-SQL statement

, UserName
, LEAD (Sales,1,( SELECT MIN(Sales)
                    FROM #Users1 )) 
      OVER (ORDER BY Sales) salesgoal 
 FROM #Users1 
 ORDER BY Sales 

SELECT 2  Answers

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

This question is worth 2 points in this category: LEAD. 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 Execution Plans

SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!

Yesterday's Question of the Day

Declare @a varchar(100)

select @a = null

select @a = isnull(coalesce(@a,coalesce(NULL,NULL)),'Pass')+'Fail'

select @a

What is returned?

Answer: Error

Explanation: The coalesce expects atleast one typed NULL in order to execute and hence the error.


» Discuss this question and answer on the forums

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

Featured Script

Script to construct a restore/recovery script

Constructs a restore script for all databases on the server from backup history. 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 : Administering

splitting tempdb to multiple files - max size? - i have noticed tempdb contention on our tempdb, so i want to split the data file to multiple files.We have...

which one is right? - i have transaction isolation level set to read-uncommited but i am not sure which one really works though syntax wise...

SQL Server 2005 : SQL Server 2005 Performance Tuning

Huge cost issue with Temp DB using 2008r2 sp2 - Hi Guys, I have an issue that is completely baffling I need a guru's guidance / help. so a little bit of...

SQL Server 2005 : SQL Server 2005 Integration Services

Performance issue using UDF in bulk load jobs (SSIS) - Hi All, We have bulk load jobs configured using SSIS packages. All the load jobs were working perfectly fine until 2...

Is derived column better for performance of a package ? - I have a scenario where an excel have thousands of records with say 20 columns. In which their is a...

SQL Server 2005 : T-SQL (SS2K5)

Audit Triggers - Hi, I need to create two triggers on my small lookup tables for audit purposes. The triggers are for any inserts and...

SQL Server 2008 : SQL Server 2008 - General

OLAP security Roles - Hi all, is there a way to make a backup of the OLAP security roles ? Every time we add a...

creating query - Hi! I have to create sql query for searching accouts in my database. Parameters for search i enter in textboxes (id,name,last...

how to add a column that contains the max value of the group from another column - The PROJECT_LEVEL column should return the MAX DASHBOARD_STATUS_LEVEL for every MARKET_PROJECT of the same id (instead it appears to be...

Problem in Restoring Differential Backup in SQL Server 2008 R2 - Dear, First of all, I took the full backup of my database. After that I executed some insert queries. Then I...

SQL Server 2005 - Hi, Is there any easy way by which we could roll back a service pack installation in SQL Server 2005 without...

NOLOCK Hint Corrupts Results from SELECT - Good day fellow SQL Server Enthusiasts, I'm having an issue with the NOLOCK query hint causing erroneous joins. In a nutshell,...

how to insert image in sql server 2005 - hi, i want to insert image into sql server using sql query. please help. thanks in advance sanjay

SQL Server 2008 : T-SQL (SS2K8)

duplicate rows - hi my table has following data productno productname des quantity 1 borin 4x-mal 2 1 borin 5x-cal 3 2 hypoid 4-5cal 4 2 hypoid 4-5cal 4 here,i...

duplicate rows - hi my table has following data productno productname des quantity 1 borin 4x-mal 2 1 borin 5x-cal 3 2 hypoid 4-5cal 4 2 hypoid 4-5cal 4 here,i...

Group ,Sum ,Inner join ..How to do it ?? - Hello , i'm new and i want your help guys! I've 3 tables with one common field (id) . the data look...

Identity column reseed cause problem with other database - We have a data warehouse team that uses the identity column (surrogate key) as primary keys for many cubes tables...

script - hi, need script that transfer data from 1 table into another. Old table : CREATE TABLE [dbo]Master]( [Format] [varchar](11) NOT NULL, [Class] [varchar](50) NULL, [Product_Name] [varchar](100)...

Large fixed width to sql help please! - When everything else fails I will ask you guys. This has been annoying me for weeks now and although I...

SQL Server 2008 : SQL Server Newbies

Linq to Sql tutorial codes and SQL Server Express 2008 : - Linq to Sql tutorial codes and SQL Server Express 2008 : I am testing some tutorial sample codes for Linq to...

Newbie Questions - I am an SQL Server Express and Server Management Studio newbie. I am currently on pg 380 of the 2012...

Pasting a screen shot....How? - I like to post questions which involve shown some screen shots. Can someone show me show I can paste screen shots...

Multiple joins problem - Hi, so I'm brand new when it comes to T-SQL. I hope I can explain this for everyone to understand. There is...

SQL Server 2008 : SQL Server 2008 High Availability

Start Mirroring Failure - I have 3 servers (principal, mirror, and witness) each of them as SQL Server installed and listening and nonstandard ports...

SQL Server 2008 : SQL Server 2008 Administration

Report Server help - I am confusing with below questions from my manager. Could you please answe asap. 1.what is the difference between DB server...

rebuild on clustered index - We have a heavy used table. We rebuild the indexex every night on this table. When the clustered index fragmentation...

What would be the best RAID configuration for this hardware? - We have a brand new DELL MD1200 with 12-spindles - These are 15Krpm, 600GB SAS drives The server this is going to...

Report Services Fails to Start, and fails installation - I wanted to post this so it would be out there on the Web for anyone else searching for a...

Career : Certification

Microsoft Certified Master - There's been a lot of debate recently about whether certifications are worth doing and whether they provide you or your...

Career : Employers and Employees

Production DBA Vs Project/Development DBA - Hi, Does anybody have any reference points for how the role of a production DBA may differ from that of a...

Reporting Services : Reporting Services

Grouping Row - Hi, My SQL statement gives me the example below output. What I want to do is sort by person and display...

Converting Crystal Report Formula(if condition) to SSRS - Hi, Currently I am migrating Crystal reports to SSRS 2008. I am struggling to covert Crystal rpt formulas like below to...

Database Design : Disaster Recovery

Data Warehouse Disaster Revcovery Options - I'm in the process of implementing a Data Warehouse. I have a Staging Database and a DatawArehouse Database. I have data feeds...

Data Warehousing : Analysis Services

Semi-additive measures with SSAS Standard edition - [b]How do people handle semi-additive measures with SSAS Standard edition? [/b] (other than switching to Enterprise edition). I'm using SSAS...

Microsoft Access : Microsoft Access

displace input row in Access 2003 and SQL Server 2000 - Hi, Output in Access 2003: ID | [b]Description[/b] | Quantity | Title | Obj --- ---------------- -------------------------------------------------- 17 | [b]6 [/b]| 253000.00 | | 18 | [b]7 [/b]| 330000.00 | | 19 | [b]1 [/b]| 340000.00...