If you struggle getting things going, master and the error log paths are in the service applet. Once you get that to start with new paths, you can do the...

In production, you would load in batches, and run log backups during the load to keep the size manageable.

In process. I hope to have #1 out in the next month.

That time to restore is based on getting the file lists from the drives. The time seems to vary, but I'm not sure the number of drives attached is the...

varchar(max) should allow 2GB of space. Are you sure this is what the field is set to? How are you determining the 11kb will not fit?

This works:

create table mytest...

As Keith mentioned, it will vary, depending on your system. The truncate should be fairly quick, but the logging of the deallocations might take some time and will increase your...

There was a problem with some information missing in the article. My apologies for that. I have corrected the text.

Welcome, and as Keith noted, more info is needed.

Your explanation isn't really clear to me either. What is the range you are avoiding, what are the edge cases and exceptions?

I like Sergiy's advice.

You could use osql/SQLCMD to do this as well.

Use the START command in a command prompt to spawn a process running your query and run that twice consecutively. It will...

I've used ERStudio and liked it. CA ErWin works, but the last version I used (2002-3) was cumbersome. Visio can do some, but cumbersome as well.

Gary Varga (10/22/2013)

---

I have the following criteria for my posts:

1) There is no existing post that already covers what I would say (although consolidation and/or simplification are viable reasons to...

It...

Pause the log shipping jobs that restore. Let new logs continue to be run on the primary and copied over.

Bring the DR database online (with recovery) and test if things...

+1 to what Sean wrote. You might index on these four columns if that is how you access things, but that doesn't necessarily relate to the PK.