When we remove data from tables to files, we use bcp for a table by table basis, and write the bcp configuration file along with it for easy reload, if...

I believe that using the fully qualified name should fix your problem.

Another thumbs up from me....

How about:

SELECT IMCL_SAMPLE.SERV_RQST_ID, COUNT(IMCL_SAMPLE.SERV_RQST_ID) AS SAMPLE_CNT

FROM

(SELECT DISTINCT Top 100 percent dbo.CUST_SVS_RQST.SERV_RQST_ID,

...

A hearty AMEN to Greg Larsen.....

I agree with zach_john. Track down and eliminate the reason for the timeout rather than increase the timeout value.

Do you know whats causing it?

XP_Sendmail is fully capable of sending HTML formatted emails. It doesn't format them for you, but it also doesn't care what is in the email. Format it yourself, and pass...

I have to comment on the statement by pdeprado where he says ....

A former boss gave me a good Human Resources point of view on this subject. We needed to...

This is hilarious. Four years ago, I would go to an interview for a job position, and they would ask what is your strongpoint. They expected a single answer. (VB,...

PAGEIOLATCH_EX is an indicator of an exclusive latch waiting for a page.

It tells you that the Sql Server is awaiting a page from the drive system. Check to see if...

I didn't realize someone else already told you how to deal with it while I was typing.....

As far as Dynamic Sql goes, its beautiful. All explicit conversions, very modular for adding / removing columns, well formatted for easy reading.......

As far as good for performance, I assume...

My two cents is that the certs are not worth the paper they are written on. I've interviewed hundreds of "DBA's" that didn't deserve the name under any definition, yet...

We reduce permissions on our Sql Server machines to admins only as a default. Of course, the SQL login and agent login is a local admin on the box, and...

I saw a situation close to this at a prior job.

We had applied a service pack to Sql Server (I don't remember which one. Might have even been a...