Why are you continually shrinking the database file.  It is very expensive for it to grow again, and clearly it needs to be that big for some sort of processing. ...

Try looking into a case statement within your select clause. 

Tom

I think you need a sum instead of a count on the count field.  If there are 45 rows in the table your always going to return 45 rows for...

Try setting up replication and dropping it again.  I know back in 7.0 I would have to do that to get things cleared up correctly.  Haven't had to in 2000.

Tom

It doesn't avoid page splits they just always happen at the end of the file.  Page becomes full, split happens, half of page is left empty at end of file...

When I came to my present job they had 2 database servers they were getting ready to replace.  I looked at the servers and noticed that there were several db's...

I've run into some space issues with the dbcc reindex in the past.  I had to write a custom proc for one db that after certain of the bigger tables...

I'll agree with Colin, I've never heard/seen a perfect sql statement taking over the processor on a machine.  If it's that perfect it wouldn't be a problem in the first...

You mention that the query is doing index seeks, but what kinds of joins is it doing.  Loop, Hash, or Merge.   If it is doing a loop join and returning...

If no searches/query's are making reference to the listid column than that being the clustered index is horrible.  Plus, depending on the number of inserts into the file, an identity...

You can use straight ddl to create the table syntax is a little different.

Create table qgpl.mytable (col1 varchar(20), col2 decimal(5,0))

You can run this multiple ways, third party sql tool, runsqlstm...

Do they see any databases within enterprise manager?

Tom

It's a permissions issue with the other users.  If you don't have access to the database it will not show up in enterprise manager for your user.

Thanks

Tom

Dave,

You'll have to with Sql2005.  Internally, I don't feel it's that big of a problem.  I would still look at keeping it seperate if I could.

Tom

John,

sp_validatelogins

Tom