At a very high level, I'd suggest:

- consider whether you have the appriopriate indexes on the data you are querying.

- looking at the query execution plan, may help to...

Ok, the rewards for trainers might not be so exciting as I'd hope - maybe a Microsoft mug for every twenty students who sit MS exams! But the 20% discount...

Fair enough - but we have just one server (admittedly out of hundreds) where the transaction logs will suddenly stop backing up due to insufficient system memory. All our SQL2000...

I heard it on the hearsay (ie another forum) that Microsoft advise that it is memory leakage when using linked servers. A reboot is the workaround.

For the record - what surprised me is that the server is suitable for Windows Server 2008 (which seems to have the same sort of requirements as SQL2005), but hits...

No, SQL Server is not on the list of services.

It was a few weeks ago when I originally installed it, and I don't recall setting up accounts/passwords. The server it...

Well, I think the previous comments still stand - be honest about your skills and level; get a test system; and learn fast!

Have you come from another background - programming...

I think the first advice that is normally given is - if you know that your data doesn't have duplicates (or it doesn't matter if there are), then you don't...

Obviously the variable @@servername holds the details of the server name, so you can use that perhaps?

I've always used the following:

select substring(@myemail, patindex('%@%',@myemail)+1,len(@myemail)-patindex('%@%',@myemail)+1)

where @myemail holds the email address

so if @myemail="bill.gates@microsoft.com" then "microsoft.com" is returned.

Andreas is (of course) correct - both full and differential backups do not affect the transaction log in anyway. I'd personally suggest that you try it yourself on a test/development...

Do you mean copy? If so, the prime candidate is probably to setup a SSIS (SQL 2005) / DTS (SQL 2000) package which you can schedule to simply copy the...

maybe try:

http://www.oracle-base.com/index.php

http://dba.ipbhost.com/index.php?showforum=2

Some points of interest here maybe - connecting to Outlook via LINQ or ADO/DAO

http://www.outlookcode.com/article.aspx?ID=25

It looks like you can export emails to a file out of outlook into access/excel (admittedly folder by folder) - and then import as normal.

Alternatively, I believe you can connect...