arch .. you posted in a SQL2008 forum, hence the refs to it.

Anthony already provided the link to your solution 😉

/* SQL Server 2000 - sa password changes */

USE Master

GO

SELECT...

just as a side dish ... why is column datekey not a date column ?

May avoid conversions to take advantage of date functions.

( maybe that's all been covered in your...

Did you check this article http://www.sqlservercentral.com/articles/Security/87159/

or this thread : http://www.sqlservercentral.com/Forums/Topic988899-149-1.aspx

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 +=...