Technical Article

usp_ToggleDatabases

usp_ToggleDatabases is a simple procedure that will switch the names of two databases.One of the main problems with using sp_renamedb to switch databases is that the procedure will wait until the database is free before the rename can be completed. If the new live database is also in use then there is a likelyhood that […]

(1)

You rated this post out of 5. Change rating

2005-08-04 (first published: )

503 reads

Blogs

Demo for Parameter Sniffing and Memory Grant Feedback

By

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...

My Social Media Rules

By

I developed these rules a while back, before COVID. I had a period of...

Why Use TRY_PARSE(): #SQLNewBlogger

By

Someone asked why I would use TRY_PARSE after I posted a question at SQL...

Read the latest Blogs

Forums

ALAMAT BCA KCU SUBANG WA CS 082225313145

By layanan 24jam BCA

Hub 0822 2531 3145 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...

The SQL Server MCP Server

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server MCP Server

The Hidden Danger of Wildcard Operators In Join Operations

By sabyda

Comments posted to this topic are about the item The Hidden Danger of Wildcard...

Visit the forum

Question of the Day

The SQL Server MCP Server

How do I get an MCP server for my SQL Server 2025 database from Microsoft?

See possible answers