stephen99999 (8/2/2011)

---

I am trying for my 2nd time at NC State, and hope to have the chance to step into Analytics and maybe change the world a little (personal goal;...

No idea. You should contact the tool provider for an answer there.

I'm not sure how platespin works, but you might need to backup the service master keys and restore those on the copy.

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