Update cookies preferences

Sybase Developer's Handbook [Multiple-component retail product]

  • Format: Multiple-component retail product, 750 pages, height x width: 234x187 mm, weight: 1216 g, b&w illustrations, glossary, index, Contains 1 Paperback / softback and 1 CD-ROM
  • Pub. Date: 30-Nov-1997
  • Publisher: AP Professional
  • ISBN-10: 0127639500
  • ISBN-13: 9780127639505
Other books in subject:
  • Multiple-component retail product
  • Price: 59,88 €*
  • * This title is out of print. Used copies may be available, but delivery only inside Baltic States
  • This title is out of print. Used copies may be available, but delivery only inside Baltic States.
  • Quantity:
  • Add to basket
  • Add to Wishlist
Sybase Developer's HandbookLarger Image
  • Format: Multiple-component retail product, 750 pages, height x width: 234x187 mm, weight: 1216 g, b&w illustrations, glossary, index, Contains 1 Paperback / softback and 1 CD-ROM
  • Pub. Date: 30-Nov-1997
  • Publisher: AP Professional
  • ISBN-10: 0127639500
  • ISBN-13: 9780127639505
Other books in subject:
Permanent link: https://www.kriso.ee/db/9780127639505.html
Keywords:
This text should be a comprehensive resource for systems administrators, and includes detailed information on all aspects of the Sybase System 10 and 11 software, as well as sections on related supplementary software. The text deals with such issues as structuring a SQl server environment, using open server architectures, and tuning and optimizing a SQL server. The accompanying CD-ROM contains a trouble-shooting database and application.
Introduction 9(2)
CHAPTER 1 The Sybase Story
11(14)
Surviving the Ups & Downs
12(1)
Getting the Job Done
13(1)
We Are Here...
14(1)
The New Vision
14(1)
On the Move
15(1)
Once More Into the Breech
16(1)
Sorting Out the Products
17(1)
Sybase and Microsoft
18(3)
Management Changes
21(2)
Chapter Summary
23(2)
CHAPTER 2 Adaptive Server Architecture
25(12)
Unified Field Theory
25(2)
Optimized Data Stores
27(1)
Common Language Processor
28(2)
Component Integration Layer
30(1)
Common Management Component
31(1)
A Product for All Seasons
32(1)
Adaptive Server Enterprise Features
33(3)
Summary
36(1)
CHAPTER 3 Sybase Server Basic Overview
37(14)
The Big Picture
37(3)
Dataserver
40(1)
Disk Devices
41(1)
The Systems databases
42(3)
Master Systems Tables
45(1)
User Databases
46(1)
Logins, Users & Security
47(2)
Summary
49(2)
CHAPTER 4 System XI Overview
51(14)
New & Improved...
51(1)
System XI Specific Features
52(2)
System Architecture Changes
54(3)
Tunable Parameters
57(3)
Query Monitoring & Optimization
60(1)
Other Enhancements in System XI
61(1)
Summary
62(3)
CHAPTER 5 Sybase Database Objects
65(20)
First Contact
66(1)
Meta Data
66(4)
What Is an Object?
70(1)
Default
71(1)
Rule
72(1)
Stored Procedures
73(1)
Creating Stored Procedures
74(1)
Triggers
75(2)
Indexes
77(1)
Views
78(1)
Tables
79(2)
Datatypes
81(3)
Summary
84(1)
CHAPTER 6 Systems Procedures Reference
85(62)
Summary
146(1)
CHAPTER 7 Transact-SQL Syntax Reference
147(34)
Comments
179(1)
Summary
180(1)
CHAPTER 8 Structuring Your SQL Server Environment
181(104)
The Installation Checklist
181(13)
Allocating physical resources
194(16)
Memory and storage options
210(5)
System Configuration Options
215(36)
Users, groups and permissions
251(13)
Defining and using dump devices
264(19)
Summary
283(2)
CHAPTER 9 System XI Query & Data Management
285(10)
Transactions Defined
286(1)
Rules of Engagement
286(1)
Locks: What, Why & How
287(2)
Page versus Row Locks
289(1)
Designing Your Transactions
290(1)
Sample Transactions
290(3)
Summary
293(2)
CHAPTER 10 Tuning & Optimizing System XI
295(38)
Monitoring Resource Usage
295(1)
One Administrators Perspective
295(1)
Problem? What Problem
296(1)
OS Level Checks
297(1)
CPU Checks
297(1)
Memory
298(1)
Disk Drive Performance
298(1)
SQL Server Performance Factors
299(7)
Address Lock Contention
306(9)
Sp_sysmon Summary
315(3)
Data Cache Management
318(2)
Detailed Cache Reporting
320(1)
Evaluating Procedure Cache
321(2)
The Checkpoint Process
323(1)
Normal and Free Checkpoint Statistics
324(1)
Managing Disk I/O
325(1)
Configuration Limit Delays
326(1)
Device Semaphores
327(1)
Network I/O Management
328(1)
Other Monitoring Tools
329(4)
CHAPTER 11 T-SQL Query Performance Tuning Techniques
333(20)
Optimizing T-SQL Queries
333(1)
Stored Procedures
334(1)
Indexing
334(1)
Time Limit
335(1)
Understanding Query Plans
335(2)
Using the OR statement
337(1)
DISTINCT
337(1)
Showplan and Statistics IO
338(1)
Using Data Characteristics to Optimize Queries
338(4)
Summarizing Data
342(3)
Flipping Tables Using T-SQL
345(6)
Tying It All Together
351(2)
CHAPTER 12 Open Client
353(22)
Net-Lib 4.2
356(1)
SQLEDIT
357(1)
SQL INI
358(2)
SQL Advantage
360(5)
Microsoft Open Client
365(3)
Upgrading Net-Library Versions
368(2)
Net-Libraries 1.0
370(2)
Summary
372(3)
CHAPTER 13 CT-Library versus DB-Library
375(30)
Client Libraries
375(1)
DB-Library
376(3)
Implementing DB-Library Applications
379(8)
CT-Library
387(1)
Implementing CT-Library Applications
388(14)
Future Directions
402(3)
CHAPTER 14 Using Open Server
405(42)
Work Flow Automation Defined
407(1)
Inter-Application Integration
408(4)
Setting Up Open Server
412(1)
Open Server Defined
412(2)
Open Server Applications
414(1)
Middleware
415(3)
Setting Up the Development Environment
418(1)
Structure of an Open Server Application
419(28)
CHAPTER 15 Omni Connect
447(8)
OMNI SQL Gateway
447(7)
Summary
454(1)
CHAPTER 16 Replication & Data Synchronization Strategies
455(28)
Concepts
456(2)
Definition of Rep Server
458(2)
Sample Applications
460(2)
Rep Server Systems Architecture
462(2)
Key Installation and Startup Files
464(1)
Replication Server Manager
464(1)
Tricks & Traps
465(1)
Replication Command Language
466(5)
Steps for Installing Rep Server
471(1)
Functions and Function Strings
472(4)
Monitoring Rep Server
476(1)
Capacity Planning
477(1)
Performance Issues
478(2)
Users and Security
480(2)
Summary
482(1)
CHAPTER 17 SQL Anywhere & Mobile Computing
483(16)
A True Story
484(1)
Installing SQL Anywhere Professional
485(3)
Starting a SQL Anywhere Server
488(2)
Client Tools & Utilities
490(9)
CHAPTER 18 Third-Party Tools
499(16)
Introducing dbAgent
499(1)
Interactive Mode
500(3)
dbAgent Windows
503(3)
Generating Reports
506(1)
Automation Mode
507(5)
Installation
512(1)
Summary
513(2)
CHAPTER 19 Adaptive Server IQ
515(12)
IQ--The Objectives
516(1)
Focus on the Data Warehouse
517(1)
DSS--An Example
518(1)
The Query from Hell
518(1)
Solving the Performance Problem
519(1)
A Server Based Solution
520(7)
CHAPTER 20 Pulling it all together: The Adaptive Approach
527(14)
T-SQL: The Lingua Franca
529(7)
Sybase Strengths
536(1)
Sybase Weaknesses
537(1)
Threats to Sybase Growth
538(1)
Sybase Opportunities
538(2)
Summary
540(1)
Glossary & Definition of Key Terms and Concepts 541(28)
Index 569