Technical Article

Generate "CREATE...FOR ATTACH" stmt. dynamically

In instances where you have over 16 data files, or you need to move data files to a new location when you are moving a database you must use a CREATE...FOR ATTACH statement.  This script will generate the CREATE...FOR ATTACH statement dynamically given a database name.  It will take into consideration the file sizes, growths […]

2003-05-07

213 reads

Blogs

Daily Coping 25 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

How SQL Server executes a Query

By

Beginning with today, I want to give you over the next few months a...

Tech Lunch News

By

Předminulou středu jsme opět poobědvali a zároveň si nasdíleli řadu novinek ze světa dat....

Read the latest Blogs

Forums

How to calculate delta in timestamp

By demokedes

Dear all, I am total newbie in SQL. I am having SQL Database in...

Suspended session : Job is taking very long time to complete

By DBA

Hi, I have a job running for more than expected time ( exceeds by...

MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

By Arun Yadav

Comments posted to this topic are about the item MSSQL Server AlwaysON: Get alerted...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers