Yes

What it the DBA's objection?

What is the volume of email that you are planning to send?

Is it fairly simple email, or does it have a lot of attachments?

Database Mail seems...

One thing that helps to drive this is the amount of support staff that can be available remotely. I work in a company with a large on-site data center,...

ppreston (10/7/2008)

---

I am confident you can move your 2000 Report Server databases to a 2005 version with no problems. If you wanted, you could keep your 2000 report server...

Just giving this a bump to see if anyone knows about this.

This should get you started.

select

a.[Cust],

Order1= a.[Order],

Order1Date= a.[Date],

Order2= b.[Order],

Order1Date= b.[Date]

from

Orders a

join

Orders b

on

a.[Cust]= b.[Cust]and

a.[Order]<> b.[Order]and

a.[Date]<= b.[Date]and

a.[Date]> dateadd(dd,-7,b.[Date])

order by

a.[Cust],

a.[Order],

b.[Order],

b.[Date]

It is a good rule to always have an index on the columns in a FK.

If the FK table is large, deleting a row from a PK table will result...

It is probably an offset in seconds or milliseconds from some starting point in time.

You might try 1970-01-01 00:00:00.000 (start point for Unix time) as a start time, and use...

How big is your database backup file? Tell the vendor to send you a USB drive that is big enough to hold it. If necessary, you can zip...

Michael Earl (9/9/2008)

---

I'm pretty glad as well.

The alternate universe in which two files could be in the same folder with the same name would be a very confusing place to...

You need to look at the maintenance windows for each application.

If one can only be down on Saturday evening from 18:00 to 21:00 and the other can only be down...

Yes, I saw the same thing when I changed my code to a permanent table. However, that is not really proof that there is no case with a permanent...

I would say the DBA is being stupid about this. The query is obviously not returning the results in the correct order when the application requires it, so why...

I have posted examples like this on SQLTeam several times that shows a select from a table with a clustered index that returns results not in cluster index order. ...

Another thing to be aware of is that there are some zip codes that have addresses in two states.