This article outlines the pros and cons associated with the different methods for moving SQL Server databases to new storage within a 15 minute timeframe.
2014-04-30
3,013 reads
Moving databases is fairly simple, but when you move a system database, there are a few extra steps to follow. MVP Brian Knight walks us through how to move temdb in this video.
2008-12-30
4,721 reads
Something like below:From T1 (nolock)JOIN T2 (nolock) on cast(T1.ID as char(10)) = cast(T2.ID as char(10)) I can't really help you more without the actual data types and some sample data.
2004-04-01
Sorry for the incomplete syntax tsc1, the caffiene has just kicked in Also I have tried shrinking logs in EM via taskpad, but it never works. Anyone else found this? *I didn't do anything it just got complicated*
2003-06-18
1 reads
Because most everything done the EM actualy duplicates the table and moves the data into it, then drops the old and renames the new, all the while making sure triggers, permissions, yadayadayada, stay intact. On large tables it general is better to go the TSQL route with ALTER TABLE with these types of situations.
2003-06-05
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers