Is Phone your primary key, if not is in indexed?

How may records are there in each table.

Where is your WHERE clause?

I passed the Ids of the listbox options as a VARCHAR and had a function to take that delimited list and return it as a table.

I could then join the...

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...