The average time that a page stays in memory is 9 hours, 17 minutes and 55 seconds. Anything better than 5 minutes (300 seconds) is considered to be good.

If it's starved for memory your PLE may drop. Do both nodes have identical memory?

The best stress releiver for me is a good physical workout. When the weather is good I like to commute by bicycle. That way I arrive at work wide awake...

Dale Hughes-356583 (2/6/2010)

---

You guys are not going to believe this, but I was on a support call with Microsoft the other day (yes, back to more issues with my Win2008...

Please see this MSDN blog...

http://blogs.msdn.com/sqlserverfaq/archive/2009/03/16/unable-to-create-maintenance-plans-after-service-pack-2-is-applied-on-sql-server-2005-fail-over-cluster-instance-running-on-windows-2008-cluster.aspx

We are still trying to get this issue resolved. I'm currently working with MS. They spend 3 hours on our new clustered servers this...

If you are building a Windows 2008 cluster your node names must be all UPPER CASE (this may apply to Windows 2003, too). We have encountered this issue and we're...

Not yet - testing involves other users to verify the results. I'll have to see if...

Yes - from Management Studio (QA = bad habit left over from SQL2K). The inserts work fine when run from MS, but won't work when run in a job step....

A lot of good advice has been given. Please don't compromise your integrity.

I certainly hope it doesn't come to this, but if you are fired for refusing to install an...

There, fixed it...

SELECT DATEADD(day, -1, GETDATE()),+ ' Local time',DATENAME (dw ,DATEADD(day, -1, GETDATE()) )

SELECT GETDATE() - 1,+ ' Local time', DATENAME (dw ,GETDATE() - 1)

SELECT GETUTCDATE() - 1,+ ' UTC',...

I assume you want the backup with the date appended so you can keep a couple of days worth of backups. Why don't you backup to dbname.bak and then add...

CU-6 has been released:

http://support.microsoft.com/kb/974648/en-us

Sorry - I think I screwed up the link. Can't seem to fix it.

Editor: Link fixed.

We do want you want all the time:

1. Create a Backup Device for each database (Use SSMS - Server Objects - Backup Devices - right click to create a new...

I think the OP has already shot himself in the foot. If anyone gets a resume from someone named Olgi do you think he'll get an interview?

I have to second fhooglander's suggestion. We, too, backup a 400+GB db every night using Red Gate's SQL Backup and it only takes about 30 minutes. Restores take about that...