Also what are the implications of multiple versus one instance for load on tempdb?

i have 2 physical disks.

c = raid 1 for OS and log files.

d = raid 5 for...

Thanks for your help. Hi Jeff yeah been out of the DB world for a while.

There are 4 database which run third party applications. I gather performance and maintenance is going...

what are the implication with regard to performance?

i have one server to play with. Would it be better to have them as seperate instances. They are not huge.

logged out of windows the restore takes place on the server.

but i cant do it for this restore which  is already gooing?

nope just logged of the client terminal. Restore is in progress.

are you sure there arent any lines of the address that are meant to have spaces in them. So when you spilt the address on space you will cut lines...

?

what does this data mean?

As sergiy points out short of hard coding the vlaue you want to have a corresponding null there is not way of doing this. Whats special...

SELECT Year(logWritten) as [Year], MONTH(logWritten) as [Month],Day(logWritten) as [Day of Month],

count(WebLogID) as 'Visits'

FROM Weblog wl

join URLStem us

 on wl.urlStemID = us.urlStemID

where StemText LIKE @strSearch

and logWritten BETWEEN @statDate AND @endDate

GROUP BY...

you should set the fields to null rather than your 'no data' string

have you applied the service packs?

yep doing that in the bcp call wondered if that might be the problem

thanks. DO you know if there is a limit on the length of the sql statement ececuted?

In what circmstances will my code not work?

column names in with clause are case sensitive.

ProjID differs in case from the xml document to the with list.