The default isn't an expression run against the row. It's a value. Same for computed columns, these don't allow logical expressions.

A trigger is the best way to handle this.

The tools in SQL Server only regenerate the code that you've put in there. Codesmith, IIRC, allows you to generate new sprocs more easily.

You have to send that reorg operation to the log shipping secondary or you break log shipping.

You also will need this space next Sun, so I'm not sure if shrinking...

update table

set datecolfield = null

where datecolfield = '1900-01-01 00:00:00.000'

I played some Halo series with my son, but not much lately. We tried to get the kids into RockBand, which has a tiny game piece, but no luck.

Words with...

cfradenburg (8/1/2011)

---

However, since the backup system provide a lower level of care I don't know that it's a wise idea to kill services and force the backup system into place....

My apologies, the links have been fixed.

If you have 30 indexes on a table, you have potentially 31 writes when a change is made to the table. If one of the 30 is a clustered index,...

There's nothing to replace Word's review features anywhere. Need a PC for that, or a Mac/Fusions.

I am tempted to get a real keyboard for writing on the iPad, that or...

There are companies that don't want administration done from the server, so no client tools are installed.

SSMS ALWAYS connects remotely to SQL Server instances as a client. Even if you run it from the server, it is making a connection to the service running on that...

GilaMonster (7/29/2011)

---

I'd kill for full-blown MS word or Windows Live Writer on the iPad, that would eliminate a fair bit of need for the laptop, but it's still no way...

jcrawf02 (7/29/2011)

---

I do wonder though when we'll be able to view a HUD of some sort, whether built into contact lenses or projected via an attachment to my glasses, so...

This might help with moving resourcedb - http://www.mssqltips.com/tip.asp?tip=1544

Nevyn (7/29/2011)

---

Is telecommuting really that desirable? At my previous job, I probably could have done it fairly often. At my current one, not quite as much (as Im meant...