select * from mytable where myid in (select top 5 myid from mytable order by mydatefield desc)

are you running sql server accounts under localsystem or a domain account - lock pages in memory is usually defined under the security policy (i think) for your user account

what's your biggest database size?

select case

when tstarttime=@endtime then datediff(hh,@starttime,@endtime)

when tstarttime>=@starttime and tendtime>=@endtime then datediff(hh,tstarttime,@endtime)

when tstarttime<=@starttime and tendtime=@starttime and tendtime<=@endtime then datediff(hh,tstarttime,tendtime)

else '0' end

from mytable

or thereabouts

if it has mystically doubled in time but the .bak file is the same size then the obvious one to check is in the maintenance plan - check if the...

thats correct - on failover 2 instances - beware you have to have different instance names!!

i agree with lowell though. they shouldn't hardcode the database name. it might be...

not sure i understand the reply - basically turn the passive node into an active node.

no point running 2 active instances on the same hardware unless you go into a...

i'd proboably say install the other instance on the failover node and set it up as ACTIVE/ACTIVE.

at least you can make use of the other node for reporting or other...

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

should cover some of it.

flame!!! right on wangkhar...

I think the key thing here is that developers have to accept that it's the DBA that has to manage the database/server for their application long after...

To Marti, I ask: When I worked in a large shop there were change control meetings daily, weekly, monthly, and development would have had to get their schema changes approved....

I'm lucky in that i'm both developer and DBA as well. (primarilly DBA tho)

i think the problem lies in the mentality difference between developers and DBA's

if you think of the...

what account run the replication on the subscriber (if it's pull) or publisher (if it's push) - does this account have permission to use this.

i'm guessing that your account...

SalesLineItem: (itemCode, quantity)

where is the reference to saleID

perhaps

SalesLineItem: (ID(PK),saleid(FK),itemCode(FK), quantity,)

just a thought

customers are an entity

Sales: (saleId,, customerID, amount, storied, saleBalance,

Customer: (customerID,mobileNo,CustomerName)