did you restore that database ?

if yes, then check the database owner and put it back to the one it was before the restore (if you didn't alter it,...

If you are considering READ_COMMITTED_SNAPSHOT first check out the impact of its usage ( tempdb ) !

If you have a single Insert/update/delete window, maybe putting the db in read_only mode...

Thank you for the feedback.

It does indeed ring a bell, but far far away 😉

I wouldn't do that, you'll end up having way to much similar indexes !

You need to...

How well organized is your...

one-1016367 (12/16/2009)

---

No, as I said I haven't written this SP, nor have I attempted to optimize it.

When indexes are used the original SP runs relatively fast, but your...

Did you ever test this ?

CREATE PROCEDURE [PxTransactionListByDatesAndMerchantID]

(

@Merchant uniqueidentifier

, @Date_From datetime

, @Date_To...

If I'm correct,

you could also just use a NAS to perform your tests;

Your goal is to test Clustering and failover, not SAN technology.. correct ?

Buy a NAS for a...

Off course it is good to try to solve the general findings for simular objects.

On the other hand, consider it like an actual engine, the more high performing it...

Ever calculated how many milliseconds that are ???

Milliseconds because that's what we are used to take into account 😀

:hehe:

euhm .... September 2008

In that case you may be able to do a side by side install of your web edition.

The prepare that instance by adding the needed logins, and restoring/attach the userdb...

parthi-1705 (12/15/2009)

---

Hi

Actually datas are populated yesterday only i am having the backup on weekly basis thats why i could not able to get the data.

How to find which user...

it's a petty the plan doesn't show all the batch SQL

Just for a starters ....

IMO the first query should have this alternative tested/compared with:

select submittal.recruiter_source as recr

...

It's a petty you need to find this "missing link" the hard way :crying:

You need to...