-
Update value from SUM(values) in another table
I recently found myself forgetting the exact syntax to update a value in a table based on the sum of another set of values in ... -
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 ... -
Hide SSRS Toolbar
If you'd like to hide the Report Viewer toolbar whilst utilising ReportServer, you can simply append the following to the end of the query string: ... -
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 ... -
MySQL GROUP_CONCAT returns [BLOB - 14 B]
A tech post today, I really don’t do enough of these. I bumped into an issue recently where I was building a form guide for ... -
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 ...
