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.

Not surprising. Defaults can be a touch confusing and I could see why this might be an issue.

Gail is correct, the column NULL setting doesnt' change defaults.

If you don't reference the column in your insert statement, the default should apply. For example:

CREATE TABLE [dbo].[MyFirstTable](

[MyID] [int] NULL,

[MyChar] [varchar](50)...

Perhaps you could explain what you are trying to do or why you want this? We might be able to help, or let you know if you might be viewing...

Good to hear it. Alex wrote a great book, and you can grab a copy from our site (books to the left).

I wanted to go, but with SQLSaturday #52 next...

Glad you enjoyed it. Which one did you attend?

Isn't there a cleanup job on the secondary? sorry, don't have a LS test system here setup. Could you disable that?

I've given up on fighting for licenses for ERD tools. And I've given up trying to convince people like Embarcadero that selling it for $500 would more than make up...

BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote connect items.

http://www.sqlmag.com/blogs/puzzled-by-t-sql/tabid/1023/entryid/13085/Window-Functions-OVER-Clause-Help-Make-a-Difference.aspx

I have to admit that I'm not sure...