You just want to keep on concatenating that stuff on to @sql, then you can either print @sql (and execute it on your own), ro run it through sp_executeSQL.

Add this...

You may be running into parameter sniffing.

This is a pretty decent article explaining what it is and how to avoid it:

http://omnibuzz-sql.blogspot.com/2006/11/parameter-sniffing-stored-procedures.html

I think so, with some kind of wrinkle. As I recall, the wrinkle sounds something like "if you're building...

Require? No, but you can certainly stay on the same schedule.

If you mean do I need to back up the log files to free up the space inside...

Not exactly - It doesn't break the chain, but point-in-time restores are not available while in bullk-logged mode.

This is a decent summary of the differences:

http://technet.microsoft.com/en-us/library/ms189275.aspx

Dave (10/16/2008)

---

I have been trying tofind an answer to a question for ages now, buit still not managed to find an definite answer.

If I have two indexes, using the same...

The data rows of the underlying table are not sorted and stored in order based on their nonclustered keys.

I think this statement corroborates my earlier interpretation of how data will...

Marios Philippopoulos (10/16/2008)

---

I've always thought that ONLY the clustered index stores its key values in (logical) order, and that storage of the non-clustered index data just follows the order of...

PaulB (10/16/2008)

---

Okay... lets try to get to the bottom line on this stuff.

You should create a PK when you want to have RI enforced.

If you want to enforce uniqueness an...

chintan kotwal (10/16/2008)

---

Ok then I have another question. I created a table

create table employee

(id INT,

Name VARCHAR(50))

Then Created a Unique Clustered index on that table.

CREATE UNIQUE CLUSTERED INDEX CIX...

The non-clustered index stores the key values in order. The leaf part of the B-tree has the clustered key. So the pages would look like (AFTER the index...

Without using dynamic SQL, that's correct.

Jeff Moden (10/15/2008)

---

Sorry... the day's coffee is wearing off. 🙂 I didn't read all of your last...

You're correct. Since the rows are going to be added on a...

Marios Philippopoulos (10/16/2008)

---

Thank you both for your replies.

I'm not sure I follow though. How would the non-clustered indexes get fragmented? The table population is done all at once, in a...

Jeff Moden (10/15/2008)

---

Matt Miller (10/15/2008)

---

Jeff Moden (10/15/2008)

---

In that case, I'd use a FILL Factor of 100 for that tiny bit more speed on any SELECTS you may do on the...