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.

I'm not quite sure what you mean by a link to another system. Are you looking to query MySQL, Oracle, or some other system from within SQL Server?

You can look...

Read this and post some DDL/DML and we can likely help. As noted, however, the design probably needs work. If you can't change that, give us some setup and we'll...

Nope, should be changed on all threads. At least, I hope so.

You shouldn't have twitter on all the time. I'd check it 5 minutes a day, maybe see if there's something to interact with, and ignore it the rest of the...