Thank-you for your time everyone!

I tried this agains all 54,000+ rows and it returned correctly in seconds! Thanks so much!

40 Mins for 8Gb. I'd take a long hard look at the server Disk I/Os and other issues like AV interference with SQL function. 40 Mins is crazy time.

Something worth thinking on with SQL 2008 is the Filestream functionality. I am told reliably (an MS source) that this was developed specifically with SharePoint in mind. The idea being...

danschl (10/22/2008)

---

since there isnt going to be a sql2005 sp3

sql2008 is actually that, so we arent upgrading to sql2008 from sql2005

but it there is a new server purchase it will...

Very wise words.

I was doing...

I had great fun being asked what I did for a living and saying 'Security Consultant' then being asked why I had 4 computers in the house if I was...

D Smith (6/26/2008)

---

In my experience, those who refer to anyone in the hardware and/or software industry as an "IT guy" simply don't understand exactly what it is we do. ...

Ok Going back on the point:

I think the Doctor gets called Doctor and not 'the doctor guy!' because of respect for the profession. Nice bonus being called a doctor as...

I think the 'IT Guy' title is similar to the 'Engineer' title. People use the title engineer with wanton abandon and little care or value for real engineers and IT...

I'm using a combination of MOM 2005, SQL Management Studio, Brightstore and some scripts. I'd like to look at Redgate stuff in the future (I followed the AD banner and...

Excellent! Thanks for the prompt (and useful) replies. I went with option 2 and used the SQLCMD which has worked a treat.

Is it possible to loop SQLCMD so that the...