More drives = More Speed, if you've got the cash then RAID 10 is faster but you lose half your capacity, most systems we run here use RAID 5 and...

Great article, I think the bunch of you complaining are taking things a little too seriously, lighten up and laugh like the rest of us.

I've just VSS quite a bit for this, it's simple to use and as most people at the company were developers everyone had Visual Studio anyway so it was an...

Not bad, a little basic though. Would have been nice to see what happened when you had multiple columns in the where clause or if you joined to a second...

How much ram does the machine have?

It will if you are running Windows DataCentre Server, what are the details of your server, OS, SQL Version & amount of RAM, and is it a pure SQL box...

I don't see why not, why don't you just set create the single job and add two different schedules to it. Set them both as monthly and a different date...

Windows will recognise 4 gig out of the box and will be able to allocate a max of 2 gig to any one application. Depending on how much RAM the...

Hard to tell without seeing where you are in the setup, but the basic idea is that you have the real names and IP address of the machines say Machine1...

sp_spaceused tablename is useful but be aware that it isn't always accurate, if you want to know the true size of something run DBCC updateusage ('DATABASENAME') beforehand, this will run...

Use UNION ALL if you want all records from each table, UNION is do the equivilent of a DISTINCT on the result set.

--------------------------------- 

Select T1.ToDisplayName  as DisplayName,                    T1.ToEmailAddress  as EmailAddress ,...

I'm with you on this one Kenneth, it's not Primary if there are two

I'm fairly sure if you use the TOP 1 in your subquery it will only return 1 record which is fine if you're only looking for one company but if...

I've had the same problem, I've only been able to generate one script for a job at a time.

Yer I agree