For some common and uncommon date formats:

http://www.sql-server-helper.com/tips/date-formats.aspx

That site also has code for finding first/last day of month, week, and so on.

mike.styers (4/5/2010)

---

Slippery Slope I think.

Once you break out what each IT service costs, all it takes is a member of upper mgmt to say, "Look what were paying for <whatever...

This cost-based accounting (or charge backs) have their role in some limited circumstances, but most eventually fail under their own weight. The primary reason in my experience has been the...

Now wait a second....never mind!

David Korb (3/23/2010)

---

Didn't we...

Thanks. Since I needed one for update cascade tree, I modified yours. Now I can use either one depending on the situation. --SJ

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id...

Steve Jones - Editor (3/16/2010)

---

I've actually had to tell a VP to "go away" when I was managing. It was bad enough that I would go in to check on...

Reminds me of the line, make haste and repent at leisure.

Nulls in join relationships are the problem, otherwise any sensible adaptations would do. If it's just tackling name problems, such as first, last, mi, etc., use something that does not...

The iODBC, TDS, and JDBC mailing lists must have plenty of feedback if they are really interested in finding out cross platform issues.

Instead of asking for platform questions, this survey goes into too much business, revenue, and other unrelated issues. I wonder what the value of this survey.

I always used ThinkPads from IBM. But once I tried MacBook Pro, I never looked back since. I have 2 laptops and 2 server setups. All are Mac hardware running...

Certainly the current practice is mixed at best or else no DBMS would allow null values as valid entries in a field. That's what the relational theory purists wants. Rejection...

TCO is much more than per cpu or per socket price. Feature-based pricing too is arbitrary and even large installations don't need all the features all the time. Perhaps the...

GSquared (12/21/2009)

---

sjsubscribe (12/21/2009)

---

Encryption in general should be a default install at the OS level and apply to all files, not just to database files or express editions. Files like formatted...