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...

A little off topic maybe, but below is a possible technique to hash demographic or personally identifying data for a QA or Development environment. The distribution of the data remains...

The [Services].[ID] column is part of your PK, and you havn't made it clear why you need to insert the table while leaving that column NULL. From what I see,...

When I am developing a stored procedure for reporting purposes, something that is driven by one or more sets of parameters, the parameters are typically contained in a table. I'll...

Jeff Moden (8/10/2010)

---

...

For all of you good folks using XML to split things... I suppose that XML either does something special for you or that your consider its performance...

I'm surprised by some of the strong emotions expressed here regarding the issue of doughnuts and bagles. You sound like a Dilbert cartoon and are reenforcing negative stereotypes about those...

thisisfutile (6/30/2010)

---

Typically our boss brings in donuts on Friday. From time-to-time he doesn't bring any. According to some of the attitudes on this forum (but not exclusive to...

I once had a consulting gig at a .com company that managed to (barely) survive the dotcom bust but employed a skeleton crew of about 40 employees, which was a...