Pages

▼
Tuesday, January 2, 2018

SQL Agent Job - How add lines to its Description

›
You’re creating or editing a description for a SQL Agent Job and you want to add some lines or white pace to your text. If you press the ...
14 comments:
Sunday, October 29, 2017

Search all databases for an object using sp_MSforeachdb

›
I often need to search an entire database for the existence of a database object.  Typically a table or view that is used across databases. ...
2 comments:

Script to auto-create a MERGE statement

›
With SQL Server, the MERGE statement is one of the most powerful commands available to a developer. With one statement, you can run a column...

Compare Two Tables and Columns - Meta-data T-SQL script

›
You need a tool to compare the meta- data between two tables, and you don't have the budget for one of the great tools already out in th...
1 comment:
Wednesday, October 18, 2017

IDENTITY Column - and the steps to remove from your table

›
Issue: Your table has a column identified as an IDENTITY (autonumber) column, and you need to 1) keep the column and its contents 2)...
1 comment:
Sunday, October 8, 2017

Fix Windows 10 - 100% Disk Usage in Task Manager

›
A colleague directed me to the URl below with a list of tips to fix the 100% disk usage problem I was having with Windows 10.   I also disab...
Monday, September 18, 2017

CONCAT different Rows into a single attribute value

›
Problem: Using T-SQL, you need to concatenate values from different rows into a single attribute value.  The ideal solution would a funct...