Back to classic SQL Server 2005

Original article reproduced please specify the source: @ http://amwicfai.cnblogs.com,

SQL Server is the longest database I've used, and it's been 10 years. In the 90 's, Microsoft developed in all areas of software development, forming the operating system, Office software, Enterprise development, game production, browser in all areas of the entire monopoly. That was the golden age of Microsoft's development, until today, it still enjoys the dividend of the year.

In SQL Server 2000 that era, by its powerful, easy to use, "people free" and other characteristics of the rapid popularity, become the ideal choice for enterprise development. Early UF, housekeeper's ERP also used this as a database. At that time, web development is not as popular as it is now, mainly to do some Web sites, and Enterprise desktop management software is the market we are scrambling for. SQL server and Visual Studio software developed under the Windows platform, then become standard, a large number of programmers around the clock to study the Kit Kat, the fun. There are also some sources between SQL Server and Sybase, and students who are interested in self-examination.

Under the impetus of Moore's law, the hardware develops rapidly, the software complexity increases, the potential of SQL Server 2000 has been squeezed dry, the market urgently needs the higher performance, the more perfect function database. The database is Microsoft's cash cow, of course it is not allowed. After 5 years of development, the classic SQL Server 2005 has been launched. 5 years to release a version, and VS2008, 2010,2012,2013 than, weak explosion ah. SQL Server 2005 completely overturns the concept of "database is where the data is stored", with a series of ancillary components that have doubled in stature and have been installed in my old Dell notebook for one hours ...

SQL Server 2005 has a new set of functions that introduce CLR stored procedures, promote XML to data types, Service Broker message components, BI Reporting Services, and more. Reporting Services (report Service) is intended to replace the Crystal Reports, mining data, and later the development of the fact that this is a toy, and quickly abandoned by the developers. The Service Broker message component is used by some companies as a data synchronization mechanism, that is, read-write separation. XML enhancement can be directly in SQL XPath operations, through related functions, and table can also be a join, for some specific scenarios provide flexibility, but extremes meet, excessive use can cause efficiency problems.

Table variables were introduced for the first time in SQL Server 2005, and there are many occasions where temporary tables can be replaced, and automatically recycled properties like variables immediately attract me. The concept of data windows in Oracle is introduced to make it easier to work with complex SQL previously. The most common and far-reaching impact should be on paging, row_number is almost now standardized, and the new generation of programmers may have little to pay attention to. And before that, the good dbas like to do the paging stored procedures to show their ability, and developers like to compare their own use of the paging storage process efficiency, a variety of tests and even the words of war, it is a very pure age ah.

SQL Server 2005 borrows the experience of visual Studio and provides quite a gorgeous SQL Server Management Studio. With the integration of Enterprise Manager and Query Analyzer in the SQL Server 2000 era, the overall layout has been redesigned and the user experience has improved a lot. Unfortunately, support for smart hints is still not available, and third-party tools are also used to assist.

SQL Server 2005 is an unparalleled surprise for developers, and I'm afraid I can't see such a revolutionary breakthrough now. Its foundation and established concepts have been enhanced and perfected in subsequent releases. The current industry in the continuous weakening of relational database, NOSQL, Bigdata Popular, The Passion of SQL time is gone, leaving us is a generation of programmers memories.

Back to classic SQL Server 2005