venoym (8/16/2012)

---

GSquared (8/14/2012)

---

You're not disagreeing with me. You're disagreeing with the original article we're discussing. All I did was quote/reference that. Please note the sentence I emphasized...

You can shrink the size of the batches being deleted as well.

SQL_ME_RICH (8/16/2012)

---

Also - is doing this in batches instead of all at once not the best approach? The environment I am supporting is not a very robust one, and...

SQL_ME_RICH (8/16/2012)

---

Also - is doing this in batches instead of all at once not the best approach? The environment I am supporting is not a very robust one, and...

Lowell (8/16/2012)

---

that's EXACTLY why you need to...

Here is one for the do not hire list.

Or it could be the needs much training list.

Because Isabelle can't commit the transactions for...

Also, you could probably get away with a nonclustered index.

Lynn Pettis (8/16/2012)

---

SQL_ME_RICH (8/16/2012)

---

Lynn - Would I need to modify the WHERE clause in the sub-query if I wanted to do this in batches? So it's not trying to...

SQL_ME_RICH (8/16/2012)

---

Lynn - Would I need to modify the WHERE clause in the sub-query if I wanted to do this in batches? So it's not trying to eat the...

You sure?

Steve Jones - SSC Editor (8/16/2012)

---

Mike Austin-398977 (8/15/2012)

---

By your reasoning, all of us should be required to take a course in transmission repair before we're allowed to drive a car....

ChrisM@Work (8/16/2012)

---

Hi folks, this evening I’m collecting Symba from here: http://www.tvaw.org.uk/Adoption.htm. We’ve met already, he’s awesome.

Not sure of the name though. Symba is a bit silly, it’s a misspelling of...

Try this:

DECLARE @Codes TABLE (Code VARCHAR(100))

INSERT INTO @Codes VALUES

('ABCD000000001'),

('ABCD000000002'),

('ABCD000000003'),

('ABCDT000000001'),

('ABCD00000000T1'),

('ABCD00000T0001')

SELECT

Code

FROM

@Codes

WHERE

RIGHT(Code,(LEN(Code)-4)) NOT LIKE '%[^0-9]%'

ORDER BY

Code DESC;

And for more information, read this article: http://www.sqlservercentral.com/articles/IsNumeric/71512/.

Edit: This also works:

DECLARE @Codes TABLE (Code VARCHAR(100))

INSERT...

sturner (8/16/2012)

---

Lynn Pettis (8/16/2012)

---

I have to disagree with you. First, C & C++ programmers don't know things from the get go, they had to learn about the penalties for...