This is just a guess, but I would not be surprised that if you looked at the Execution Plan, that the query is doing an Index Scan, and if you...

A perspective employer could argue that a history of increasing salaries is a measure of competency. If you were doing the hiring and saw someone had remained at the...

As the question specificaly mentioned SQL Server 2005, you could queue up a COPY_ONLY backup to start when the scheduled backup finished. This copy_only backup would not distrupt the...

Hopefully you included the norecovery option in the restore of the full backup. if not, you will have to redo the restore of the full backup.

How many transaction log...

Just one last question, based on the sample data provided, what is your expected output?

😎

Lubo Petrov (4/7/2008)

---

properties of bak file created March 26 at 12:00:20 AM Modified at 12:01:10 AM

properties of trn file created March 26 at 12:00:22 AM Modified at 12:01:27 AM

I'm want...

have you tried this:

select

...

From what I can tell, then the only option short of sysadmin is the dbcreator fixed server role. This would allow them to create new databases, but also to...

Looks like you'd have to assign them to db_owner in those databases that you want them to have backup and restore rights. If you only want to give the...

I agree with with Matt. We just had an on-site instructor out here for a week, and we had him totally skip the Notifications part of the class just...

GSquared (4/7/2008)

---

Since you can't change the trigger, the only thing I can I can think of is breaking up the update code into batches.

if (select Col1 from dbo.Table where id...

We use an Execute Process Task to zip a set of txt files before they are transferred to a MSP. The attached document shows how we have setup the...

Jack Corbett (4/7/2008)

---

Accroding to Wikipedia:

ASP - Active Server Pages

Yes it means that there...

Okay, I'm old and really tired of all the TLA's everyone throws around under the assumtion that we all remember what they are (for example what is ASP, and there...

Sounds like a scheduled job to me. I'd encapsulate the process in a stored proc, and then execute the proc in a scheduled job.

😎