The common language runtime (CLR) integration feature in SQL Server is off by default, Below SQL Script will help you to enabled CLR in order to use objects that are implemented using CLR integration. When CLR feature enabled in SQL...

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...

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...

  Sometime you might want to get row counts for all the tables in the entire SQL server. It might help you to identify large tables and tables have no records. Following script will help you to Get row count of...