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.

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