Muutke küpsiste eelistusi

Understanding Sybase SQL Server: A Hands on Approach [Pehme köide]

, , ,
  • Formaat: Paperback / softback, 450 pages, kõrgus: 240 mm, Illustrations
  • Ilmumisaeg: 30-Nov-1996
  • Kirjastus: International Thomson Computer Press
  • ISBN-10: 1850328528
  • ISBN-13: 9781850328520
Teised raamatud teemal:
Understanding Sybase SQL Server: A Hands on ApproachSuurem pilt
  • Formaat: Paperback / softback, 450 pages, kõrgus: 240 mm, Illustrations
  • Ilmumisaeg: 30-Nov-1996
  • Kirjastus: International Thomson Computer Press
  • ISBN-10: 1850328528
  • ISBN-13: 9781850328520
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781850328520.html
Märksõnad:
Preface xi(2)
Acknowledgments xiii
SECTION I TECHNOLOGICAL CONTEXT 1(80)
Chapter 1 Introduction to Database Computing with Sybase SQL Server
3(20)
Relevance of Database Systems
4(1)
RDBMS Overview
5(1)
Mainframe Computing
6(1)
Client/Server Computing a Database Environment
7(5)
The Sybase Family of Products
12(3)
OLTP Applications
15(1)
Decision Support and Data Warehousing Applications
16(4)
Mass Deployment Applications
20(1)
Future Trends
20(2)
Summary
22(1)
Chapter 2 System 11 Architecture
23(20)
SQL Server's Multithreaded Process Model
24(2)
SQL Server Engines and Sybase SMP
26(4)
SQL Server Layout in Memory
30(1)
The Kernel and DBMS
31(3)
Disk I/O
34(1)
The Data Cache
34(2)
Overview of Transaction Management and Logging
36(1)
APIs
37(3)
Enterprise Architecture
40(2)
Summary
42(1)
Chapter 3 The SQL Server Engine
43(16)
Overview if Engine Components
44(1)
Databases
45(4)
SQL Server Objects
49(5)
How SQL Server Manages Storage
54(3)
How Data Updates Occur
57(1)
Summary
58(1)
Chapter 4 System 11 Features Provide New Solutions
59(10)
A Scalable Database System
60(1)
Relief for I/O-Intensive Applications with Large I/O
60(1)
Fast Transaction Logging with ULCs
61(2)
Fast Row Inserts with Table Partitioning
63(1)
Control over Memory Management with Name Data Caches
64(1)
Control over Lock Management
65(1)
Scalability
66(2)
Configuration Parameters for Fine Tuning
68(1)
Summary
68(1)
Chapter 5 Interacting with SQL Server
69(12)
The isql Utility for Unix
70(5)
Using Scripts with isql and Redirection
75(3)
The wisql and wisql32 Utilities
78(1)
Summary
79(2)
SECTION II SQL SERVER FUNDAMENTALS 81(196)
Chapter 6 Database Devices and Fault Tolerance
83(26)
Foundation Topics
83(4)
Deciding Where to Put the Database Device
87(1)
Creating and Dropping Database Devices
88(5)
Fault Resilience with Mirroring
93(8)
Dump Devices for Backups
101(1)
A Pool of Default Database Devices
102(2)
Getting Information About Devices
104(1)
Exercises
105(4)
Chapter 7 Creating and Managing Databases
109(36)
Deciding Where to Place Data and logsegments
111(1)
How System Tables Manage Disk Storage
111(2)
Estimating Database Size
113(7)
Creating, Altering, and Dropping Databases
120(7)
Database Options
127(4)
Getting Information About Database Options
131(1)
Working with Segments
132(9)
Exercises
141(4)
Chapter 8 Database objects: Tables and Data Integrity
145(48)
Foundation Topics
145(6)
Datatypes
151(4)
Tables
155(12)
Rules
167(2)
Defaults
169(2)
Binding and Unbinding Rules and Defaults
171(4)
Indexes
175(9)
Triggers
184(1)
Views
185(4)
Exercises
189(4)
Chapter 9 Transact-SQL and Its Extensions
193(54)
Local and Global Variables
194(5)
Transact-SQL Batches
199(1)
Control-of-Flow Keywords
200(8)
Cursors
208(10)
Stored procedures
218(12)
Triggers
230(11)
Exercises
241(6)
Chapter 10 Transaction Management
247(30)
Transaction Fundamentals
248(5)
Transaction Nesting
253(1)
Getting Information About the Transaction State
254(2)
Transaction Modes
256(1)
Concurrency and Locking
257(7)
Isolation Levels
264(3)
Allowing Dirty Reads
267(1)
Using Cursors in Transactions
268(1)
Using Stored Procedures in Transactions
269(2)
Using Triggers in Transactions
271(1)
DDL Commands in Transactions
271(1)
Exercises
272(5)
SECTION III LANGUAGE, MANAGEMENT, AND CONTROL 277(140)
Chapter 11 Installing SQL Server
279(26)
Foundation: The Client/Server Interface
280(5)
Preinstallation Tasks
285(4)
Installing SQL Server
289(2)
Post-Installation Activities
291(8)
SQL Server Error Logs
299(2)
Stopping SQL Server
301(2)
Exercises
303(2)
Chapter 12 Configuring SQL Server
305(24)
Configuration Fundamentals
306(6)
Display Levels
312(3)
Using sp_configure
315(7)
Commonly Configured Parameters
322(4)
Summary
326(1)
Exercises
326(3)
Chapter 13 SQL Server Security Features
329(36)
Basic Security: Roles and Ownership
330(5)
Managing User Access
335(10)
Managing Permissions
345(9)
The Audit System
354(7)
Exercises
361(4)
Chapter 14 Backup and Recovery
365(28)
Backup and Recovery Fundamentals
366(2)
Backup and the Dump Command
368(7)
Recovery and the Load Command
375(8)
Backup Server
383(1)
Backup and Restore Strategies for User Databases
383(2)
Backup and Restore Strategies for System Databases
385(3)
Managing Free Space with Thresholds
388(1)
Exercises
389(4)
Chapter 15 Database Administration Tools
393(24)
bcp
394(5)
defncopy
399(1)
The dbcc Utility Set
400(8)
SQL Server Manager
408(1)
Enterprise SQL Server Manager
409(1)
SQL Server Monitor
410(2)
sp_sysmon
412(3)
Exercises
415(2)
SECTION IV OPTIMIZING SQL SERVER FOR YOUR SYSTEM 417(50)
Chapter 16 Performance Tuning at the Query Level
419(18)
Query processing Fundamentals
420(2)
Getting Information About Optimizer Decisions
422(9)
Influencing the Optimizer
431(5)
Summary
436(1)
Chapter 17 Performance Tuning at the Database Level
437(18)
Performance Tuning Fundamentals
438(4)
How Distributing Objects Can Help Performance
442(2)
Using Segments to Distribute Data
444(3)
Using Partitions to Distribute Data
447(3)
Cache Performance
450(4)
Summary
454(1)
Chapter 18 System-Level Performance Tuning
455(12)
Utilization of System Resources
455(6)
Disk I/O Management
461(2)
Network I/O Management
463(1)
tempdb Performance
464(1)
Summary
465(2)
Appendix A System Tables 467(4)
Appendix B Global Variables 471(6)
Appendix C Transact-SQL Quick Reference 477(12)
Appendix D SyBooks Installation Guide 489(2)
Index 491