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

Storage Field Day 23 – HammerSpace

By

I am thrilled to have been a part of this year’s Storage Field Day...

Daily Coping 16 May 2022

By

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

SQL Saturday Jacksonville Slide Decks

By

Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...

Read the latest Blogs

Forums

Linked Servers Role

By rogue1009

Hello, I have been asked a question which i am struggling to find information...

Options to access/modify cloud data?

By waxensens

Hi, Novice here, so please forgive my simple question. I have previously run Microsoft...

Row wise sum based on condition

By parthi

Hi All, I have an input like below. mytable: id | name | no...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers