Search Stored Procedure Text
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...
Category: SQL Server
Division: SQL Server Style
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...
Query to Find Database and Log File Information
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 Models
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...
Query SQL Server Job Tables
If you have ever wanted to query the SQL Server job tables then you know they are a little cryptic. The following query will assist you in getting some useful information out of those tables. I recently wanted to be...
Multiple CTEs in One Query
CTEs are a great thing to use in your query. They are an excellent way to consolidate code and make it readable as well as create a “view” inside of your code. One great thing I have used them for...
Script Indexes With Your Tables
Scripting tables inside of SQL Server Management Studio is a very simple task. Just right click and select script table. The problem is that, but default, the indexes on a table are not part of the script. Rather than scripting...
Select NULL AS Max or Min in SQL Query
By default the functions MAX and MIN do not count NULL in their evaluation of your data. If we have a column containing only dates for instance and there is a NULL date, MAX and MIN will both ignore that...
Truncating A Replicated Table
On a recent project that I was working on we came across an issue where we needed to replicate several databases on a new server. Much of the ETL had places where tables were truncated and reloaded. Normally this is...
CREATE SCHEMA Syntax Error
Recently while creating a script to migrate the new holding tables over to the stage and production machines I ran into a little issue. The holding table we are using in this case houses several different sets of data for...