I was recently asked to append some leading zeros to a column in a data set. I found one solution which was quick and simple....
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...
Read More
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...
Read More
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...
Read More
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...
Read More
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...
Read More
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...
Read More
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...
Read More