If one is distributing something like a shareware application, where there are potentially thousands of installs with a local instance of the database and you can't field even a small...

kennethje (9/8/2010)

---

thought this was a joke to be honest...

but I've read the articles and must agree that the 2008 R2 story is unfortunate at least.

however...

ever tried to install Oracle?

or worse

create...

This has to do with peer reviews. As IT developers, or any other engineering field in general, we can't judge our own sanity. Also, neither can the client or end...

miki_home (9/2/2010)

---

Oh I feel your pain. We have a free-form "Occupation" field on one of our main Sales applications, so I've just spent weeks building a lookup table to make...

LIYA (9/1/2010)

---

Hi Peter,

At present the testing table have 1628430 records. its' only a 5 month data. but in production it will be 5 time higher. It's a access control...

david_wendelken (8/31/2010)

Yep. You can also end up in jail after asking the officer "Is this a joke?" after he informs you your driver's license was suspended almost 50 years...

anudata (8/31/2010)

---

Thanks for your post. i am facing a similar issue. i have a table which is having the following fields and samle data

empid Transacttiondate ...

alen teplitsky (8/30/2010)

---

i've seen this no NULL's allowed OCD thing being taken to extremes

say you sign up a customer today and promise some service that will be done in the...

Whatever SQL inserts this table [tbl_Prepped_Vehicle_ver01_20100823], that's what you need to be concerned about.

The SQL SELECT statement you provided is actually quite simple, and it just...

Data integrity and constraint begins with choosing the appropriate data type. Obviously (to most of us) integers should be contained in an Integer data type and monetary values in a...

In many cases, coworkers simply don't see or fully understand the scope of another's job. Some people are talented, but don't like to "toot their own horn", or maybe they...

When choosing between ranking the item changes on...

charles.gildawie (8/20/2010)

---

A precomputed column for the sequence can lead to problems when someone modifies the data. Say a date changes then you'd need to resequence all the rows at the...

The article does present a good educational example on the use of CTEs and the RANK function. However, I don't think ranking is the most practical and efficient solution to...