Data Driven Subscription failed with timeout error

One fine day, one of our data driven subscription which was running fine, failed with timeout error.
library!WindowsService_118!eb4!12/20/2011-07:30:01:: i INFO: Handling...

Re-blog – December 16 – December 22

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may...

SQL Saturday #104: Colorado Springs

January 8th, 2012 will be the first SQL Saturday for 2012. 104 SQL Saturdays is an amazing number for our...

SQL Server 2012 (“Denali”): New Security Features

SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups,...

SQL Server Sample Databases – All Versions

Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server...

Tis The Season to be Giving...#SQLFamily

Indeed the Holiday Season is traditionally a season of giving, and being charitable to those who are less fortunate.  Although giving...

2011 What A Great Year

What A Diffrince A Year Makes
In January I posted up my new years list basically, stuff I wanted to learn in...

A SQL Server Christmas Card

Merry Christmas everyone!
DECLARE @hohoho char(100)
DECLARE @bells smallint
DECLARE @tiers smallint
DECLARE @maxtiers smallint

SELECT @hohoho = ' ', @tiers = 1, @bells = 1, @maxtiers = 6
PRINT @hohoho

WHILE @tiers...

CONCAT() string function–SQL Server 2012

As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in...

How many calls – A T-SQL Question

I got a call from a friend recently that was looking for some query help. He was actually using Access,...