We're at 40 million records and about 1TB with major growth coming over the next 12 months. SQL 2005 Enterprise 64-bit on Windows Server 2008R2 64-bit with 128GB memory...

Another concern is if your application sends queries to sql server that include "Like" or range searches. This Safenet product, actually called ProtectDB, has to decrypt every row if...

Sounds good to me. I'll look into getting Change Control approval for using the flushprocindb function in a sql agent job to be run at least daily.

DECLARE @db_id int;

SET...

We do have a job that runs every minute deleting expired sessions from a database that holds session state info. Not sure what you mean by "set connection properties"...

I see many of these same "MSDB" single-use plans on test boxes where Commvault does not run backups. In general we're on Sql Server 2005 Enterprise SP4. ...

Commvault runs backups but doesn't interact with the sql agent at all -- I can see the sql backup commands it executes but don't see why it would have anything...

casting the bytes as float seems to work. Breaking plan cache down by DB is always sketchy.

select

SUM(cast(cp.size_in_bytes as float))/1024/1024 As sum_SizeInBytes_MB

, COUNT(*) As Cnt_plans

...

We do have commvault running transaction log backups every 15 minutes in production, but I see many of the same plans on a test box that only runs nightly maintenance...

I've never posted anything on MS Connect. Here is the query:

select usecounts, size_in_bytes, cacheobjtype, objtype, substring(st.text,charindex('select ',st.text),1800) as selectText,st.text, qp.query_plan

from sys.dm_exec_cached_plans cp

cross apply sys.dm_exec_sql_text(cp.plan_handle) st

...

On our production system I wouldn't be surprised if the MSDB single-use plans are occupying half of the 7.5GB plan cache. This morning I noticed about 40k plans in...

The MSDB plans are generated by the system -- I believe when various sql agent jobs start etc so doubt I can affect them in any way. The flushprocinDB...

I hear you about the "economy is bad." I just read a Monster.com salary survey for Database Administrators. Out here in California is was showing a bell...

I see what you mean Kurt, but I think this whole topic is expanding in scope. From a disaster recovery perspective, let's say you need one DBA and one...

I went ahead and asked. I can get a Verizon USB modem/aircard for free with a $50/month plan with 5GB cap which is fine for VPN work. ...

Another approach to disk space savings would be changing clustered indexes ( based on an increasing data type such as integer ) to have a fill factor of 100 instead...