Gentlemen, much thanks to all of you.

I will read up on the FILESTREAM / and storing BLOBS outside of the database.

Will also test using varbinary(max) .

The images should not change...

In the case of a very large table, 1.4 TB, that is not partitioned, what is the least amount of space that will need to be available to build an...

I thought that it was but after reading the link you had above I am going to see about reinstalling. This time I will make certain that "Advanced" is checked....

The SSMS running is:

Microsoft SQL Server Management Studio10.50.1600.1 aka SQL Server 2008 R2

Microsoft Data Access Components (MDAC)6.1.7601.17514

Microsoft MSXML3.0 5.0 6.0

Microsoft Internet Explorer9.0.8112.16421

Microsoft .NET Framework2.0.50727.5472

Operating System6.1.7601

A couple of the...

You guys are all great. Thank you so much for the replies.

The information is valuable and greatly appreciated.

Okay ... just ignore me.

I forgot to use sp_spaceused to look for the temp table in the tempdb database !

which is exactly where it was.

The "error message" had...

Thank you all for the discussion.

In the world I have right now there are only 5 drives not 6.

Considering the "D:" drive is available for SQL data, user...

Erland ... I so appreciate that you have kept with this issue!

Personally I think that for them to knowingly continue to use a query that is incorrect is pathetic.

Many...

So, if the SQL Server 2000 server was upgraded to SQL Server 2005 or 2008 R2, the transactional replication could work for the disparate collations?

Also, to confirm, it is the...

Erland:

Thank you, I will use your replacement in the query.

and now that you ask, that query may be from the Activity Monitor. I do know that one day I...

ELLEN-610393 (10/17/2013)

---

Erland

Our 'max worker threads' is set at the default "0"

Next time I see this condition I will query the sys.dm_os_workers tables directly to get the count.

Since the Activity Monitor...

Erland

Our 'max worker threads' is set at the default "0"

Next time I see this condition I will query the sys.dm_os_workers tables directly to get the count.

Since the Activity Monitor in...

Thank you Gail.

I kind of thought that was the case. Since I am new here I will see if someone knows what the license was really for.

At...

Jeff,

Erland is correct. What I am seeing is thousands of threads for the same spid/session id [not an app that spun up thousands of spids]. Also what is...

Jeff Moden (10/4/2013)

---

ELLEN-610393 (10/3/2013)

---

Gail,

I see that you said that the default 0 for worker threads should be good. What is the impact of having a process spin up several...