When is the release date?

Zip file has been attached

Thanks for the reply. I can definitely add the clustered indexes on our test database first. But I was assuming that a Clustered Index on GUID column wud cause performance...

The query execution plan,query and ddl of tables involved in this sql are attached above

please find attached the query execution plan,query and ddl of tables involved in this...

I already ran this through the tuning wizard and it suggested few indexes and a bunch of statistics with 9% performance improvement

Was the service pack1 slipstreamed?

capnhector (12/3/2012)

---

for testing disk setups brent ozar has a good blog post on using sqlio. sqlio only tests writing a file to the disk and not generating queries though....

Is this applicable to SQL Server 2008 R2 on WIndows server 2008 R2?

I am using the SQL Load Generator tool and actually wanted to use some heavy IO queries on...

CheckDB with repair allow data loss option fixed the errors. My job was able to finish fine now.

USE [master]

GO

ALTER DATABASE [msdb] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE [msdb]...

Thanks everyone for the help.

No this is not a special table. It has data in there luckily no value less than 50 for the column percentcalled so far.

I created a stored proc which is as shown below:

USE [DB]

GO

/****** Object: StoredProcedure [dbo].[CheckStatLog] Script Date: 11/19/2012 16:33:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE procedure [dbo].[CheckStatLog]

as

set nocount...

Thanks for the reply Lowell. The alert is to send out an email if the column value of a table is below a specific number. I have created the job...

Thanks for your help. It works like a charm