No, something about statistics, and something else. Just having one of those "blonde" moments (or in my case, old-timer's moments).

PORK CHOPS!!!!! (lol) :w00t:

Couldn't resist (well, I could have, but didn't want too!)

😎

I also think that the car (generic here) is also a symbol of freedom. You can go where you want when you want. I did a very short...

Clive Strong (7/9/2008)

---

Lynn Pettis (7/9/2008)

---

Clive Strong (7/9/2008)

---

WFH...Hmmmm the Xbox360 is there - bad idea.... 😛

But yes, the price of petrol is a killer...As I catch the train, I rarely use...

Clive Strong (7/9/2008)

---

WFH...Hmmmm the Xbox360 is there - bad idea.... 😛

But yes, the price of petrol is a killer...As I catch the train, I rarely use the car these days,...

I've actually been told by my manager that I come across as arrogant. I don't mean to be, but there are certain things that I do feel strongly about...

Mkumari (7/8/2008)

---

The best i would do is select the rows that are to be keptin a new table and rename the old one to someting and rename the new one...

john.leo (7/8/2008)

---

I'm still not clear why SQL Server doesn't auto shrink the transaction log when a full backup is done in the full recovery model. No transaction logs are needed...

Double posted.

See this link: http://www.sqlservercentral.com/Forums/FindPost530278.aspx

😎

Try this:

alter table clients

Add SceneFlag [char](1) NOT NULL DEFAULT 'Y'

😎

If you post your current DELETE code, I am sure that there are individuals out here who help you modify it to delete small batches and thereby control the size...

I'd have to agree with Steve. I actually enjoyed every IT position I have had to date. Things got really bad at my last employer during that last...

I have used sql_variant in a database I was using for data analysis of data stored in a database. The only thing I couldn't store was blob data, or...

blandry (7/8/2008)

---

...As for the explanation of Inner Joins themselves, the article is very basic and though for some that might be helpful, it was not very "real world" and did...

Between Turkey Week 1989 (Thanksgiving Week in the US) to August 1993, I drove 90 miles one way to work 5 days a week. Left the house at 6:00...