SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Don't Overdo It, SQL Server


Don't Overdo It, SQL Server

Author
Message
Haidong Ji
Haidong Ji
Old Hand
Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)

Group: General Forum Members
Points: 387 Visits: 60
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/hji/dontoverdoitsqlserver.asp



dma333
dma333
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 27

Nice article and I agree that MS should KISS. That's what I find to be so great about it. It is simple where you need it to be (like SQL tuning...it just works and typically doesn't require hints like the incredibly stupid, bug-laden Oracle optimizer), and yet offers enough tuning capability to run with the big dogs...and they're opening that up a bit more, which it a good thing.

To clarify one of your points, in Oracle, a schema is not like a database, it is simply a privileged user that owns objects...whether they be tables, indexes, procedures, etc. There is no definition of storage attached to a schema owner in Oracle, you define that on an object by object basis (unless you take the default tablespace of the schema owner).





Stephen Hirsch
Stephen Hirsch
Mr or Mrs. 500
Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)

Group: General Forum Members
Points: 512 Visits: 161

"In my understanding, a schema in Oracle is like a database in SQL Server."

I think a database in SQL Server would be more like a tablespace in Oracle. FWIW.


Kevin Martin
Kevin Martin
SSC-Addicted
SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)SSC-Addicted (493 reputation)

Group: General Forum Members
Points: 493 Visits: 199
Nice article, but the editorial at the bottom was a bit out of place.
nvb
nvb
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 1

Nice article.Can you shed some light on how administrative tasks are done in sqlserver 2005 as compared to oracle.

They say costwise oracle is more costly than SQLserver , is that true?


dma333
dma333
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 27

Let me put it this way. I was a DBA on both for close to 6 years in a large investment company, and I can tell you this. I was able to manage about 15 SQL Server databases but only 4 Oracle, and the Oracle ones took 75% of my time.

I would only put warehouses on Oracle. SQL has to prove they can do what Oracle's been doing for years. The direction MS is going with partitioning, etc, is the right one, but they have to prove they can function on a 64 bit platform before I'd consider putting a TB warehouse on SQL Server.





Haidong Ji
Haidong Ji
Old Hand
Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)Old Hand (387 reputation)

Group: General Forum Members
Points: 387 Visits: 60
Thanks for the comments, folks.

To dma333: regarding what a schema is, you are right. As this article is geared more toward Sql Server DBAs, I thought using the database analogy is easier for the target audience to understand. I hear you about manageability issues with Oracle. I personally don't have much DW experience to add to your comment, but like you said, table and index partition and 64-bit will be very helpful in that regard.

To Stephen: Actually tablespace is more like a filegroup in Sql Server. Like filegroup, a tablespace can have several data files.

To Kevin: Yup, the editorial is a bit out of place here. This article grew out of a blog entry I had. It is appropriate to have a personal opinion at my own blog site, it may not be very appropriate for it to appear in a formal article.

To nvb: regarding how common tasks are done on both platforms, that is really a loaded question. However, I blog regularly on my blog at http://www.HaidongJi.com. And that is a subject that I am personally interested in. I plan to blog more on it. In addition to Oracle and Sql Server, I will cover some MySql as well.
As to cost and TCO, my personal opinion is that Sql Server is definitely cheaper. With multi-core servers becoming prevalent, that will be even more obvious. Sql Server pricing is based on number of sockets, regardless of how many cores you put in. Oracle, on the other hand, charge customers based on the number of cores the machine has. Of course, pricing changes all the time and big customers rarely pay the sticker price. It's kind of like Boeing and Airbus planes. I don't think anybody is paying the list prices.



glenn brown
glenn brown
SSC Journeyman
SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)SSC Journeyman (78 reputation)

Group: General Forum Members
Points: 78 Visits: 493

i agree it was out of place but sometims its nice to highlight the greater scope of a company (and their philosophies). Bills' philanthropy would edge me towards his product(s) for that reason alone (plus I think SQL is great and getting better with age.). Keep it up guys!


Xiaobo Gu
Xiaobo Gu
SSC Veteran
SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)SSC Veteran (202 reputation)

Group: General Forum Members
Points: 202 Visits: 31
Oracle schema and SQL Server 2005 schema are the same. But Oracle allows only one database per instance.
dma333
dma333
SSC Veteran
SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)SSC Veteran (264 reputation)

Group: General Forum Members
Points: 264 Visits: 27

Yes and no. In SQL 2005, a user can own multiple schemata. In Oracle, a user can only own one schema.

For example, in SQL 2005, user "x" can own schema "y" and schema "z." So it can own two tables called "mytable" which could be referenced as follows: select * from y.mytable; select * from z.mytable. As BOL states "Beginning in SQL Server 2005, users and schemas are separate, and schemas serve as containers of objects."

So really a schema is just another object owned by a user, which serves as a container for other objects. In Oracle, the user and schema owner are one in the same.





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search