GabyYYZ (11/11/2010)

---

sturner (11/8/2010)

---

We wrote our own encryption classes in .NET using the cryptographic objects/methods. This gave us the ability use our own key management, and be able to encrypt/decrypt data...

GilaMonster (11/12/2010)

---

Tell the boss that to maintain user satisfaction and acceptable overall performance you would prefer to set up a replica (replication or mirroring with snapshot) of the production server...

All service packs for microsoft products are cumulative - you only need to install the latest one.

That said...Isn't SP4 still in CTP? I wouldn't use that until it's at least...

Are you sure the source table is NULL and not a space?

I had a relatively new box (a year and a half old by now) running a very heavily hit OLTP system fine for months. All of a sudden performance ground...

Tara-1044200 (11/9/2010)

---

Derrick

I understand your concern and my database has only 5 tables which are huge and all 5 of them are condidates for compression as i am restoring a 2005...

Use CHAR(13)

so something like this..

DECLARE @str varchar(50)

SELECT @str = 'I'+CHAR(13)+'LOVE'+CHAR(13)+'SQL SERVER'

PRINT @str

Don't run things between 2-3am, or disable it and run it manually the sunday after the time change.

To re-enable a disabled index, you have to rebuild it using ALTER INDEX REBUILD etc, or just drop it completely (DROP INDEX tablename.indexname)

The reason for needing to rebuild it is...

Crap, I just noticed the same thing...

Script out a drop/create of all your jobs and recreate them all..that will fix it. Whether or not there's a more elegant solution I'm not really sure.

Someone on MS Connect posted that reinstalling .net framework 3.5.1 resolved this. I'd give that a shot.

Declare @Table1 TABLE ( A nvarchar(10))

DECLARE @Table2 TABLE ( X nvarchar(10))

INSERT INTO @Table1

SELECT '123ac45' UNION ALL

SELECT '45ad13' UNION ALL

SELECT 'ac' UNION ALL

SELECT '&34ag'

INSERT INTO @Table2

SELECT 'ad' UNION ALL

SELECT 'ac' UNION...

Ray K (11/8/2010)

---

What if you have...

Typically if you're seeing low PLE, it means your cache is being cleared out very frequently. Adding more RAM does absolutely help this, but your underlying problem might still be...