Check your paging file values. It could be tied up with that.

Is this your personal box or a production machine?

Are all your SQL instances...

You need to check your Server properties and see if SQL has priority for memory or not. Also, remember that just because the memory is available, if SQL doesn't need...

As of others have mentioned, you can put the table on a separate file or filegroup for backing up.

Of course, if you're trying to restore this table to a...

The only way I know how to do this is plan in advance.

We have a "user" database that we SELECT...INTO all data from the tables we are updating prior to...

This sounds to me as if...

You could also use OpenRowSet without creating a linked server, I believe. Or SSIS.

There are plenty of methods available. The question is, what tools does your workplace have available for...

It could be also that the drive containing your TempDB is full. That error comes up for me when that happens. TempDB in our place is on a different drive...

My favorite interview question to ask interviewees is "How to you do a point in time restore for a database in Simple Recovery Mode?"

Simple question, right? Yet, it stumps so...

Nevermind. I finally figured out how to make the stupid Conditional Operator work correctly. It kept complaining that I couldn't use a LEN() function in conjunction with a string. a...

My thought on this issue is that the server still thinks something's wrong.

Announce to your users that you'll be taking the server down for maintenance on X date at...

And don't forget to check the size of Model too. TempDB is created off the settings on Model (all databases are) and if Model was changed, than all dbs will...

Hee.

Thanks, Steve. I appreciate the support.

Brad,

I too am a fictional writer, so I understand the pains you're going through. However, most people who publish code solutions on the internet usually do so with the expectation...

Ahh. Okay. That makes more sense. @=)