I'm not so sure. During a presentation from MS a couple of weeks ago they said that Itanium are mostly preferrable on system with 8 or more CPU's.

On a system with...

Joel,

not sure what you have tried, but this works on my system:

SELECT REPLACE('Microsoft™',char(153),'')

Markus

Trigger,

there's no need to enable AWE. And from what I understood, you only need the "lock pages in memory" option on a 64-bit system. So if you're running a 32-bit...

I applied SP1 and SP2 on several clusters and never had any real issues. For the clustered services (DB Engine, AS) the SP installation will automatically upgrade both nodes. But...

James,

yes that's the right approach. I forget to mention in my earlier post that you shoould run update statistics after restoring the databases to SQL 2005, because the old statistics...

You can use something like this:

USE msdb

go

DECLARE @date datetime

SET @date = floor(convert(float,getdate()))

SELECT backup_start_date,database_name, type, CONVERT(decimal(20,2),

backup_size * 1.0/1024/1024) as MB,

CONVERT(varchar(12), backup_finish_date - backup_start_date,108) as BackupTime

FROM backupset

WHERE backup_start_date BETWEEN @date...

Since you post is caled restore sql7 to 2005, the answer is yes you can restore SQL7 backups on a 2005 server. You might want to change the compatibility level...

Sounds nice, only problem is I laready passed all exams behalve the BI exams and I don't think I will take these anytime soon. So looks like I have to...

Just execute the script in query analyzer and it will create the jobs.

Markus

I usually just script all the jobs in EM. Select all the jobs you want to script, right-click them and select "generate script"

Markus

Ed,

if you're running your script within a SQL server job there are usually two possibilities. It can either run under the security context of the job owner or the SQL...

Jim,

index depth is basically the number of levels in an index b-tree. See also http://msdn2.microsoft.com/en-us/library/ms177443.aspx

The reason index with a depth of 0 are excluded is that such an index...

Jason,

I agree there are lot's of sources and sometimes it's hard to choose. If you've never done anything like this I would start with the Tutorials from BOL in SQL...

Sri,

you need to enable either TCP or Named Pipe as a Server protocol. With shared memory only local clients can connect.

Markus