And for the reason one should test, test, and test again in your specific environment. What works best in one environment may not work in another.

timothyawiseman (9/15/2009)

---

Great article, Lynn.

One area that you mentioned, but that I think can be elaborated on, is the number of log backups this can generate. If the space is...

Jonathan (9/15/2009)

---

Does this mean you've found a method that's faster than...

Matt Whitfield (9/15/2009)

---

He did say there...

robblackin (9/15/2009)

---

I just had to deal with this. However, I need to have an hourly sliding window where I delete records older than 3 hours for working with .net viewstate.

I...

How about something like this?

create function dbo.IntToBinary (

@IntVal int

)

returns table

return(

SELECT

cast((select '' + cast(case when @IntVal & POWER(2,v.number) = 0 then '0' else...

Ric Sierra (9/15/2009)

---

Lynn Pettis (9/15/2009)

---

Ric Sierra (9/15/2009)

---

Just... keep simple!

If you need to delete a large number of rows and the scenario don't need to keep the database log.

In this case...

Ric Sierra (9/15/2009)

---

Just... keep simple!

If you need to delete a large number of rows and the scenario don't need to keep the database log.

In this case I want to delete...

SQLBOT (9/15/2009)

---

I'm new to using the tally table, and I'm sitting here dumbfounded trying to come up with a way (using a tally table) to convert integers to their binary...

Tao Klerks (9/15/2009)

---

Hi Lynn,

Good article concept, this is a problem that I've had to deal with many times, and I suspect most DBAs do at one point or another.

A couple...

Matt Whitfield (9/15/2009)

---

Nice one Lynn 🙂

I've found that for deleting a sub-section of data from a much larger table (for example - can we delete history from transactions table that...

I have one last question, is one row of data in each table really representative of the problem we are trying to help you...

Then you have the OP that refuses to read the suggested article and won't post data in a readily usable format. First as a text file, then as an...

Nope, still requires more work on our part. Have you read the article you were...

It would help if you provided the DDL for the view (and the underlying tables), sample data for the underlying tables, and your expected results based on the sample data.