Technical Article

Switch Databases

This script changes the physical, logical and file names of a database.  It stores the current database until the next time the script is run, and creates a dummy database for the next update.  The intent was to have minimal downtime even though the load (import, snapshot, etc.) may take a long time.  Three copies […]

You rated this post out of 5. Change rating

2007-02-22 (first published: )

606 reads

Blogs

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

By

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...

Set-Based vs Row-Based Database Code

By

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...

Read the latest Blogs

Forums

Vijaybet Online Casino: Elevate Your Gaming Experience with Rich11!

By VjGian15

Step into a world of unparalleled excitement and luxury with [/url] at Vijaybet Online...

Cali Weed Kaufen

By master234

Drug City ist eine Gruppe von Drogenaktivisten, die erkannt haben, welche Vorteile verschiedene Drogen...

Need help on query - DATEDIFF

By Adelia

Hello, I want to have value Month ago Year ago So far, I've this...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers