I do have a minor point about Jeff's post. It didn't work for me in SQL 2000, but did work in 2005 and 2008. With SQL 2000 I...

Jeff Moden (11/14/2010)

---

Michael... please double check me but I believe a documentation change is necessary for that code. Here's...

WayneS (11/12/2010)

---

Michael Valentine Jones (11/12/2010)

---

Note that any Monday date, not just 1753-01-01, can be used as long as it is earlier than OriginalDate. I chose 1753-01-01 because it is...

10 oz of a 10% acid solution has 1 oz of acid in it ( 10 *.10 = 1 )

10 oz of a 3% acid solution has .3 oz of...

You don't need to do update stats if you are re-indexing a table, you only need to do that if you re-organize the indexes. When you re-index the table,...

If you haven't already, you should consider a backup compression tool, like LiteSpeed, to reduce the size and run time of the log backups and regular backup.

If you aren't doing...

Craig Farrell (11/12/2010)

---

Jeff Moden (11/11/2010)

---

Perhaps the following code will make it easier to explain what was going through my head when I wrote the forumula. A couple of big...

It’s just a matter of time until it is possible. Faster processors, better sensors, more sophisticated algorithms are all being worked on now, and the financial incentive of a...

Just a little nitpicking on this; Jeff's code does not work on dates before 1899-12-25.

I posted a function on the link below that works over the entire range of possible...

.

A big advantage of cars that drive themselves would be that people who are currently unable to drive would be able to use a car: physically or mentally handicapped, blind,...

There is a form of transportation that will drive for you.

When my father was young, he would go into town on weekends and sometimes get very drunk. He would...

SQL Server is a database engine not an application development tool, and SSMS is not meant to be a tool for application user access to data.

That would be easier to do if you posted the question.

Either way of checking for a non-empty string works. s.column > '' works because any non-empty string will be greater than ''