Jeff Moden (6/11/2008)

---

Matt Miller (6/11/2008)

---

Jeff Moden (6/11/2008)

---

Heh... ok, I gotta ask... has anyone...

Also - since you're trying to put a single quote within the SQL statement, you need to double up on the single quotes, as in:

exec sp_MSforeachtable

@command1 = 'DELETE FROM ?...

There are a lot of very good comments already, so I'm not going to delve very deeply into custom partitioning. Instead of that - I'd offer you another thought,...

Jeff Moden (6/11/2008)

---

Heh... ok, I gotta ask... has anyone actually ever done a...

Dave (6/11/2008)

---

Is it just me, or is there really a requirement that all corporate standards have to have at least one stupid element? ...

I'm not sure why you'd need to try to thread this. Assuming you're doing this with a Bulk Insert process, BCP or a CLR SQLBulkCopy object, 100K rows should...

considering you're in SQL 2005 - you could look into ROW_NUMBER() to do that for you. That being said - it generates things based on a specific order, so...

Mike Sigsworth (6/11/2008)

---

I don't frequent these forums much, mostly because I don't have much to offer in the way of answers. I don't do a ton of SQL.

I do however...

Glad it helped!

And I've been bitten many times by the XML thing (the site trying to protect itself from injection/little nasties, etc...), so I thought I'd pass that...

Well - if direction is what you're looking for - break the problem into two. First - determine the last day of the month. Once you have the...

Mike - you XML got "whacked" - you may need to replace the brackets with their HTML encoding < and > for it to show.

that being said - I don't...

Jeff Moden (6/11/2008)

---

Hey Matt... if you see this and remember what the URL is for all that testing we did, would you mind posting it here? I've lost track...

nenad.prekupec (6/11/2008)

---

You ridicule the performance tests that people do that show CLR performance is slow and you offer up that very poorly written performance test that uses a While loop...

It's apparently smart enough to handle manipulations of elements already in the group by. I can't say I have a formal explanation, but if it detects the two datepart...

Without a clustered index - you can't directly defragment that table (which by not having a clustered index is called a heap). Your only option would be to do...