Tag Archives: Microsoft SQL Server

Setting Up Data and Log Files For SQL Server

NOTE: As with all SQL Server ALTER DATABASE commands, I strongly suggest you back up your data before running these scripts. Among the many questions and options when setting up …

Tags: , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Using PIVOT on Dates in One Column

Suppose you have a table that contains Job ID, when it was started, and when the Job ended. Now you want the difference in days between when it was started …

Tags: , , , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Change Links in SQL Objects when Cloning Production to Test

Let me say at least one time in this article…..”Backup your Database before running the created text file.” Ok, now that I have said that let’s talk about a problem …

Tags: , , , , , , , , , , | Posted under Programming/Coding | Leave a comment