Glad to help.

rwyatt292 (10/1/2010)

---

I'm trying to perform a simple insert into an existing table Ship_b and I only want records from table Ship_a that have different Load_# from records that are already...

spsql (9/30/2010)

---

I need some help on understanding the performance impact when data is moved from OLTP database to OLAP database. In particular, what i want to know is when a...

Derrick Smith (9/30/2010)

---

There are also issues deleting data from a heap..It will not release space back as unused unless you delete WITH TABLOCK. Since he says he purges data >...

Michael Valentine Jones (9/30/2010)

---

PaulB-TheOneAndOnly (9/30/2010)

---

Michael Valentine Jones (9/30/2010)

---

Since, it...

samalex (9/30/2010)

---

I'm unfamiliar with multi-master referential integrity and can't find much about...

I'm in agreement with Gail.

In a star-schema data warehouse you usually end up with one index per each dimension pointing to a fact table so, "n" dimensions pointing to a...

samalex (9/30/2010)

---

I'm running into a situation where I need a field in one table (Foreign Key) to be pulled from the Primary Key in one of two other tables. ...

Michael Valentine Jones (9/30/2010)

---

Since, it is a heap with...

why not?

Please try this.

Test by creating a covered index on ...

b.sending_app,

b.event_time,

b.message_type,

b.receiving_app,

b.service_name,

b.direction

... please order columns from the most restrictive to the less restrictive and let selected columns that are not referenced...

:blink: I'm a little confused here.

First post identifies the table as being [dbo].[MessageLog] - ddl was provided.

Query is referencing table [Message_Journal].[dbo].[Journal]

Are both the same?

itskumar2004 (9/29/2010)

---

I have table with name ABC

Table ABC:

columnname datatype

ID ...

jackimo (9/30/2010)

---

There is no primary key.

There are non-clustered indexes on uuid, service_name, event_time,last_name and personid.

Basically any report that causes a full table scan takes a long time (around an hour...

Lets start over?

Post is kind of confusing.

1- Clustered indexes have their leaf level inside the target...