Get to know Books On Line (BOL) it is your friend. You expand databases using the ALTER DATABASE statement. Something like this:

-- determine file name and current size

SELECT

...

What is the definition of the IX_QueueData index?

It looks like the AND itemType = @itemType in the WHERE clause of the UPDATE statement is commented out, is it?

Is the insert...

DO NOT use TRUNCATE_ONLY! If you are mirroring you need the transaction log. The ONLY thing that allows the log file to be wrap when in FULL recovery...

If you are on SQL Server 2000 as the forum implies, I think your only choice is to setup a server-side trace[/url]. Then you can query the trace file...

I think you want to look at a CROSS JOIN. A CROSS JOIN creates a Cartesian product, one row for each combination of data. In your situation I...

So what are you getting NULL's in? The entire row or specific columns?

Bob,

Be more than willing to look at the article. I think you have my email. If not pop me a DM and I'll send it to you.

Not much you can do here if that is the combination that ensures uniqueness.

Not...

There are several out there. 2 I recommend are (in no particular order):

1. Ola Hallengren's script which is part of his entire maintenance solution at http://www.ola.hallengren.com[/url%5D

2. Michelle Ufford's...

Using UNION ALL is certainly a step in the right direction. Without having a better understanding of the structures and data it is hard, at least for me, to...

I second this, and I think I actually had mentioned it somewhere else before.

Hey Grant, I think this one would be a good one for you as it is about how the optimizer picks which table to use as the outer table in...

I don't know this for sure, and I think someone like Grant Fritchey might be better equipped to answer this question, but I'll give it a shot.

In the example you...

Check out the permissions section in the BOL entry for sys.columns. BOL is a great resource and can answer most of your questions.