See

http://www.sqlteam.com/item.asp?ItemID=412

http://sql-server-performance.com/jc_sql_server_quantative_analysis5c.asp

for covered indexes

Frank

quote:

---

29, married, a 9 year-old, and a newborn (was half way home and look what I did). Poor fact is this is...

quote:

---

Darn it brain is fried with the new baby here. What do you mean by covering index, jpipes? For some reason my...

quote:

---

McDonalds, COke and Krispy Kreme.

---

well, two out of three isn't bad at all.

What is...

Well, I'm not sure if I understand everything said above, but a crosstab must not necessarily contain many case structures. The by far best explanation how to do a crosstab...

quote:

---

The client keeps getting error 'ASP 0113'.

Script timed out.

/formDGVBody.asp

The maximum amount of time for a script to excute was exceeded.

I checked MS...

quote:

---

If you want a good book covering Analysis Services, take a look at "SQL Server Developer's Guide to OLAP with Analysis Services"...

quote:

---

I apologize. I was just being polite. I do appreciate your time.

---

there is nothing wrong...

Hi McDavis,

quote:

---

If you have not already done so take a look here at the following article.

http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

But there are factors such as Connection...

quote:

---

SET SHOWPLAN_TEXT ON

GO

SET NOEXEC ON

GO

SELECT 2.Early FROM Morning 2

ORDER BY BrainPower DESC

GO

---

quote:

---

Older than dirt - 47. Just married so we will have children in the future. Wife is much better...

quote:

---

Ahh, the magic of copy/paste...

---

???

Share you knowledge with me, o great fountain...

quote:

---

No kids yet, but I'll keep that in mind:-)

---

oh no, that's enough.

Time for another...