why isn't there just a simple index on both date columns in the order you need them ?

create index X_yourtable_dates on yourschema.yourtable (date1, date2);

might be another solution to avoid...

according to BOL this should work with SQL2008..

select *

, SUM ( TranAmount ) over ( partition by Account order by Account, datetrans, uniqueID ) as RunTranAmount

from yourtable

order by Account,...

cluster service account only needs "login" on your sqlserver instance. That's all.

We remove...

yes, no.

We run cluster services using its own service account and use sqlserver (domain) service accounts for every sqlserver service.

please don't use the C$ share for this purpose ! It is supposed to be for administrative stuff.

Create your own backup share on your target server, grant the service account...

wendy elizabeth (6/19/2012)

---

I have two tables that I am questioning in a sql server 2008 r2 database. The table called [dbo].[AT] is the main table. The table called

[dbo].[AT_Pln] can...

chris-320654 (6/19/2012)

---

I re-ran my tests with hyperthreading disabled and there was no benefit at all. If anything times were very slightly slower for the single threaded powershell test, and noticeably...

all.

have a look at Features Supported by the Editions of SQL Server 2008

Roy Ernest[/url] published a great series of...

Nice example of change tracking.

You mention

but the article lacks the example or refs to do so.

e.g. as a starting...

I like the solution Gail handed over.

Especially because it lets you identify the bogus information easily using "WHERE HardwareNumber is NULL".

So, unless you really need this column to be...

You're encountering one of the "little" mishaps known with msaccess db.

did you try something like this ?

Declare @mycounter int = 999999900

UPDATE tblAsset

SET HardwareNumber = @mycounter

, @mycounter +=...

Kick out ALL udfs you use and write the proper query to fetch the data you aim for.

Without a sqlplan, it is up to our imagination to figure out...

:blush: regarding HP, I can only tell you should upgrade practically all drivers before throwing it into production.

We learned that the hard way when we were forced to move...

Until now, the obvious question has not been raised :

Is your SQLInstance on the latest service pack ? How to obtain ...

Select Serverproperty('ProductVersion') as ProductVersion

...