Nah,...

Alvin Ramard (3/15/2010)

---

You know ..... If the right "outsider" read the Thread, some of us might end up with free room and board for the rest of our lives, wall...

Lynn only needs 4 more posts for 10,000 posts (not overall pts).

CountDown on?

I'm fine with going back to Friday evening.

Tempdb will grow due to temp table usage, large sort...

You're welcome.

Lynn Pettis (3/15/2010)

---

SQL Server 2008

declare @MyDate1 datetime,

@MyDate2 datetime2;

set @MyDate1 = getdate();

set @MyDate2 = @MyDate1;

select @MyDate1 - 10; -- Works

select...

GSquared (3/15/2010)

---

Alvin Ramard (3/15/2010)

---

CirquedeSQLeil (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Yes, in SQL Server 2008 it is missing the data type. ...

Alvin Ramard (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Alvin Ramard (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Alvin Ramard (3/15/2010)

---

CirquedeSQLeil (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Yes, in SQL Server 2008...

John Paul-702936 (3/15/2010)

---

Hi

What Lowell was telling is extract that matches my requirement

I believe in an ACTIVE/PASSIVE 2 server setup, SERVER A and SERVER B might be...

Alvin Ramard (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Alvin Ramard (3/15/2010)

---

CirquedeSQLeil (3/15/2010)

---

Lynn Pettis (3/15/2010)

---

Yes, in SQL Server 2008 it is missing the...

This is actually a common misconception. As John said, you will need to create an index manually for each FK.

Also of worth, I covered this topic with a script...

Lynn Pettis (3/15/2010)

---

Les Cardwell (3/15/2010)

---

In spite of the criticism, it was still a simple example of minimal denormalization to achieve an end result rather than a full-on explosion of wide...

Absolutely. ...

Agreed.