Joy Smith San (4/5/2012)

---

Thanks to all. More clear now.

If you look at it in the regard that a heap is index type of 0, then you could make the argument...

GilaMonster (4/4/2012)

---

Why not? What about change tracking? SQLAudit?

We had this...

Evil Kraig F (4/4/2012)

---

GSquared (4/4/2012)

---

Evil Kraig F (4/4/2012)

---

Okay, I'm confused by the bolding of my name randomly in this post:

http://www.sqlservercentral.com/Forums/FindPost1278324.aspx

Is that supposed to mean something or am I just over-sensitive...

Evil Kraig F (4/4/2012)

---

Okay, I'm confused by the bolding of my name randomly in this post:

http://www.sqlservercentral.com/Forums/FindPost1278324.aspx

Is that supposed to mean something or am I just over-sensitive due to frustration with...

MERGE tableA USING

(SELECT ITEM, DESCRIPTION FROM tableB) as src

on tableA.somecolumn = src.somecolumn

WHEN NOT MATCHED BY TARGET THEN

INSERT (ITEM, [DESCRIPTION])

SELECT ITEM, DESCRIPTION FROM tableB

First, the source either needs to...

Physical fragmentation is about files spread all over the disk. Logical fragmentation is about indexes that are out of their natural sequence and possibly spread all over the data...

I see three different schedule IDs in there. Do you have three jobs running, potentially at the same time?

I get a lot...

amy26 (4/3/2012)

---

So, update.... I guess I overracted and I'm not as dumb as I think I did... the recruiter just called me and said that they LOVED me. And...

Welcome back!

capn.hector (4/3/2012)

---

GSquared (4/3/2012)

---

I'm...

This sounds like a classic analysis cube situation.

Correct me if this is wrong: You need to know things like, if item X is purchased, how frequently does item Y also...

We all recognize the concept of "opportunity...

TravisDBA (4/3/2012)

---

Many companies are legally required to keep it around. You can archive it, and that helps your daily online system a bit, but in many companies like mine for...

I'm pretty sure...