Indeed.

The prerequisite is you need the clustered index organized for your processing needs ( AccountID, [Date] in the example ).

Any other organisation will cause the mechanisme to fail.

I tested multiple...

As you suggested the "Order by" testing with Jeffs solution, I also tested your marvellous solution for partitioned objects.

First findings .... It no longer works .... SQL2008 ( sp1 )...

hmm ....

I ran this comparisson on

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)

Mar 29 2009 10:27:29

Copyright (c) 1988-2008 Microsoft Corporation

Developer Edition on Windows NT 5.2 ...

When we had our first HP servers, we needed to get used to the fact you need to update your HW drivers before you implement whatever kind of software.

No...

this will cause implicit conversions !

Implicit conversions may cause indexes not to be used optimal or not at all.

Even with cast/convert (which are explicit conversions) one of both columns...

So, you're not entitled to restrict the instances number of connections to the number you want.

You could use logon triggers to do just that for you.

You could set it...

You cannot do that using the regular backup / restore mechanisme.

You can script the full database (tick sql2005 compatibility mode !) and then create it at a sql2005 instance, and...

- How much physical memory (RAM) is installed in the server ?

- Is this a dedicated sqlserver server ?

-

Duration: 14434 seconds. Working set (KB): 10540, committed (KB): 38756, memory...

is dbcc opentran showing info (execute in the correct database !)

There may a couple of reasons you did not receive the meanth mail.

- check you db-mail objects to see if it has problems

use msdb

go

exec sysmail_help_queue_sp -- @queue_type = 'Mail'

go

select...

BP is to close the connection.

If you have connection pooling enabled, windows will keep the ( logically closed ) connection open (I think by default 60 seconds).

So if you...

Gail has written a nice article : http://www.sqlservercentral.com/articles/64582/

Also keep in mind you transaction log will grow up to the size it needs to handle your largest transaction !

Also keep in...

SQL Server Migration Assistant for Access

Brief Description

Automates database migration from Access to SQL Server 2005.

http://www.microsoft.com/downloads/details.aspx?FamilyId=D842F8B4-C914-4AC7-B2F3-D25FFF4E24FB&displaylang=en

- is the sql heart beat check working ?

(cluster account needs connect granted for the sqlinstance)

AFAIK no.

It all depends on your connections / commands ansi settings.