change the database cursor to:

DECLARE DBName_Cursor CURSOR FOR

select name

from master.dbo.sysdatabases

where name not in ('mssecurity','tempdb') and databasepropertyex(name,'Status') = 'ONLINE'

Order by name

Not sure but maybe this is what you want ?

use ;

go

declare @vMin int, @vMax int, @vTotal int;

set @vTotal = 142607203;

set @vMin = 1;

set @vMax = 5000;

while @vmax <= @vTotal

begin

BEGIN TRANSACTION

insert...

Arthur.Lorenzini (11/26/2007)

---

I have the following code:

DECLARE @ConsultantIDASnVarChar(50)

,@StartDtASDateTime

,@EndDtASDateTime

SET @ConsultantID = '0000112'

SET @StartDt = '2007-05-01'

SET @Enddt = '2007-05-31'

DECLARE @QuarterASDateTime

Declare @YearASDateTime

SET@StartDt = Convert(DateTime,Convert(nVarChar(50),@StartDt,101) + ' 00:00:00.000')

SET@EndDt = Convert(DateTime,Convert(nVarChar(50),@EndDt,101) + ' 23:59:59.997')

SET @Quarter =...

Copying *large* files (like backup files 😉 ) across the network causes such problems. I have struggled with M$ support to no avail. My solution was to upgrade to Enterprise...

The recompilation can be triggered by a ton of factors one of them is updating statistics. If you update stats the plans depending on the updated table will be recompiled.

Songezo Rexe (11/26/2007)

---

This is what i get from the sys.dm_os_waiting_tasks. What do i do from here. pls help.

wait_duration_ms wait_type

-------------------- ------------------------------------------------------------

2688 ...

you should take a HARD look at the index usage of your queries.

STATS UPDATES with FULLSCAN is mandatory (it has been my experience)

Warning! you shoul make sure that :

is what you really want ...

to be safe run ipconfig/flushdns

To prevent any cached entries from touching the wrong server.

loach (11/20/2007)

---

We have a similar need, but chose a completely different approach. The batch processor is a C#.NET app running as a service on separate machines (actually a set of...

I would do the SET option at CONNECTION level 🙂

Definitely was not expecting this much feed back. Apparenly Steve has a nack for "debates".

Good one Steve!

Bad choice for an index seek 🙁

You should try the NEWSEQUENTIALID instead or another form of ID that is serchable...

That is not so "black" or "white" ... 🙂

It helps with "locking/blocking" issues but it generates a large amount of activity on tempdb.

In adition you may get some "undesired" effects...

I have seen cases in which critical performance is required and Foreign keys are in the way. But those were extreme cases.

Cheers,