SQL Server

Moving Database Files to Another Location

March 19, 2016 | 0 Comments

Although moving database files around is simple, it is a still big deal.  When you do this, you are moving the entire database contents to another location.  If you [...]

SQL Server Compare Users Script

March 19, 2016 | 0 Comments

If you need to compare two users in SQL Server, here is a handy script. The output is simply a script to make the “UserToChange” sync up with the “ModelUser”. So this [...]

SQL Jobs – Daylight Savings Risks

March 19, 2016 | 0 Comments

For those of us not lucky enough to live in Arizona (where daylight savings is ignored and clocks stay the same all year-round), we need to consider what time our SQL jobs [...]

Validate SQL Code Without Running It

March 19, 2016 | 0 Comments

Validate SQL Code Without Running It In a nutshell: SET NOEXEC ON; -- The script now will throw all DML errors without executing the code being [...]

Database File Space and Free Space

March 19, 2016 | 0 Comments

/* Author: Ben Farnsworth Date: 1/7/14 Get info on Data files */ IF OBJECT_ID('tempdb..#space') IS NOT NULL DROP TABLE #space create table #space( name varchar(100) ,filename [...]

Autogrowth On But Database Not Growing

March 19, 2016 | 0 Comments

An issue arose where a database was giving the error: Could not allocate space for object ‘object-name’ in database ‘dbname’ because the [...]
1 2 3 4 5 6