-
Find text in Stored Procedures
I can't express how useful this has been to me when trying to find whether a text string exists in one of our Stored Procedures ... -
Most Active Databases in SQL Server
I recently had someone ask what the most active databases were in our SQL Server. Well... we knew which was the most active (based on ... -
Add a column with a default and foreign key constraint
Every so often you may be presented with the requirement to add an additional column to one of your database tables. My experience, with SQL ... -
Get First Day of the Quarter
I’m building a Stored Procedure and Report that needs to limit to data created in the previous quarter, only. The assumption is the report will ... -
Get first & last day of the month
I'm building a Stored Procedure and Report that sets the default start date as the first day of the month one (1) month ago. Can ... -
Need some SQL dates?
Just a handful of quickie SQL dates that might come in handy. Run this in Management Studio to return a bunch of commonly needed dates, ... -
Hey Experts Exchange!
Hey Experts Exchange, I don't use you. I may land on your site from time to time while researching stuff for work projects but I've ... -
Monitor Disk Space on your SQL Server
I'm a SQL Server developer; I get to wear many hats though. My previous job was as a SQL Server guy, my current job is ...