Information Technology

Professional Microsoft® SQL Server® 2008 Programming

---

And so we begin anew. While the wait for SQL Server 2005 took a ghastly five years, Microsoft has blessed us (and, no, I’m not being sarcastic!) with SQL Server 2008 in just three short years.
It probably shouldn’t be surprising to me that SQL Server 2008 comes up short in terms of marquee features — the flash and glitz stuff. Yet, what I am surprised by is just how many ‘‘little things’’ have made it into this release. While there are some key feature areas (Policy Based Management, for example) that Microsoft can hang their marketing hat on, the most striking new features in SQL Server 2008 are far more subtle in nature.
SQL Server 2008 is jam-packed with a host of seemingly small, but extremely useful smaller additions such as:
❑ New, very useful data types (discrete date and time data types as well as support for geospatial data and hierarchical data representation) ❑ The new MERGE command (combining the options of INSERT, UPDATE, andDELETE all into one statement, this is sometimes referred to as an UPSERT in other products) ❑ A revamping of Reporting Services to allow for far more elegant reports ❑ Tracking and availability of ‘‘missing’’ index information (noticing at time of optimization that a non-existent index would have been useful had it been there)

---

Availability

No copy data

Detail Information

Series Title

-

Call Number

-

Publisher

: ., 2009

Collation

1-938

Language

English

ISBN/ISSN

978-0-470-25702-9

Classification

NONE

Content Type

-

Media Type

-

Carrier Type

-

Edition

-

Subject(s)

Professional Microsoft® SQL Server® 2008 Programmi

Specific Detail Info

-

Statement of Responsibility

-

Other version/related

File Attachment

Comments

---

You must be logged in to post a comment