You may be right 🙁

...which is why I'm interested in understanding more about why performance is critical....

A few observations first:

I went ahead and downloaded and restored the file, but I should point out...

Did you restart SQL Server after configuring TCP/IP?

Ok, the next step: creating a Descendants ITVF.

First, create the table with test data, and create the ITVF:

USE Sandbox -- Use whatever DB you want, this is just my...

If I'm understanding correctly, it looks like you're trying to obtain all of the descendants of a particular organization in a hierarchy. One way to handle that is with a...

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

http://www.amazon.com/Microsoft-Data-Warehouse-Toolkit-Intelligence/dp/0470640383/ref=sr_1_1?ie=UTF8&qid=1321019458&sr=8-1

pwalter83 (11/10/2011)

---

No, I dont agree with you..you did your best based upon what I sent you. Thanks for your help also !! you dont know when your solution could come...

ChrisM@Work (11/10/2011)

---

This should do it:

SUM(CASE WHEN e.EQUIPMENT_TYPE_CD like '20%' THEN 1 ELSE 2 END

* CASE WHEN e.BOOKING_EQ_REQ_DETAIL_ID IS NULL THEN 0 ELSE 1 END) AS BookedTEU

This gives you a...

Thanks! It would be best if you could post table code and sample data; here's an article that explains how to do that: http://www.sqlservercentral.com/articles/Best+Practices/61537/ However, here's a quick stab at...

I'm guessing the error you're getting is: "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."

In order to do something like that, you'll probably need...

What is your question?

sqlfriends (11/9/2011)

---

I would like to generate multiple insert statements like below that l need to run later.

insert table column1, column2, column3.... Values (......)

insert tabel ..................

I know I can use...

Hakuna Matata (11/9/2011)

---

In general

If Fragfragmentation <5% No Issues

...

erikpoker (11/8/2011)

---

JonFox (11/8/2011)

---

Approximately how many rows will be arriving from the DW with each refresh? Is it safe to assume that minimal downtime for the end-users during reloads is the...