Someone in my day job this week asked me how to deal with Msg 8134, Level 16, State 1, Line 3 Divide by zero error encountered error that they were receiving. It's second nature for me to add the below...

Did you install SQL Server 2012 Standard Edition for evaluation purposes on your PC and forgot to write down when your six months is up? Yep, you're right, I'm talking from experience here! So I needed some T-SQL magic to...

This is the first video in a series entitled "Beginning SSRS" - we are going to show you how to start with the basics of SSRS and work our way through to more advanced SSRS topics. If you want to...

I had the challenge of putting together a T-SQL statement that's going to be used in a few stored procedures. The stored procedures will build data based on what todays date is, if today is greater than second Tuesday of...

So in my day job I was asked to investigate why some data was not matching up. After a bit of investigation I found a table that had 90-95% of it's records duplicated, so I needed a way of removing...

I've seen alot of questions around the internet about how to remove the time portion from a date. I've provided two ways of doing this below that you can use.
The first uses a CONVERT method, however, CONVERT is...

A tally table is a table that contains a series of sequential numbers used as a base table to create other data sets such as calendars. There are many ways to create a tally table but I prefer the way...

As a follow on to yesterdays code snippet about finding the last modified date of SQL Server Agent Jobs, I thought I would apply the same code to find the last modified date of SQL Server Agent Job schedules. Always...

Earlier on today I really needed to see the last modified date of a job that had been disabled. I didn't know whether it was recent change or whether it was in the distant past. SQL Server Agent Job screen...

There are many ways of detecting duplicate data in your tables. One of the quick and easiest methods I have found is to use the below syntax.

It will return a list of duplicate entries by the...