OK, let me try this one, this is an excellent question in my humble opinion.

You have two types of extents, Mixed and Uniform. In the first statement it indicates that...

I've had similar experiences to Steve, sometimes simply dropping and re-adding the login has fixed things.

Ray Higdon MCSE, MCDBA, CCNA

See this page

http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

HTH

Ray Higdon MCSE, MCDBA, CCNA

Yep, you are absolutely right! Glad two of the fifty responses I did worked 🙂

Ray Higdon MCSE, MCDBA, CCNA

I have not seen a performance benefit with using nolock, of course if you are getting any deadlocks or blocking it would help, but then again, you would want to...

Just having a ball with this one 🙂

Might give you different results but you could also do

select top 5 avg(int) from table

Keep in mind that unless you want the order...

What am I saying...sorry, try this:

select avg(int) from table

where int in (select top 5 int from table)

HTH

Ray Higdon MCSE, MCDBA, CCNA

I'm sure there's a more elegant way but one way is to do a select into then an average.

select top 5 int into ##newtable

from oldtable

order by int desc

select avg(int) from...

Truncate table is a good suggestion, another thing to think about is if your tempdb is filling up, you might need to raise the increment by which it grows.

HTH

Ray Higdon...

That script would scare me...are you doing this to restore a database to a second server? If you are, you might think about writing a static backup job that ouputs...

Size is surely a factor but not the factor I was concentrating on, all I meant was it's harder to predict where your inserts will go unless all three columns...

No, that was probably becuase you had that option on in your transformation. A recompile will just re-establish an execution plan, it will never drop objects.

I had a feeling...

Do you have to be selective about what you copy? If not, might be easier to just restore the database which would include all objects.

Ray Higdon MCSE, MCDBA, CCNA

One way is to use a group by with cube, if you post DDL, can write an example.

Ray Higdon MCSE, MCDBA, CCNA

A clustered index sits at the leaf level of the data in an ordered fashion. So let's say I have a one column clustered index and the data looks like...