No Problem. I haven't personally had these problems yet. Just wanted to know. 🙂

Jeff Moden (4/27/2012)

---

By...

Gail is right....Scan count != number of time a table is scanned.

As per Books Online, Scan Count is: Number of index or table scans performed.

Scan count is 0 if...

GilaMonster (4/27/2012)

---

vinu512 (4/27/2012)

---

ESAT ERKEC (4/27/2012)

---

Which query performance is better perf1 or perf2 ?

perf1: Scan count 0, logical reads 23, physical reads 0, read-ahead reads 0, lob logical reads 0, lob...

Sorry...didnt see your second post carefully.

In your first post you wrote:

perf1: Scan count 0, logical reads 23, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads...

Is the result set returned by both the queries the same???...There must be conditions in the Where Clause....are they same in both the queries???

ESAT ERKEC (4/27/2012)

---

Which query performance is better perf1 or perf2 ?

perf1: Scan count 0, logical reads 23, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads...

You sure are welcome....:-)

Yes, Sql Server Express Edition comes without the tools...thats why I was asking which Edition.

+1

The Error is:

'average' is not a recognized built-in function name.

But I can't see 'average' anywhere in your query.

1.

Suppose you have an application which connects to database DB1 on Server S1.

Now, your application needs some data occasionally (no huge number of transactions) from another database DB2 that is...

This will help you :

Loading XML Data into SQL Server (SQL Spackle)[/url]

This is a mismatch between the SQL Server and the Integration Services Module.

I think that your SQL Server is 64bit but...

+1 imex

Yes. If you want "@c" to be calculated then you...