Talk:Microsoft SQL Server

From Wikipedia, the free encyclopedia

Good article Microsoft SQL Server has been listed as one of the Engineering and technology good articles under the good article criteria. If you can improve it further, please do. If it no longer meets these criteria, you can delist it, or ask for a reassessment.
May 15, 2008 Good article nominee Listed
This article is within the scope of WikiProject Databases.
??? This article has not yet received a rating on the assessment scale.
High rated as high-importance on the assessment scale
This article is within the scope of Computing WikiProject, an attempt to build a comprehensive and detailed guide to computers and computing. If you would like to participate, you can edit the article attached to this page, or visit the project page, where you can join the project and/or contribute to the discussion.
??? This article has not yet received a rating on the quality scale.
??? This article has not yet received an rating on the importance scale.

Contents

[edit] MSSQL 2008 has been released

Since MSSQL 2008 release (RTM, available as a download) few weeks ago, MSSQL 2005 is not the most recent version anymore. Tag "under development" can be removed from MSSQL 2008 section as well --Zigzig (talkcontribs) 14:04, 19 December 2007 (UTC)

has it been already? last i heard the latest release was nov ctp with another one, with compression and other features, pending, prior to feb 2008 release. --soum talk 15:16, 19 December 2007 (UTC)
SQL 2008 RTM is not available to the general public as of yet. The latest release is CTP-5, with CTP-6 due in Feb.SqlPac (talk) 07:56, 28 December 2007 (UTC)


in this same section rtm should link to http://en.wikipedia.org/wiki/Software_release_life_cycle#RTM_or_RTW i had to look it up :) —Preceding unsigned comment added by 69.217.46.57 (talk) 01:41, 27 April 2008 (UTC)

The release date for the RTM is currently set for Sep. 2008. The Feb 2008 release was a CTP. The RTM is not available. That current version needs to be changed to reflect 2005 as the most recent RTM. 69.116.242.16 (talk) 22:49, 1 June 2008 (UTC)

[edit] criticism

No criticism section? Most articles have them. Surely someone must have some criticisms of this (otherwise wonderful) database.

Most article having something is not a rationale for adding something. An article deserving something should be the rationale. And, regarding criticism, the article is very much a work in progress. There is a lot to be desired here, a detailed description of features, architecture, and yes criticism if any. If you want to add it, go ahead, if you can properly, verifiably and neutrally add them. --soum talk 03:33, 21 June 2007 (UTC)

[edit] Fix the Version History

This is wrong:

1999 - SQL S, codenamed Yukon (version 9.0)

1999 is the SQL 2000 release (8.0), 2005 is the SQL 2005 release (version 9.0, codename Yukon)

69.116.249.76 23:17, 31 December 2006 (UTC)

[edit] Bugs in SQL Server

I'm not really sure, but I believe subscription (replication) and database mirroring are buggy in SP1. I've tried resolving it using the forums and followed troubleshooting procedures & step-by-step guides. I'm using SQL Enterprise Edition & Developer Edition, both at version 9.0.2047. Has anyone been able to get these to work with the version I'm using? Or perhaps using the Developer edition as the primary, and the Enterprise edition as the secondary just doesn't work? —Preceding unsigned comment added by K nitin r (talkcontribs)

This is not the place to troubleshoot programming issues. Try the microsoft.public.sqlserver.replication newsgroup ([1] or [2]). You can report bugs in SQL Server on the Microsoft Connect site. Razvan Socol 12:36, 7 August 2006 (UTC)

[edit] locking

This is good. I'm extremely curious to the experiment that can cause a lock to occur. Hmmm... —Preceding unsigned comment added by 65.24.255.219 (talk • contribs)

[edit] Why mySQL, PostgreSQL so unpopular?

1) In what technical ways is MS-SQL, Oracle, and Sybase better then PostgreSQL or mySQL?

2) When looking at sites like http://www.technewsworld.com/story/20968.html - the marketshare of Oracle and MS-SQL is quite significant. Appart from any technical advantages, why dont open alternatives get deployed more?

3) In what situations are any technical advantages of MS-SQL, Oracle or Sybase databases really crucial in a company?

Its just looking at the available products on the market, particularly opensource ones, many support mySQL, and some support postgreSQL. Including modules for most programming languages to control them. Both seem to be quite commercially ready, would like to hear some answers to the above questions. --Hackeron 20:38, 11 Sep 2004 (UTC)

Quite a few reasons. The open source databases aren't as scalable as MSSQL or Oracle. In the free databases support for clustering is less mature or nonexistent, for example. There are more professionals trained to use and manage Oracle and MSSQL. There's also a perception by management that "you get what you pay for," which is becoming less prevalent. In many cases open source databases are as good as the commercial ones, but for large installations they are usually not an option. MySQL still doesn't support stored procedures. Rhobite 20:18, Sep 12, 2004 (UTC)
I find it highly ironic that people state MySql is not very scalable while posting on one of the most massive Databases in existence.. powered by MySql.142.179.200.76 20:04, 21 September 2007 (UTC)

Some points of interest which may help to address question 3. The commercial offerings all address three major questions in (roughly) the order: Data Integrity, Developer Features, Performance. Broadly speaking other features come within these categories (clustering = performance, security = developer features and so on).

By Data Integrity, I'm talking about ACID compliance, failing to accept invalid data, backups, transaction logs. By Developer Features I'm talking about stored procedures, views, data dictionary commands, GUI tools, APIs and so on. Performance is, I hope, fairly self explanatory.

The open source databases tend to have excellent performance, but lacking in the first two points. They're getting there, but I really don't think that the reluctance of management to commit to date has been misplaced. For example, MySQL does not fully support transactions with standard SQL. It silently accepts invalid data as default values instead of raising errors. PostgreSQL on the other hand provides a coarser level of permissions on objects, less elegant partitioning of databases. And so on. There are a number of other open source databases but my (uneducated) impression is that they have similar deficiencies.

I hope that answers some of the questions raised; I'm a devoted user of PostgreSQL and hugely appreciative of MySQL, so please don't assume that I'm opposed to them on non-technical grounds; I try to keep current with the state of each and I'm really looking forward to being able to recommend them to large clients in the future. Currently my money's on PostgreSQL, but it's a very difficult call so I wouldn't be at all surprised to see MySQL leapfrog ahead.

I would be very interested to see some detailed discourse on the feature disparities between the various proprietary and open source databases, but I suspect this article is not the place for it! --Dcminter 10:59, 1 Oct 2004 (UTC)

PostgreSQL is a real PITA to use. MySQL is just bad news... the fact that they thought that Foreign Keys were a bad idea at one point in its development just screams incompetence. Both of those OSS DBs are nowhere near mature enough to really use in business applications. DoomBringer 14:48, 28 September 2005 (UTC)
I agree that they are not as mature as commercial products, but they are still "really used" in many business applications and for many large-scale websites. Rhobite 04:03, 8 November 2005 (UTC)

[edit] Sybase teamed with Microsoft to compete against itself?

Well, that's what it says:

"The code base for Microsoft SQL Server originated in Sybase SQL Server, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM, and Sybase.
Microsoft, Sybase and Ashton-Tate teamed up to create and market the first version named SQL Server 4.2..."

Can somebody make any sense out of this? conio.htalk 20:51, 22 December 2005 (UTC)

If you think back to when 4.2 was released, its back in the NT 3.0 days, Sybase did not have an offering for Windows hence the collaboration; there where market stipulations about not competing directly with Sybase; Microsoft version was (and still is) Windows only. Perhaps Sybase just didn't see Windows growing into the dominant operating system it is now, and certainly didn't the growth in MS SQL Server coming! —The preceding unsigned comment was added by 80.177.180.177 (talk • contribs) .

[edit] Excuse my boldness

I removed the section that gave a "market analysis", since Wikipedia is no place for such material. We could list the major competitors, but no "analysis" should be attached. I also removed the "Future development" section, since Wikipedia is not a crystal ball. When the development has happened and something actually exists, we can include it. Haakon 19:56, 10 May 2006 (UTC)

Future Development is not disqualified by "Wikipedia is not a crystal ball", because not editor is making any predictions here. It is a fully authentic (and referenced) statement made by developers doing the Future Development. So, it is not a prediction made by some obscure black magic (or crystal ball or whatever you feel like) but some real stuff. I am readding it (not sure about market analysis though). If you still feel it should be removed, let sort it out here first. --soUmyaSch 20:03, 10 May 2006 (UTC)
It is true that Microsoft has publically announced their plans, but plans are not facts from the future. I rewrote the section slightly to reflect this. Haakon 20:33, 10 May 2006 (UTC)

[edit] Features

Theres nothing in this article that deescribes the features and capabilites of SQL server. Its sorely missed. --soUmyaSch 13:22, 28 May 2006 (UTC)

[edit] relational database rewrite

I am trying to rewrite relational database and am soliciting opinions. I am particularly interested in bringing in the practical and popular definitions of the term to counter the current article's domination by the "theoretical" crowd. Ideogram 11:16, 11 June 2006 (UTC)

Go ahead, I will review it as you progress. However, I feel, its "theoretical" content should not be given the boot in lieu of practically relevant info. --soumসৌমোyasch 11:26, 11 June 2006 (UTC)
Oh, I hope to include their perspective, certainly. But the POV of Codd and Date that no current databases are relational is and should be presented as a minority view. Ideogram 11:31, 11 June 2006 (UTC)
I second you on that. --soumসৌমোyasch 11:36, 11 June 2006 (UTC)

[edit] sql-server-performance.com link

Bradmcgehee insists on having a link to his site, [3]. See his arguments at my talk page and at Soumyasch's. I think the site is very advertising heavy without adding much to the links we already have. I have reverted him based on this, and others have reverted as well, so I think there is consensus against this link. It seems it should be argued here, though, and I won't engage in any revert war. Thoughts? Haakon 17:24, 15 June 2006 (UTC)

www.sql-server-performance.com, which I am the webmaster of, was started in June 2000. It currently is the largest community on the Internet devoted to SQL Server performance tuning, receiving over 250,000 unique visitors a month. The website does have advertising to support it, but it also has over 1,000 pages of original content, totalling over 1,000,000 words of original content. The advertising pays for the dedicated server and bandwidth. The website also includes a very active user forum. In fact, if you post a question in the forum, you will get an answer in hours. If a link to my website does not fit the proper criteria for inclusion, then none of the links already in the article fit the criteria. A link to my webiste greatly adds to the value of the content on this page. SQL Server performance tuning is a very big topic, which is a topic not covered in the article, nor by the other websites currently linked by the article. Also, besides Haakon, only one other person removed my link, not "others" as described above. Brad M. McGehee, 6-15-2006 User:Bradmcgehee
There are a lot of sites with good SQL Server information. Wikipedia is not for you to advertise your web site. 131.30.121.23 18:12, 9 July 2007 (UTC)

Hm, if Wikipedia is not a link directory, have you ever searched for "Playmate"? You'll get a nice listing of a whole bunch of them, following the links you'll see the homepage of Playboy is almost always linked there. I believe Playboy.com is what I would call a merely commercial site which also doesn't add much to what Wikipedia should be about. But still it is listed here. Why?

SQL-Server-Performance.com surely has advertising. But that's absolutely okay, since you are free to ignore the ads. And the site and its content is free. You don't have to register somewhere to read the content. To cut a long story short, I don't get you point removing the link here. -- 2006-06-15 Frank Kalis —Preceding unsigned comment added by Frank Kalis (talk • contribs)

Note: user's first edit. My intent was to gather consensus from Wikipedia editors, not from sql-server-performance.com users [4]. Haakon 19:15, 15 June 2006 (UTC)
Wikipedia isn't intended to be a link directory. That's the defined policy. If you see such a thing elsewhere on Wikipedia, you don't hold that up as an example of what you feel you should be doing. Please help Wikipedia by contributing to the encyclopedia, instead of by advertising other web sites. Thanks. Warrens 19:18, 15 June 2006 (UTC)


----
You know, guys like you are a great example of why someone shouldn't pay too much attention to Wikipedia. Ever thought of being contraproductive? ;-)
2006-06-16 Frank Kalis
----

Anyone can be an editor in Wikipedia, whether they are users of SQL-Server-Performance.Com or not. Their opinion is as good as any other's opinion. In fact, it may be a better opinion as they are familiar with SQL Server and the website. --Brad M. McGehee, 6-15-2006 User:Bradmcgehee


Sqlserver-qa 20:51, 15 June 2006 (UTC)SQL-Server-Performance.com website is for a genuine reason help the SQL Server community and resolve the user problems by hosting numerous articles, topics and forums too. It is one of the best served website within the SQL Server community. The basic criteria for having an entry in WiKi is to keep informed about the SQL Server related communities.

Note: user's first edit. Haakon 20:59, 15 June 2006 (UTC)

From Wikipedia's External Links guidelines, links that are to be normally avoided those that promote a site. You are definitely using the article to promote the site. Also, sites with objectionable amounts of advertising are avoided. Your site also doesn't hold ground against this. Also blogs, social networking sites (such as MySpace) and forums should generally not be linked to. You yourself said you are hosting forums. And most importantly, you are to avoid a website that you own or maintain. And you've also said, the site contains over 1,000 pages of original content. Are you sure that does not violate Wikipedia's policy against Original Research. Do you have other verifiable NPOV notable sources backing up what you claim in the articles?

And if the site is as important as you claim to be, why does it need this article as a vector for promotion - it should be able to stand on its own!

One more thing: I can play this game all day with you, but I will put the back every day and every hour if I have to. Such attitude and you will have your editing privileges stripped off in no time. You do not own any article, you are merely an editor in a group of all wikipedians. Being pushy about your own version when there are many independent objections to your edits will only alienate editors against you. If you undo revertions back to your changes more than 3 times a day, you will be blocked from further editing. So please contribute harmoniously. If yu feel any information in the article is missing (note, not Links or Promotions) why not add it directly. Also, remember, that most of the readers of the articles are not DBAs, and have no interest in knowing how to do performance tuning. --soumসৌমোyasch 04:30, 16 June 2006 (UTC)

---

Hi , I am Dinesh Asanka contributing editor to the www.sql-server-performance.com. This is the only site that is devoted to sql server performance. This site is one of the few sites that give users answers in few minutes. Among the moderators there are microsoft MVPs. So I don't think it will require that much of analysis to say www.sql-server-performance.com link should exists there. —Preceding unsigned comment added by 220.247.234.93 (talk • contribs)

Quick answers is not a criterion of Wikipedia policies --soumসৌমোyasch 06:33, 16 June 2006 (UTC)

Life is too short for dealing with self-appointed moralists, such as those which hang out at Wikipedia. The world has way too many of these. Look at Hitler, Sadam Hussein, and more of the same ilk. Who needs Wikipedia? Guys and girls, get a life! —Preceding unsigned comment added by Bradmcgehee (talkcontribs)

---

As a compromise, perhaps this link could be added: http://www.microsoft.com/sql/community/relcommunities.mspx

Communities are generally user responses. As such they fail Wikipedia's policy of original research. Hence they cant be included here, even if its operated by the company producing the software. --soumসৌমোyasch 17:02, 16 June 2006 (UTC)
OR applies to article content, not to sites linked to on articles. Though there may be other grounds for removing this link, OR is not one of them.Cadr 17:39, 16 June 2006 (UTC)
Sorry, I was thinking something else while making that comment. My apologies. But still EL guidelines against blogs and forums go against this link. --soumসৌমোyasch 19:10, 16 June 2006 (UTC)
This is an excellent idea. That way you get equal coverage of all communities, without having to repeat the links in the article here. —Preceding unsigned comment added by Sql mvp (talkcontribs)

[edit] Biztalk Server 2006 and SQL Server 2005

They were not released alongside. —Preceding unsigned comment added by StefanPapp (talk • contribs)

[edit] Page organization

This article feels awkward with a note about the slammer virus in the middle. Could it be organized differently to include a section on threats to MS SQL 2000?

76.187.219.94 15:25, 12 November 2006 (UTC)

[edit] Compact and Embedded editions

... which come with Visual Studio Orcas and Windows SharePoint Services V3 are not described at all. --82.179.218.10 16:11, 21 February 2007 (UTC)

[edit] Multiversion concurrency control

I know this is truth and usefull, but I have no time to find references. Perhaps some other user could do that...

Prior to version 2005, if a user changes a row and does not commit, other users of read commited (or higher level) transactions are locked while reading that row. This behavior was different from Oracle database, which always used Multiversion concurrency control, on which instead of locking, the last commited version of row is returned to other users, which can continue work. This caused many costumers to experience problems while porting from Oracle database, mostly because of bad handling of locks. In version 2005, Multiversion concurrency control was added to SQL Server, but it still uses the more traditional Two-phase locking approach by default. It must be noticed that OLTP applications usually perform worst with Multiversion concurrency control when compared to Two-phase locking. —The preceding unsigned comment was added by 200.180.36.130 (talk) 13:29, 30 March 2007 (UTC).

[edit] Slammer for President!

Voting system's worm-infected SQL server lost 18,000 votes for Jennings in the scandalous ballot vs. Buchanan, case heads to SCOTUS now. Article is here: http://computerworld.com/action/article.do?command=printArticleBasic&articleId=9019560 —Preceding unsigned comment added by 82.131.210.162 (talkcontribs)

Sounds like a good reference for the SQL slammer (computer worm) article. -- Mikeblas 12:44, 29 May 2007 (UTC)

[edit] Survey

WP:Good article usage is a survey of the language and style of Wikipedia editors in articles being reviewed for Good article nomination. It will help make the experience of writing Good Articles as non-threatening and satisfying as possible if all the participating editors would take a moment to answer a few questions for us, in this section please. The survey will end on April 30.

  • Would you like any additional feedback on the writing style in this article?


  • If you write a lot outside of Wikipedia, what kind of writing do you do?


  • Is your writing style influenced by any particular WikiProject or other group on Wikipedia?


At any point during this review, let us know if we recommend any edits, including markup, punctuation and language, that you feel don't fit with your writing style. Thanks for your time. - Dan Dank55 (talk)(mistakes) 04:06, 21 April 2008 (UTC)

See Talk:Microsoft Visual Studio. --soum talk 04:49, 21 April 2008 (UTC)

[edit] External link for SQL Server PDF FAQ

One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion and suggestion. Download SQL Server FAQ Sheet in PDF format http://www.pinaldave.com/blogfolder/faqx.pdf I think this should be allowed on the page of SQL Server http://en.wikipedia.org/wiki/Microsoft_SQL_Server Pinaldave (talk) 07:39, 29 April 2008 (UTC)Pinal

Now coming back to the link. Please read WP:EL, thats the policy that defines what can be allowed as a valid external link. The FAQ you want to link is just a tabulation of data types and functions available for use in T-SQL queries. More or less the information is already covered in the DotNet4All Factsheet. There is no need for duplication. This is not an endorsement of one site over other, this is just removal of redundancy. Plus, Wikipedia articles are supposed to only give an overview of the topic, not be any in-depth reference; nor a programmer's reference manual either. So even if the DotNet4All factsheet does not cover all of the data types or functions, it provides a lot more info than the FAQ, which makes it a more suitable External link. --soum talk 10:15, 29 April 2008 (UTC)

[edit] illustration

I've removed the SQL architecture illustration as it's completely original research and unreferenced. It's also got many errors. -- Mikeblas (talk) 01:49, 1 May 2008 (UTC)

Its not unreferenced. Its based on ref #1. If you see any error, WP:SOFIXIT. Its a plain SVG file. --soum talk 08:04, 1 May 2008 (UTC)
The errors are numerous; my fix is to remove it. It remains unreferenced as there is no citation in this article or in the article associated with the image. Reference #1 is a book of more than 450 pages; references are intended to be specific. (That's a problem for this whole article, so I've tagged it with {{pagenumbers}}.) I've again removed this image from the article so that readers are not misled or confused. -- Mikeblas (talk) 15:45, 1 June 2008 (UTC)

[edit] Passing GA

Ysaias Portes I passed the article, as it had no problems I could see. Please review others at WP:GAN. I also suggest a FA nomination.Bettering the Wiki 23:41, 15 May 2008 (UTC)

One of the substantial problems in this article is that it doesn't set the context for the subject. "Microsoft SQL Server" refers both to the server itself--a program that stores and retrieves data while answering queries from clients in the SQL lanauge; as well as a package that includes several other servers, tools, and utilities. The recently removed "architecture of SQL Server" illustration referred to the DBMS server itself, as does some of the text; other parts of the text refer to the whole suite. Is an article with such a fundamental issue still considered "good", or should this approval be re-evaluated? -- Mikeblas (talk) 15:28, 3 June 2008 (UTC)

[edit] 2008 logo?

Is it appropriate to use the 2008 logo? This version of the product hasn't yet shipped. -- Mikeblas (talk) 13:51, 5 June 2008 (UTC)

With no rationale provided for using the unreleased logo, I've reverted the article to reference the current logo. -- Mikeblas (talk) 02:46, 8 June 2008 (UTC)