Hi Dietmar

First thing that immediately I can think of is "Open transactions". If at all a big transaction is going on and not yet comitted or rolled back, then the...

DECLARE @Date datetime

SELECT @Date = @StartDate

WHILE (@Date <= @EndDate)

BEGIN

-- Process for @Date value

SELECT @Date = dateadd(d,1,@Date)

END

I believe this approach is fine because it may not make sense manually adding the condition for account type (which would be required if derived column transform done above conditional...

Here's the query:

select convert(datetime,convert(varchar(100),run_date) + ' '

+ convert(varchar(2),run_time/10000)

+ ':' + convert(varchar(2),(run_time/100) % 100)

+ ':' + convert(varchar(2),run_time % 100))

FROM MSDB..sysjobhistory

Thanks

Satish...

If I understand you correctly we had a similar requirement where the input date range provided should overlap the StartDate and EndDate values in the records.

Say for example @StartDate and...

Yes Could you please update the stats for Products table as well? Also please mention whether...

CREATE DATABASE statement does not accept variables. You can try dynamic query instead. Check these links:

http://www.umachandar.com/technical/sql6x70scripts/UtilitySPs(6x)/Main9.htm

http://www.databasejournal.com/scripts/article.php/1546441/spcreatedatabaseSQL.htm

Satish

qiyuef (10/14/2009)

---

Can you explain why there will be a deadlocks when SQL Server doesn't perform a lock escalation even when the batch size is high?

Each process will lock different sets...

Kevin.McEvoy (10/12/2009)

---

Really interesting article.

Could the clean up process use something like sp_who to find out if a process was currently running or orphaned. I'm always a bit dubious about things...

mohd.nizamuddin (10/12/2009)

I think Sunny is using this "WHERE 1 = 2" for creating the #LockHelp table only, having no data.

But not sure why, because he has not refer #LockHelp in...

Hi iermis

Thanks for the comments.

The query you mentioned is only for getting a Table Lock on the table. We dont actually need any records from the table but at the...

Thanks a lot again Paul for the detailed information. Your every post gets me fresh and new useful tips.:-)

Hi Paul

I executed the script and it does prove your point. The script is indeed an intelligent and efficient option. It has made me rethink over our XML implementation which...

Thanks to all for the comments and suggestions. Really appreciate them.

Paul - Thanks for the script. I shall go through it during the weekend and let you know.

Thanks Santhi

You are awesome. Your statements put together did my job rightaway. Thanks a lot really

Satish