I mentioned it a few posts ago and now its finally happened! We've recorded our first YouTube video and it's a basic video on how to import a .CSV file into a table through SSIS. We show you how to...
Read More
I mentioned it a few posts ago and now its finally happened! We've recorded our first YouTube video and it's a basic video on how to import a .CSV file into a table through SSIS. We show you how to...
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
Divide by zero is a common error in whatever language you code in. Although an error is the correct response as you can't divide by zero, its something that we don't want to display. One method of getting round this...
Read More
We've decided that SQL Repository are going to start recording some SQL development videos for YouTube. I am preparing the PC for these videos and wanted to install SQL Server Reporting Services (SSRS) 2012. However, once the installation had completed...
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...
Earlier today I was experiencing issues with my PC and the GUI for SQL Agent jobs wasn't appearing on screen. I really needed to stop a job that had become stuck over the weekend, so I turned to T-SQL and...
Read More