That's very open ended. I think you'd also be looking at setting up storage differently for logs/data/tempdb. Without knowing more, you might setup Resource Governor for different groups/classes of users,...

Interesting, kind-a. The second video didn't seem all that amazing to me. Either I don't understand, or I'm not enough of a science geek to get...

GilaMonster (12/21/2011)

---

Steve Jones - SSC Editor (12/20/2011)

---

However, licensing changes are big. I would highly consider purchasing a SQL 2008 R2 license, whether you upgrade or not now, and then use...

Space Adventures - from $110k (http://www.spaceadventures.com/index.cfm?fuseaction=suborbital.welcome)

Virgin Galactic - $200k...

Congrats, Joe, and hope you get to space in a few years.

SQL 2012 is said to be first half of 2012. That's likely to be solid, but I don't know an exact date. I expect that it will be fairly solid...

OK, I don't see NULLS in your sample, and I'm not sure you've clearly stated how you do the updates.

First, you can't manage these updates without some PK or unique...

Or change the schema owner: http://blog.sqlauthority.com/2008/04/05/sql-server-2005-transferring-ownership-of-a-schema-to-a-user/

You'll have to show some code and explain more about the situation. A full backup doesn't add to the transaction log and cause it to grow. Something else is happening.

It's not clear what you're asking.

Also, is this the TDS data stream or something else?

GilaMonster (12/20/2011)

---

It's an artitorial (similar to an artichoke, but not...

Elliott Whitlow (12/20/2011)

---

If you want to read about real world applications of social engineering, read Ghost in the Wires by Kevin Mitnick. This guy would be considered the SUPREME...

BTW, all four finalists, please PM me your addresses.

If you haven't tried it, google "let it snow" and check out the Easter egg

Never used the assignment operator. Convention seems to be

SELECT col_A + col_B AS combined

FROM Table

or

SELECT col_A + col_B 'combined'

FROM Table

Not sure it matters, but...