It depends which table or tables have altered transactions.

You could have a table with two tinyint fields or you could have a table with 8060 bytes per record which includes...

http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp

http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

I'm not sure about moving the master to a completely separate box.

I can understand moving MSDB because of all the jobs etc, but I understood that master...

Registry setting HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLSERVER\MSSQLServer\BackupDirectory

I've got a great big list of what all these registry settings do somewhere and I plan to write them up as an article.  It's just one of...

Another migration tool that I have used in the past is Datawatch Monarch.  I'm not sure what it can do these days but at the time I was using it...

I can recommend a utility called DBMS copy.

The company that wrote it has been bought out by the SAS institute who sell it through their dataflux subsidiary.

http://www.dataflux.com/Downloads/DBMS/DBMS-Copy.pdf

I've not hit the magic billion but I have done 100's millions.

I used to take the production server down for a morning when I did it.

My approach was as follows

• Calculate...

If you are going to block NULLs from the database you have to put checking in the client layer to ensure that there is no way that a user can...

Do you import it into  NVARCHAR, NCHAR, NTEXT fields?

If you try and import it into VARCHAR, CHAR and TEXT fields then the characters will simply convert into the low byte...

If you are running stuff on server 1 and pushing to server 2 why not turn the problem on its head and run from server 2 and pull from server...

How are you copying the data?

• DTS
• Replication
• Some manual process

Are your servers linked or remote. 

I had a number of problems with remote servers.  As you know BOL recommends the use of...

What login does the target server think you are?

What permissions does that login have?

I've found that if I create a login on one machine ,then copy that login to 2nd...

99% of the time I use ISNULL.  It does what it says on the tin.

COALESCE is useful when you have to have some form of construct that is IF @a...

Depends on their caffeine intake

Seriously though, there are so many factors that determine how much administrative work needs to be done that it...

There are certain coding jobs that are the IT equivalent of cleaning the loo.

Dealing with NULLs, dates and default values etc.

If you can take this away from your developers and...

If you are absolutely positive that the records that you are about to delete don't have an related records in other tables then, as part of the delete process, try...