David.Poole (9/21/2010)

---

I almost feel that SQL Server should have a NoSQL provision in its storage engine. Being able to define a database in zero recovery mode so the overhead...

Best bets are Gail, Jeff, or me. Anyone want to take us or the field?

Brent Ozar is in the area, and I know he'd like to see another one, so I'm sure there will be one. I'd like to get out there, and I...

No, the files are the same, the transactions are the same. The difference is only the SQL Server executable files.

I didn't get the package myself, but there should be some documentation in there. The SNAC is for clients, and perhaps there's an issue with clients that connect to a...

Eric Russell 13013 (9/21/2010)

---

I hope society never advances to the point where an understanding of relational set theory by the average person is required just to get by; most of...

I would bet there will be something in the Chicago area, or nearby, in the next year.

Paul White NZ (9/21/2010)

---

Look useful and interesting,...

Paul White NZ (9/21/2010)

---

...

The current SQL development model is to address a small number of main product features in each new major release. The downside to that is that...

Joe Johnson-482549 (9/21/2010)

---

Hi Steve,

On the comment you made about hoping an architect doesn't disclude something because it is new ... we do this all of the time due to...

mtillman-921105 (9/21/2010)

---

To what extent were relational DBMS created because drive space wasn't cheap and processing power was weak? Big, flat tables weren't helpful in either case years ago. ...

I never append. You are risking your databases in one file, and if something happens to any part of that file, you could be completely without backups. I always use...

I would agree with Geoff. The master/model/msdb databases shouldn't see a lot of activity, so they don't need to be separate. The tempdb will, so having a separate LUN for...

I think moving to simple mode is the same thing, and cleaner. It's different, and it involves the change of code, but I think that the ALTER does the same...

You did a good job, and posted sample code that I was thinking to post as well. Good job, Gail.