Database File Move Etc
A stored procedure to generate database file moves along with Robocopy script and the attach / detach scripts
2016-04-20 (first published: 2016-04-04)
561 reads
attach
Change Server Collation in SQL Server 2008
How can I change the collation of SQL Server 2008? Learn how in this short tutorial.
2011-03-15
6,852 reads
Moving Databases with the ALTER Command
A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.
2009-08-26
8,469 reads
Attaching a database in Microsoft SQL Server 2008
Various methods of using the "For Attach" clause exist to overcome the limitations that face us when using sp_attach_db and sp_attach_single_file_db. The first installment illustrates the use of the "Create Database" statement for the "For Attach" and "for ATTACH_REBUILD_LOG" arguments, for a single .MDF file and single .LDF file.
2009-08-24
2,945 reads
Moving Database Files Detach/Attach or ALTER DATABASE?
Learn why ALTER DATABASE should be preferred over Detach/Attach for moving database files on the same SQL Server from MVP Jonathan Kehayias.
2010-09-24 (first published: 2009-05-27)
30,754 reads
Dynamically script Create Database For Attach For All Databases
Modified version of a script that can be found at http://qa.sqlservercentral.com/Contributions/InstallEditor
2010-05-20 (first published: 2009-05-07)
3,770 reads
RE: QOD
lepez, they are not visible any longer. We are looking to republish the questions and answers, so look for that soon.
2004-10-04
2003-07-29
1 reads
RE: Updating 2 SQL Server databases at the same time
You will have to build a distributed transaction. See Books Online for "BEGIN DISTRIBUTED TRANSACTION".
2003-07-29
RE: Importing data from txt file and updating Table
quote: Something like this (Check it out in BOL): update <master_Table> set col1 = <temporary_table>.col1, col2 = <temporary_table>.col2 .... from <master_table>, <temporary_table> where <master_table>.<primary_key> = <temporary_table>.<primary_key> I don't think you acutally need the exists statement as the join has the same effect - i.e. selects existing rows. Cheers David
2003-07-25
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers