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....

When you set up a trace was it with the default options? If so, 40000 isn't that much in 10 min. On some of my servers I can generate a...

Sorry, I'm on course at the moment so replies are going to be occational.

What did you trace? What I think would help, since you're getting this often, is have a...

Database backup at 13:36

Database backup, or log backup? I guess the latter, since db backups don't truncate the log.

I think what might be necessary at this point is to...

Row_Number is a new feature in 2005. there's no function in 2000 that does that.

You can try top. Something like

SELECT TOP 10

phone_no,model,cur_version,