SQL Server

SQL Server Community

SQL Server Blogs

Larry Leonard
Follow /17 Sep 2014 at 7:08pm / SQL Server

CMS: List All Jobs that Do Not Notify on Failure

Using CMS , we can get a list of all the Jobs on all the servers that have no email (nor page, nor netsend) notification set up for Failure. This can be useful to find Jobs that are silently failing, and even Jobs that are no longer in use. -- Find Jobs...
14 0 /
Larry Leonard
Follow /17 Sep 2014 at 6:22pm / SQL Server

CMS: List Jobs not Writing to the Windows Event Log

Using CMS , we can get a list of all the SQL Agent Jobs that aren't writing to the Windows Event Log upon failure, and set them to do so. -- Check for Jobs that aren't writing to the Event Log. declare @JobName sysname -- 0 - Never -- 1 ...
12 0 /
Ayman El-Ghazali
Follow /17 Sep 2014 at 3:44pm / SQL Server

[SQL Snacks Video] Performance Tuning 101 – Baseline with PAL Tools

Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. This first video describes how to setup a baseline for your system using the PAL tools...
28 0 /
SQLDBAPros
Follow /17 Sep 2014 at 3:41pm / SQL Server

There Ain’t No Cure for the Summertime Blues, but 85 Percent Faster Backups Would Help – Case Study

“Oh, no thanks, Boss. I’d much rather sit here all summer and keep an eye on our SQL Server backups than go to the beach or ride my bike.” Said nobody. Ever. We recently published a blog about having a panic-free summer by getting...
24 0 /
Adam Kreul
Follow /17 Sep 2014 at 2:10pm / SQL Server

Why I’m Not Excited About Hekaton (In-Memory OLTP)

A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure why, Hekaton is much more fun to say), and while I am certainly still excited about this new feature, it does have some...
29 0 /
Kenneth Fisher
Follow /17 Sep 2014 at 1:00pm / SQL Server

Triggers are not toys!

For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL triggers . I’m talking about plain old ordinary DML triggers . Triggers are very useful tools but can easily cause all sorts of...
32 0 /
Pradeep Adiga
Follow /17 Sep 2014 at 12:35pm / SQL Server

Application timing out due to excessive blocking on tempdb PFS

Problem Applications Connecting to SQL Server timing out Symptoms Excessive blocking with the wait resource being tempdb PFS page High CPU utilization on the server Troubleshooting sys.dm_exec_requests reported blocking and the head blocker...
24 0 /
Rohit Garg
Follow /17 Sep 2014 at 10:24am / SQL Server

Cumulative Update – 12 for SQL Server 2012 Service Pack 1 Is Now Available !

The 12th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
30 0 /
Rohit Garg
Follow /17 Sep 2014 at 10:20am / SQL Server

Cumulative Update – 2 for SQL Server 2012 Service Pack 2 Is Now Available !

The 2ndcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are facing...
38 0 /
Richard_RP
Follow /17 Sep 2014 at 7:53am / SQL Server

Cumulative Updates – SQL Server 2012 SP2 CU2

As part of their Incremental Service Modelling , Microsoft have released SQL Server 2012 Service Pack 2 Cumulative Update 2! Service Pack 2 CU#2 can be applied to any of the following Microsoft SQL Server 2012 editions, providing Sp2 has already been...
28 0 /
SQLDBAPros
Follow /16 Sep 2014 at 3:03pm / SQL Server

Tuesday Tips: Five Considerations for Transaction Workload Analysis

Performance. Problem. Two words DBAs never want to see together. Yet avoiding (or eliminating) database performance problems can eat up hours, days or weeks of an administrator’s time. We have a ton of resources available on ToadWorld. And in previous...
234 0 /
Larry Leonard
Follow /15 Sep 2014 at 7:30pm / SQL Server

Display ETA and Percent Completed for BACKUP or RESTORE Commands

This code will show you the estimated time of completion and percent completed for currently running BACKUP or RESTORE commands. -- Shows both backups and restores. select session_id as 'spid' , command as 'Command' , start_time as...
68 0 /
David Dye
Follow /15 Sep 2014 at 4:06pm / SQL Server

Dealing with Duplicates in the Data Flow

I frequently see posts in the MSDN forums requesting assistance in removing duplicate values from a source, other than SQL, to be entered into a SQL Server destination.  There are several options to accomplish this, but this post is meant to address the...
39 0 /
Kenneth Fisher
Follow /15 Sep 2014 at 1:00pm / SQL Server

I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this little trick. The other week I did a post on SCHEMABINDING and Diana sent me this great link on SCHEMABINDING UDFs . In it TomErv discribes SCHEMABINDING...
65 0 /
Rohit Garg
Follow /15 Sep 2014 at 10:15am / SQL Server

Creation & Deletion of Database Snapshot by SQL Agent Job

Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear...
74 0 /