BussinesDaysToCalendarDays
Tells how many calendar days are needed to complete a number of bussines days starting in a specified week day. Any comments? Let me know =D.
2012-07-20 (first published: 2012-07-04)
840 reads
Scripts
get all values separated by commas
How to get all values separated by commas, with only a SELECT query and a variable.
2012-07-19 (first published: 2012-07-03)
2,246 reads
2012-07-18 (first published: 2008-01-25)
2,183 reads
2012-07-17 (first published: 2007-11-21)
2,252 reads
Function to Split Multivalued Parameter
This Function is written to split Multivalued Parameter passed by Reporting Services 2005.
2012-07-16 (first published: 2007-08-01)
2,791 reads
2012-07-13 (first published: 2008-03-20)
2,199 reads
TopBlocker
Script to log top blocker processes in a database. Top blocker is defined as the process that is at the top of a blocking chain.
2012-07-12 (first published: 2007-10-30)
3,014 reads
Check Used Table Space for User Defined Tables
Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.
2012-07-11 (first published: 2012-07-04)
1,259 reads
2012-07-06 (first published: 2012-06-29)
988 reads
2012-07-05 (first published: 2012-06-15)
933 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers