If means that on your production server the query is reading more data pages, either from memory or disk, than on the dev server.

There shouldn't be much disk activity on...

This is from memory, cause I don't have a SQL 2000 server here.

In enterprise manager, expand out the server. Select management (I think) expand out and you'll see entries for...

Don't shrink a DB after a reindex. You're just undoing all the work that reindex did.

If you absolutely have to, make sure that you use the TRUNCATEONLY clause, to just...

Check your disks. Sounds like you may have IO throughput problems

I had latch waits on one of my databases some months back. We traced it down to very slow SAN...

Pleasure

Will you let me know if that is the case?

Easiest way to check if there are triing spaces is a query like

select '[' + TheVarcharColumn + ']' from TheTable

then you...

My guess is that the fields still contain the trailing spaces. Varchar doesn't trim trailing spaces, it just doesn't pad to full length.

All the reindex would have done is...

Kalen Delaney and Kimberley Tripp have some good books/blogs/white papers on all this, or if they're running a presentation or course near you get yourself onto it to start to...

What they may be talking about is the fact that on a multi-proc machine, sysprocesses can return more than one entry with the same spid (for a process that parallels...

The 'DBA's' have told me things like XYZ DB is much bigger then your DB and the log file is much smaller

so, it MUST be something the users are doing

only...

You can insert, but only the DBCCs that return a single result set. Some return multiple result sets, some just return messages.

For ShowContig this should work

Insert into ....

EXEC('DBCC ShowContig (''HumanResources.Employee'')...

Stats just give the distribution of data in the column, helping the optimiser make decisions on how to run the query.

They do get out of date, but unless you're doing...

Refer to:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=336277

It's preferable if you don't cross post. People watch all the forums and cross posting means you get bits of answers in a couple places.

As for your openXML, very...

I had this a week ago with a windows group that contained the sysadmins. Eventually traced it down to the fact that the default database for BUILTIN\Administrators was null (no...

The clustered vs non clustered decision is not an easy one.

My personal preference is that every table have a clustered index unless I have a good reason not to....