Azure. Business Intelligence. SQL Server. Nerd Stuff.
Business Intelligence / SQL Server
by Bradley Schacht · Published March 5, 2012 · Last modified October 13, 2015
One dimension you can be positive will always make it’s way into your data warehouse is the Date dimension. Over the past couple of years I have taken a look at a lot of Date dimension scripts and found quite...
If you have ever closed a query window by accident only to wish you could get back your work an instant later you may be in luck. If you ran the query in question there is hope for you. The...
What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a lie, but the rest of this blog is not a lie, just to be clear. 🙂 COUNT(*) – Number of...
I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a table and I want to be able to just pull up my blog and look it up. Yet again today...
There will inevitably come a day when you want to take a look at the metadata of the tables inside a database. This can be accomplished one of many ways, the quickest and easiest is to expand the columns node...
I know it has been almost a month since I posted last and this is not really a “real” post, but I assure you that new content is on the way. I have a couple things in the works that...
There will come a day, if it has not already come and gone, when you will want to search through your stored procedures because you don’t remember which one did what you want to do. Did that make sense? Because...
When doing calculations in SQL Server queries it is important to know that anything without a decimal is going to be treated as an integer and therefore will cause the result to be an integer as well. For instance, lets...
I have recently been dealing with a situation with a client where the transaction log has become an issue. Naturally during the research portion of trying to figure out what is wrong I wanted to find things like the size...
Database recovery is a very important thing, especially to DBA’s, and the occasional developer who screws something up. Please note, I am a developer and I would NEVER mess ANYTHING up in a database. I treat all databases equally and with respect. Anyway, we are getting off...
