and one non clustered index

CREATE NONCLUSTERED INDEX [IX_SmsJob_PriorityStatus] ON [dbo].[SmsJob]

(

[Status] ASC,

[Pri] ASC

)

INCLUDE ( [Size],

[MessagesCompleted]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF,...

Sure:

CREATE TABLE [dbo].[SmsJob](

[JobID] [uniqueidentifier] NOT NULL,

[Name] [nvarchar](50) NOT NULL,

[OwnerAppName] [nvarchar](50) NOT NULL,

[OwnerAppVersion] [nvarchar](50) NOT NULL,

[Pri] [int] NOT NULL,

[Status] [int] NOT NULL,

[Size] [int] NOT NULL,

[MessagesSent] [int] NOT NULL,

[MessagesCompleted] [int] NOT NULL,

[PackagedAt]...

The complete select is listed below (captured from the trace)

SELECT

[Project2].[JobID] AS [JobID],

[Project2].[Name] AS [Name],

[Project2].[OwnerAppName] AS [OwnerAppName],

[Project2].[OwnerAppVersion] AS [OwnerAppVersion],

[Project2].[Pri] AS [Pri],

[Project2].[Status] AS [Status],

[Project2].[Size] AS...

ok. The problem is I cant modify the EF generated scripts since they are generated dynamically. I meant if these scripts are hardcoded with the isolation level as serializable and...

The other point that I would like to bring in is if i query on the database the DBCC USerOptions I get the isolation level as read commited snapshot but...

apologize for the delay:

deadlock-list

deadlock victim=process3ed3948

process-list

process id=process3ed3948 taskpriority=0 logused=0 waitresource=KEY: 6:72057594055229440 (c85b14958736) waittime=4753 ownerId=267795423 transactionname=user_transaction lasttranstarted=2012-01-04T14:02:25.960 XDES=0x4fcb4b950 lockMode=S schedulerid=6 kpid=156 status=suspended spid=159 sbid=2 ecid=0 priority=0 trancount=1 lastbatchstarted=2012-01-04T14:02:25.963 lastbatchcompleted=2012-01-04T14:02:25.960 clientapp=.Net SqlClient Data...

Pasting the deadlock information again to remove the emoticons:

Deadlock encountered .... Printing deadlock information

Wait-for graph

Log Viewer could not read information for this log entry. Cause: Data is Null. This method...

Hi Gail,

First off I wish you a happy new year!!!

deadlock information:

Deadlock encountered .... Printing deadlock information

Wait-for graph

Log Viewer could not read information for this log entry. Cause: Data is Null....

ok...this is a daily running job and I also have the auto update stats enabled...is it a good practice to have it enabled while i have this job running daily??

Hi Ron,

Thanks for the script. That really helps a lot. The sum(rowmodctr) column is returning records more than 45000 for some tables. But is there a way to know which...

Hi okbangas,

I did not get an option of selecting the option of fullscan or sample for the update stats as it is part of a maintenance plan and since...

Hi Ron,

I used the maintenance plan wizard to create this update statistics and I have selected only the required user databases. I am not rebuilding or reorganizing any indexes along...

Thanks Alburaj. Do you have any urls for using the for loop with a collection of input parameters, like in my case i will be using the same parameter with...

Hi

First of thanks for the reply.

Yeah I tried the method which you already proposed. It didnt work. All I got was the error that I pasted earlier. Hence I...

I am attaching the document with the flow of screenshots and the error I am facing when entering multiple variable values. Hope this will clear you what I am exactly...