View in EDS PDF Full Text

Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook

Saved in:
Bibliographic Details
Title: Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
Description: Database professionals will find that this new edition aids in mastering the latest version of Microsoft's SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency.Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered.• Identifies and discusses the most common issues database administrators (DBAs) face day-to-day•Provides DBAs with solutions actually used by the authors in enterprise environments•Explores new features which add more control but reduce performance
Authors: Ken England, Gavin JT Powell
Resource Type: eBook.
Subjects: Relational databases, Client/server computing
Categories: COMPUTERS / Database Administration & Management
Database: eBook Collection (EBSCOhost)
FullText Links:
  – Type: ebook-pdf
Text:
  Availability: 0
Header DbId: nlebk
DbLabel: eBook Collection (EBSCOhost)
An: 211548
RelevancyScore: 1012
AccessLevel: 6
PubType: eBook
PubTypeId: ebook
PreciseRelevancyScore: 1011.53295898438
IllustrationInfo
ImageInfo – Size: thumb
  Target: https://rps2images.ebscohost.com/rpsweb/othumb?id=NL$211548$PDF&s=r
– Size: medium
  Target: https://rps2images.ebscohost.com/rpsweb/othumb?id=NL$211548$PDF&s=d
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
– Name: Abstract
  Label: Description
  Group: Ab
  Data: Database professionals will find that this new edition aids in mastering the latest version of Microsoft's SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency.Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered.• Identifies and discusses the most common issues database administrators (DBAs) face day-to-day•Provides DBAs with solutions actually used by the authors in enterprise environments•Explores new features which add more control but reduce performance
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Ken+England%22">Ken England</searchLink><br /><searchLink fieldCode="AR" term="%22Gavin+JT+Powell%22">Gavin JT Powell</searchLink>
– Name: TypePub
  Label: Resource Type
  Group: TypPub
  Data: eBook.
– Name: Subject
  Label: Subjects
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22Relational+databases%22">Relational databases</searchLink><br /><searchLink fieldCode="DE" term="%22Client%2Fserver+computing%22">Client/server computing</searchLink>
– Name: SubjectBISAC
  Label: Categories
  Group: Su
  Data: <searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Database+Administration+%26+Management%22">COMPUTERS / Database Administration & Management</searchLink>
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=nlebk&AN=211548
RecordInfo BibRecord:
  BibEntity:
    Classifications:
      – Code: 005.7565
        Scheme: ddc
        Type: prePub
    Languages:
      – Code: eng
        Text: English
    Subjects:
      – SubjectFull: Relational databases
        Type: general
      – SubjectFull: Client/server computing
        Type: general
    Titles:
      – TitleFull: Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Ken England
      – PersonEntity:
          Name:
            NameFull: Gavin JT Powell
      – PersonEntity:
          Name:
            NameFull: Ken England
      – PersonEntity:
          Name:
            NameFull: Gavin JT Powell
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 01
              Type: published
              Y: 2007
            – D: 04
              M: 02
              Type: profile
              Y: 2014
          Identifiers:
            – Type: isbn-print
              Value: 9781555583194
            – Type: isbn-electronic
              Value: 9780080554082
          Titles:
            – TitleFull: Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
              Type: main
ResultId 1