Professional Microsoft SQL server 2008 programming / Rob Vieira.

Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming . Review the new features of SQL Server that will be of interest to you as an experi.

Saved in:
Bibliographic Details
Main Author: Vieira, Robert
Format: eBook
Language:English
Published: Indianapolis, Ind. : Wiley Pub., ©2009.
Series:Wrox professional guides.
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000 a 4500
001 ocn428967064
003 OCoLC
005 20240809213013.0
006 m o d
007 cr zn|||||||||
008 090615s2009 inua o 001 0 eng d
040 |a YUS  |b eng  |e pn  |c YUS  |d TEFOD  |d IDEBK  |d E7B  |d OCLCQ  |d UMI  |d FVL  |d B24X7  |d OCLCQ  |d N$T  |d OCLCQ  |d DEBSZ  |d OCLCQ  |d YDXCP  |d AUD  |d OCLCF  |d DKDLA  |d OCLCQ  |d TEFOD  |d EBLCP  |d OCLCQ  |d COO  |d AZK  |d AGLDB  |d OCLCQ  |d COCUF  |d OCLCO  |d ICA  |d CNNOR  |d OCLCQ  |d OCLCO  |d MOR  |d PIFAG  |d LIV  |d OCLCQ  |d OCLCO  |d D6H  |d BRL  |d STF  |d WRM  |d VTS  |d CEF  |d NRAMU  |d VT2  |d AU@  |d OCLCQ  |d OCLCO  |d WYU  |d UAB  |d A6Q  |d M8D  |d OCLCQ  |d VLY  |d UKCRE  |d INARC  |d UKAHL  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL 
019 |a 647810607  |a 649394651  |a 741566641  |a 746471922  |a 748589445  |a 816135341  |a 961496376  |a 962575822  |a 988432731  |a 992027209  |a 1037478137  |a 1037936916  |a 1038664731  |a 1045498477  |a 1055341317  |a 1063956978  |a 1081189713  |a 1083555964  |a 1103276110  |a 1129364264  |a 1153033342  |a 1162227618  |a 1192351605  |a 1228584581  |a 1240508267  |a 1285739975 
020 |a 9780470508459  |q (electronic bk.) 
020 |a 0470508450  |q (electronic bk.) 
020 |a 0470257024 
020 |a 9780470257029 
020 |a 0470632097 
020 |a 9780470632093 
020 |a 1282122258 
020 |a 9781282122253 
020 |a 9786612122255 
020 |a 6612122250 
020 |z 9780470257029 
035 |a (OCoLC)428967064  |z (OCoLC)647810607  |z (OCoLC)649394651  |z (OCoLC)741566641  |z (OCoLC)746471922  |z (OCoLC)748589445  |z (OCoLC)816135341  |z (OCoLC)961496376  |z (OCoLC)962575822  |z (OCoLC)988432731  |z (OCoLC)992027209  |z (OCoLC)1037478137  |z (OCoLC)1037936916  |z (OCoLC)1038664731  |z (OCoLC)1045498477  |z (OCoLC)1055341317  |z (OCoLC)1063956978  |z (OCoLC)1081189713  |z (OCoLC)1083555964  |z (OCoLC)1103276110  |z (OCoLC)1129364264  |z (OCoLC)1153033342  |z (OCoLC)1162227618  |z (OCoLC)1192351605  |z (OCoLC)1228584581  |z (OCoLC)1240508267  |z (OCoLC)1285739975 
037 |b OverDrive, Inc.  |n http://www.overdrive.com 
037 |a B6E468F2-EE87-41CD-B750-86DA26186ABF  |b OverDrive, Inc.  |n http://www.overdrive.com 
050 4 |a QA76.9.C55  |b V535 2009eb 
072 7 |a UND  |2 bicssc 
072 7 |a COM  |x 018000  |2 bisacsh 
049 |a HCDD 
100 1 |a Vieira, Robert. 
245 1 0 |a Professional Microsoft SQL server 2008 programming /  |c Rob Vieira. 
260 |a Indianapolis, Ind. :  |b Wiley Pub.,  |c ©2009. 
300 |a 1 online resource (xxxix, 893 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Wrox professional guides 
500 |a Title from title screen. 
500 |a Includes index. 
505 0 |a Cover -- Contents -- Introduction -- Chapter 1: Being Objective -- So, What Exactly Do We Have Here? -- An Overview of Database Objects -- SQL Server Data Types -- SQL Server Identifiers for Objects -- Summary -- Chapter 2: Tool Time -- Books Online -- The SQL Server Configuration Manager -- The SQL Server Management Studio -- SQL Server Business Intelligence Development Studio -- SQL Server Integration Services (SSIS) -- Reporting Services -- Bulk Copy Program (bcp) -- SQL Server Profiler -- sqlcmd -- Summary -- Chapter 3: Asking a Better Question -- A Quick Review of Subqueries -- Building a Nested Subquery -- Correlated Subqueries -- Derived Tables -- The EXISTS Operator -- The INTERSECT and EXCEPT Operators -- Common Table Expressions (CTEs) -- Recursive Queries -- MERGE -- Using External Calls to Perform Complex Actions -- Performance Considerations -- Summary -- Chapter 4: XML Integration -- The XML Data Type -- Retrieving Relational Data in XML Format -- A Quick Heads Up Regarding XML Indexes -- A Brief Word on Hierarchical Data -- Summary -- Chapter 5: Daring to Design -- Normalization 201 -- Relationships -- Diagramming -- Logical versus Physical Design -- Dealing with File-Based Information Via Classic BLOBs -- Subcategories -- Database Reuse -- De-Normalization -- Partitioning for Scalability -- The SQL Server Diagramming Tools -- Regarding Date Columns -- Summary -- Chapter 6: Core Storage and Index Structure -- SQL Server Storage -- Understanding Indexes -- Creating, Altering, and Dropping Indexes -- Choosing Wisely: Deciding What Index Goes Where and When -- Maintaining Your Indexes -- Summary -- Chapter 7: More Advanced Index Structures -- XML Indexes -- User-Defined Data Types -- Hierarchical Data -- Spatial Data -- Filestreams -- Enabling Filestreaming -- Table Compression -- Summary -- Chapter 8: Views -- Reviewing View Syntax -- More Complex Views -- Editing Views with T-SQL -- Dropping Views -- Auditing: Displaying Existing Code -- Protecting Code: Encrypting Views -- About Schema Binding -- Making Your View Look Like a Table with VIEW_METADATA -- Indexed (Materialized) Views -- Partitioned Views -- Summary -- Chapter 9: Scripts and Batches -- Script Basics -- Batches -- SQLCMD -- Dynamic SQL: Generating Your Code on the Fly with the EXEC Command -- Control-of-Flow Statements -- Summary -- Chapter 10: Advanced Programmability -- A More Advanced Look At Stored Procedures -- Table-Valued Parameters (TVPs) -- Debugging -- Understanding the SQLCLR and .NET Programming in SQL Server -- Creating Aggregate Functions -- Custom Data Types -- Summary -- Chapter 11: Transactions and Locks -- Transactions -- How the SQL Server Log Works -- Locks and Concurrency -- Setting the Isolation Level -- Dealing with Deadlocks (a.k.a. 8220;A 12058221;) -- Summary -- Chapter 12: Triggers -- What Is a Trigger? -- Using Triggers for Data Integrity Rules -- Other Common Uses for Triggers -- Other Trigger Issues -- INSTEAD OF Triggers -- IF UPDATE() and COLUMNS_UPDATED() -- Performance Considerations -- Dropping Triggers -- Summary -- Chap. 
520 |a Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the information in Professional Microsoft SQL Server 2008 Programming . Review the new features of SQL Server that will be of interest to you as an experi. 
546 |a English. 
630 0 0 |a SQL server. 
630 0 7 |a SQL server.  |2 blmlsh 
630 0 7 |a SQL server  |2 fast 
650 0 |a Client/server computing. 
650 0 |a Database management. 
650 7 |a COMPUTERS  |x Data Processing.  |2 bisacsh 
650 7 |a Client/server computing  |2 fast 
650 7 |a Database management  |2 fast 
758 |i has work:  |a Professional Microsoft SQL server 2008 programming (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCFtywK8H6Bm8KD3Fjbpyr3  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Vieira, Robert.  |t Professional Microsoft SQL server 2008 programming.  |d Indianapolis, Ind. : Wiley Pub., ©2009  |z 0470257024  |w (DLC) 2009010578  |w (OCoLC)316327190 
830 0 |a Wrox professional guides. 
856 4 0 |u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=433914  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD