SQL Server Advanced Data Types

SQL Server Advanced Data Types
Author :
Publisher : Apress
Total Pages : 400
Release :
ISBN-10 : 9781484239018
ISBN-13 : 1484239016
Rating : 4/5 (016 Downloads)

Book Synopsis SQL Server Advanced Data Types by : Peter A. Carter

Download or read book SQL Server Advanced Data Types written by Peter A. Carter and published by Apress. This book was released on 2018-08-23 with total page 400 pages. Available in PDF, EPUB and Kindle. Book excerpt: Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the growing support within SQL Server for operations and data transformations that have previously required third-party software and all the associated licensing and development costs. Benefit through a better understanding of what can be done inside the database engine with no additional costs or development time invested in outside software. Widely used types such as JSON and XML are well-supported by the database engine. The same is true of hierarchical data and even temporal data. Knowledge of these advanced types is crucial to unleashing the full power that's available from your organization's SQL Server database investment. SQL Server Advanced Data Types explores each of the complex data types supplied within SQL Server. Common usage scenarios for eachcomplex data type are discussed, followed by a detailed discussion on how to work with each data type. Each chapter demystifies the complex data and you learn how to use the data types most efficiently. The book offers a practical guide to working with complex data, using real-world examples to demonstrate how each data type can be leveraged. Performance considerations are also discussed, including the implementation of special indexes such as XML indexes and spatial indexes. What You'll Learn Understand the implementation of basic data types and why using the correct type is so important Work with XML data through the XML data type Construct XML data from relational result sets Store and manipulate JSON data using the JSON data type Model and analyze spatial data for geographic information systems Define hierarchies and query them efficiently through the HierarchyID type Who This Book Is For SQL Server developers and application developers who need to store and access complex data structures


SQL Server Advanced Data Types Related Books

SQL Server Advanced Data Types
Language: en
Pages: 400
Authors: Peter A. Carter
Categories: Computers
Type: BOOK - Published: 2018-08-23 - Publisher: Apress

GET EBOOK

Deliver advanced functionality faster and cheaper by exploiting SQL Server's ever-growing amount of built-in support for modern data formats. Learn about the gr
Beginning SQL Server 2005 Express Database Applications with Visual Basic Express and Visual Web Developer Express
Language: en
Pages: 605
Authors: Rick Dobson
Categories: Computers
Type: BOOK - Published: 2006-11-22 - Publisher: Apress

GET EBOOK

SQL Server 2005 Express is the database component of Microsoft's Express Suite of products. It is free of charge, inherits many (non-enterprise) features from S
Selected Readings on Database Technologies and Applications
Language: en
Pages: 563
Authors: Halpin, Terry
Categories: Computers
Type: BOOK - Published: 2008-08-31 - Publisher: IGI Global

GET EBOOK

"This book offers research articles focused on key issues concerning the development, design, and analysis of databases"--Provided by publisher.
Learn SQL Database Programming
Language: en
Pages: 550
Authors: Josephine Bush
Categories: Computers
Type: BOOK - Published: 2020-05-29 - Publisher: Packt Publishing Ltd

GET EBOOK

Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner’s guide Key FeaturesExplore all SQL statements in depth us
T-SQL Querying
Language: en
Pages: 865
Authors: Itzik Ben-Gan
Categories: Computers
Type: BOOK - Published: 2015-02-17 - Publisher: Microsoft Press

GET EBOOK

T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tu