Category: SQL Server
Use a case to make sure provided data is a date
I find this useful for using validating spreadsheet imports, using ISDATE can just blank the field if crap data is […]
Sage EDI IN Intermediary Email
I have found users don’t always read the logs from the Adaptus EDI Module anymore in Sage Line 500. There […]
Use T-Sql to find triggers on specific database
Credit: Joe Stefanelli on Stack Overflow I wanted a simple way to find triggers on a specific database, Joe Stefanelli […]
Find unused MSSQL indexs on a database
Credit: Basit’s SQL Server Tips The following is very handy to check for any unused index’s on a MSSQL database, […]
SQL Server 2008 – Find which stored procedure is part of a scheduled
Find a stored procedure (or any text) inside a scheduled on on SQL Server 2008 and 2012 by querying the […]
Maintain MSDB email tables
Credits: SQL Server Central SQL Authority Microsoft Docs Microsoft Docs We recently had an issue where MSDB was growing very […]
Find processes which have been using tempdb
Credit: Microsoft TechNet On some occasions a few MS SQL databases have exhausted tempdb space, this was due to users […]
Sage Line 500 EDI IN Intermediary tables inner join on sql query
On ocassion I need to look at what is in the EDI IN modules intermediary tables, scheme.eiordtm has an annoying […]
Method of working out check digit for an SSCC code
Method of working out check digit for an SSCC shipping code in SQL on a system with Sage Line 500 […]
Apply ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to SQL Server
We needed to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to specific databases on a SQL Server 2008 instance, I found to do […]