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

Matt Miller (#4) (7/29/2011)

---

Flipping the question around: other than seeing your...

Ninja's_RGR'us (7/29/2011)

---

Do you guys(als) know a way to remove the prints from the backup / restore commands?

This is what I'd like to be gone from the output :

100 percent...

I think there's value...