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

Have a look at:

http://msdn.microsoft.com/en-us/library/ms143393.aspx

- Also keep in mind that calling a sproc without providing the correct parameters (DATATYPE !) can cause bad performing queries as well ! (caused by implicit conversions !!)

-...

I hope this little test script will provide some insight on the timestamp data type.

/****** 🙂 best regards ALZDBA ******/

set nocount on

go

/*

@@DBTS returns the last-used timestamp value of the current...

We script all objects of all user databases at least once a week (including all DDL and grant scripts) using SQLSMO.

These scrips a safeguarded in parallel with the visual source...