early release of locks | Typical transactions at various isolation levels Two-phase locking |
early release of locks: an exception | Early release of read locks |
editing breakpoint conditions | Editing breakpoint conditions |
editing: properties of database objects | Setting properties for database objects |
editing: table data | Browsing the information in tables |
effects of: transaction scheduling | Serializable schedules |
effects of: unserializable transaction scheduling | Serializable schedules |
efficiency: improving and locks | Reducing the impact of locking |
efficiency: improving using indexes | Special optimizations |
element directive: using | Using FOR XML EXPLICIT |
eliminating duplicate query results | Eliminating duplicate query results |
elimination of unnecessary case translation | Elimination of unnecessary case translation |
enabling breakpoints | Disabling and enabling breakpoints |
enabling procedure profiling: SQL | Enabling procedure profiling |
enabling procedure profiling: Sybase Central | Enabling procedure profiling |
encryption: cache size | Increase the cache size |
encryption: hiding objects | Hiding the contents of procedures, functions, triggers and views |
ending transactions | Using transactions |
enforcing column uniqueness | Other uses for indexes |
enforcing entity and referential integrity | Enforcing entity and referential integrity |
enforcing referential integrity | Enforcing referential integrity |
ensuring compatible object names | Ensuring compatible object names |
ensuring data integrity | Ensuring Data Integrity |
entities: about | Entities |
entities: attributes | Entities |
entities: choosing | Step 1: Identify entities and relationships |
entities: definition of | Database design concepts |
entities: forcing integrity | Enforcing entity and referential integrity |
entity integrity | Adaptive Server Anywhere SQL features |
entity integrity: breached by client application | If a client application breaches entity integrity |
entity integrity: introduction | Data integrity tools |
entity-relationship diagrams: about | Database design concepts |
entity-relationship diagrams: reading | Relationships |
equals operator: comparison operator | Using comparison operators in the WHERE clause |
equijoins: about | Types of explicit join conditions |
erase database wizard: using | Erasing a database |
erase utility: using | Erasing a database |
erasing databases | Erasing a database |
error handling in Transact-SQL procedures | Error handling in Transact-SQL procedures |
error handling: ON EXCEPTION RESUME | Error handling with ON EXCEPTION RESUME |
error handling: procedures and triggers | Default error handling in procedures and triggers |
errors and warnings in procedures and triggers | Errors and warnings in procedures and triggers |
errors: conversion | Conversion errors during import |
errors: procedures and triggers | Errors and warnings in procedures and triggers |
errors: Transact-SQL | Error handling in Transact-SQL procedures Transact-SQL-like error handling in the Watcom-SQL dialect |
EstCpuTime: estimate in access plans | Reading access plans |
EstDiskReads: estimate in access plans | Reading access plans |
EstDiskReadTime: estimate in access plans | Reading access plans |
EstDiskWrites: estimate in access plans | Reading access plans |
estimated leaf pages: item in access plans | Reading access plans |
estimated pages: item in access plans | Reading access plans |
estimated row size: item in access plans | Reading access plans |
estimated rows: item in access plans | Reading access plans |
EstRowCount: estimate in access plans | Reading access plans |
EstRunTime: estimate in access plans | Reading access plans |
events: viewing individual profiling information | Viewing profiling information for a specific procedure |
events: viewing summary profiling data | Viewing procedure profiling information in Sybase Central |
examining variables: debugger | Working with variables |
examples: dirty reads | Dirty read tutorial |
examples: implications of locking | Practical locking implications tutorial |
examples: non-repeatable read | Non-repeatable read tutorial |
examples: non-repeatable reads | Non-repeatable read tutorial |
examples: phantom locks | Practical locking implications tutorial |
examples: phantom rows | Phantom row tutorial |
Excel and remote access | Microsoft Excel (Microsoft 3.51.171300) |
EXCEPT operation: combining queries | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
EXCEPT operation: NULL | Set operators and NULL |
EXCEPT operation: rules | Rules for set operations |
EXCEPT operation: using | Using EXCEPT and INTERSECT |
exception handlers: nested compound statements | Nested compound statements and exception handlers |
exception handlers: procedures and triggers | Using exception handlers in procedures and triggers |
exceptions: declaring | Default error handling in procedures and triggers |
exclusive locks | Types of locks |
exclusive versus shared locks | Types of locks |
EXECUTE IMMEDIATE statement: procedures | Using the EXECUTE IMMEDIATE statement in procedures |
executing triggers | Executing triggers |
existence test: about | Existence test Existence test |
existence test: negation of | Existence test |
EXISTS operator | Existence test |
EXISTS predicates: rewriting subqueries as | Rewriting subqueries as EXISTS predicates |
explicit join conditions | Join conditions |
explicit join conditions (the ON phrase) | Explicit join conditions (the ON phrase) |
EXPLICIT mode: syntax | Using FOR XML EXPLICIT |
EXPLICIT mode: using | Using FOR XML EXPLICIT |
EXPLICIT mode: using the cdata directive | Using FOR XML EXPLICIT |
EXPLICIT mode: using the element directive | Using FOR XML EXPLICIT |
EXPLICIT mode: using the hide directive | Using FOR XML EXPLICIT |
EXPLICIT mode: using the xml directive | Using FOR XML EXPLICIT |
EXPLICIT mode: writing queries | Using FOR XML EXPLICIT |
explode: query execution algorithms | Explode |
export tools | Export tools |
exporting data: about | Introduction to import and export |
exporting data: schema | Exporting table data or table schema |
exporting data: tools | Export tools |
exporting databases: using | Exporting databases |
exporting relational data as XML | Exporting relational data as XML |
exporting relational data as XML from Interactive SQL | Exporting relational data as XML from Interactive SQL |
exporting relational data as XML using the DataSet object | Exporting relational data as XML using the DataSet object |
exporting tables: schema | Exporting table data or table schema |
exporting: Adaptive Server Enterprise compatibility | Adaptive Server Enterprise compatibility |
exporting: file formats | Data formats |
exporting: introduction | Importing and exporting data |
exporting: NULL values | Outputting NULLs |
exporting: query results | Exporting query results |
exporting: schema | Exporting table data or table schema |
exporting: tables | Exporting tables |
expression SQL: item in access plans | Reading access plans |
expressions: NULL values | Properties of NULL |
external calls: creating procedures and functions | Creating procedures and functions with external calls |
external functions: canceling | External function prototypes |
external functions: passing parameters | Passing parameters to external functions |
external functions: prototypes | External function prototypes |
external functions: return types | Passing parameters to external functions |
external loading | Performance considerations of moving data |
external logins: about | Working with external logins |
external logins: creating | Creating external logins |
external logins: dropping | Dropping external logins |
external servers: ODBC | Defining ODBC external servers |
extract database wizard: about | Extracting data |
extracting: databases for SQL Remote | Extracting data |