Thanks for the insight in SP's and "special" feature parts thereof.

Barkingdog

Good replies from everyone.. I don't think it is causing an issue but it just bothered me because that 11gb being held by sql can not be used by...

Good ideas from everyone. Thanks.

Barkingdog

Thank you Mark.... good ideas... let me toy with them.

Barkingdog

Interesting thoughts from everyone. Unfortunately the developer has modified the query so the original problem no longer exists. In other words I can't provide the needed execution plan. Sorry about...

Why not a full backup every day? Time window.

The databases on this server are related to our datawarehouse and the smallest one is 500GB. We also need...

Jeffrey,

You wrote

>>>>

I would expand on this - keep everything as long as you possible can. I cannot count how many times (on this site and others), where someone has run...

Lutz,

We keep the trans log dumps both locally on the sql server and copy them to another server (on the hour).

When you wrote: "At the minimum level you need...

>>> use a hex editor to see what's left in the tempdb files after they've grown.

that's certainly an interesting idea though I think I will be overwhelmed by the sheer...

But since text\image are depricated and the pdf's (because of size) are not the best candidates for filestream, what datatypes reamin that I can use?

Barkingdog

I thought that "varbinary(max)" was actually the equivalent of filestream. Yes, no?

Barkingdog

Let me clarify the last point. Suppose we have three users, say User A, User B, and User C. The application program will verify they have permissions to...

Gentlemen,

I must say this "simple" question led to a lot of good discussion and insights. Thanks to everyone for their help. Case closed.

Barkingdog

Jeff,

You wrote

>>> At any rate, the WORST thing you could possibly do is use a BEGIN TRANSACTION on this problem.

Why is that the case?

In fact, my solution is exactly the...

Jeff,

My solution is the same as yours except I used:

SELECT @return= NextID FROM seqNum with (UPDLOCK)

Given the table has only a single record I think the solutions are equivalent. But...