1.

Record Nr.

UNINA9910454403303321

Autore

Vieira Robert

Titolo

Professional Microsoft SQL server 2008 programming [[electronic resource] /] / Rob Vieira

Pubbl/distr/stampa

Indianapolis, IN, : Wiley Pub., 2009

ISBN

0-470-63209-7

1-282-12225-8

9786612122255

0-470-50845-0

Edizione

[1st edition]

Descrizione fisica

1 online resource (938 p.)

Collana

Wrox professional guides Professional Microsoft SQL server 2008 programming

Disciplina

005.75/85

Soggetti

Client/server computing

Database management

Electronic books.

Lingua di pubblicazione

Inglese

Formato

Materiale a stampa

Livello bibliografico

Monografia

Note generali

Includes index.

Nota di contenuto

Professional Microsoft® SQL Server® 2008 Programming; Contents; Introduction; Chapter 1: Being Objective: Re-Examining Objects in SQL Server; Chapter 2: Tool Time; Chapter 3: Asking a Better Question: Advanced Queries; Chapter 4: XML Integration; Chapter 5: Daring to Design; Chapter 6: Core Storage and Index Structure; Chapter 7: More Advanced Index Structures; Chapter 8: Views; Chapter 9: Scripts and Batches; Chapter 10: Advanced Programmability; Chapter 11: Transactions and Locks; Chapter 12: Triggers; Chapter 13: SQL Cursors; Chapter 14: Reporting Services

Chapter 15: Buying in Bulk: The Bulk Copy Program (BCP) and Other Basic Bulk OperationsChapter 16: Getting Integrated; Chapter 17: Replication; Chapter 18: Looking at Things in Full: Full-Text Search; Chapter 19: Feeling Secure; Chapter 20: A Grand Performance: Designing a Database That Performs Well; Chapter 21: What Comes After: Forensic Performance Tuning; Chapter 22: Administration; Chapter 23: SMO: SQL Management Objects; Chapter 24: Data Warehousing; Chapter 25: Being Well Connected; Appendix A: System



Functions; Appendix B: Going Meta: Getting Data About Your Data

Appendix C: The BasicsIndex

Sommario/riassunto

SQL Server 2008 has many new additions since the last version, SQL Server 2005. These include New useful data types (discrete date and time data types as well as support for geospatial data and hierarchical data representation)The new MERGE commandA revamping of Reporting Services to allow for more elegant reportsTracking and availability of "missing" index information And those are just a few of the improvements.  This book is written for SQL Server 2008. However, it does maintain roots going bad a few versions and looks out for backwa