Thanks.

Mike you have Query Cost statistics throughout your post. How are you calculating that?

Look at SQL 2016's setup. This issue and enabling instant file initialization are now both handled.

Will SQL Policies add an ExecutePS (execute PowerShell) function like its current ExecuteSQL & ExecuteWQL?

Phil,

I haven't seen more than one company in the last 20 years that protected & monitored data sufficiently. I would love to work for a shop that used Securesphere or...

Three options:

1.) Give up. It's hard and you're not really protecting that much anyway. Just your company & its clients data. (Sounds like many of you already have.)

...

Guardium from IBM and SecureSphere from Imperva are designed to monitor and alert all risk trying to attack your data. They both have essentially SQL proxy's which can prevent SQL...

Two year old comments in app that still didn't work correctly........"Sprayed perfume on this dookie to try and make it work."

PBM is awesome and would work perfectly in this situation. I work with a group that has over 1000 policies monitoring 300+ servers including Dev and Production domains.

Deploying every policy...

No I would not buy SQL Standard to build the app on the hardware you describe. I would by Developer Edition write the SQL code in ANSI standard and then...

Have you tried using SSRS Report Builder for Ad-Hoc queries in place of Access? It has much better performance than Access, limits what they have access to, & is free...

create the following sp:

USE [master]

GO

/****** Object: StoredProcedure [dbo].[usp_job_notification] Script Date: 04/02/2009 16:22:17 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[usp_job_notification] @job_id uniqueidentifier as

set nocount...

The reason you are seeing this issue on new equipment is simply that SQL is outperforming the disk IO. The IO errors you are seeing are informational in nature stating...