search for books and compare prices
Tables of Contents for Admin911
Chapter/Section Title
Page #
Page Count
Acknowledgments
xiv
Architecture and Installation
1
20
SQL Server's Roots
2
1
Architecture Overview
3
1
Net-Library
3
1
Open Data Services
3
1
The SQL Server Engines
4
1
Installation Tips
4
17
SQL Server 2000 Editions
7
2
Preinstallation Decisions
9
3
Removing SQL Server
12
1
Starting SQL Server and Agent
12
1
Upgrading From SQL Server 4.2
13
1
Upgrading from SQL Server 6.0 or 6.5
14
1
Upgrading from SQL Server 7.0
15
2
Upgrading Stored Procedures
17
1
Tricks and Tips for Upgrading
17
2
Files and Directories
19
1
Moving the Tools Directory
20
1
Managing SQL Server
21
24
Managing the Server
22
9
Managing Multiple Instances
22
1
Renaming a Server
23
1
Tweaking Configuration Options
24
7
Managing the Database
31
7
Tweaking Database Configuration Options
32
6
Managing Security
38
5
Common Security Concerns
39
2
Avoiding Dangerous Settings
41
2
Deploying Your Database
43
1
Service Packs
44
1
Optimizing and Automating SQL Server Administration
45
34
Startup Stored Procedures
46
1
SQL Mail
47
4
Configuring SQL Mail
47
2
xp_sendmail
49
1
Other Mailer Options
50
1
Optimizing SQL Server Agent
51
3
General Tab Options
51
1
Advanced Tab Options
52
1
Alert System Tab Options
52
1
Job System Tab
53
1
Connection Tab
53
1
Operators
54
3
Adding an Operator
54
1
Scripting Operators
55
2
Jobs
57
4
Creating Jobs
58
2
Job Categories
60
1
Debugging Jobs
60
1
Scripting Jobs
61
1
Centralized Administration
61
2
Managing Multi Server Jobs
61
1
Creating a Multi Server Job
62
1
Administering DTS
63
16
DTS Connections
64
1
Saving a Package
65
1
Managing Package Versions
66
1
Securing a Package
67
1
Executing Packages
68
1
Managing Package Locations
69
1
Using DTSRunUI
70
1
Scheduling a Package
70
1
Optimizing Packages
71
3
DTS Without SQL Server
74
1
Troubleshooting DTS
75
4
Monitoring and Tuning SQL Server
79
22
Managing Messages
80
3
Error Message Severity Levels
81
1
Raising an Error
82
1
xp_logevent
83
1
System Monitor
83
7
Adding Counters
84
2
Performance Counters to Watch
86
1
System Monitor Logging
87
2
Viewing Performance Logs
89
1
sp_monitor
90
1
Trace Flags
91
3
Setting Trace Flags
91
3
Alerts
94
2
Creating an Alert
94
2
Setting Performance Alerts
96
1
Setting Job Notifications
96
1
Forecasting Growth
97
2
Database Growth Reports
97
2
sqldiag
99
1
Black Box
99
2
Automating Administrative Tasks
101
46
Query Analyzer
102
6
Command-Line Options
102
2
Distributing Configuration Files
104
1
Object Browser
104
1
Getting Around the 256-Character Limit
104
1
Shortcut Queries
105
1
Finding Objects
106
1
Templates
106
1
Creating Your Own Templates
107
1
Administrative T-SQL
108
32
Simplifying Cursors
108
3
Extended Stored Procedures
111
8
Administrative DBCC Commands
119
8
System Functions
127
3
Working with Identities
130
5
Extended Properties
135
5
OLE Automation
140
7
Alternate Method of Counting Records
144
3
Optimizing and Troubleshooting SQL Server
147
50
Optimizing Windows 2000 Networks for SQL Server
148
6
Optimizing Operating System Components
148
1
Optimizing Network Settings
149
2
Optimizing Name Resolution
151
3
Registry Dependencies
154
2
Rebuilding SQL Registry Entries After Reinstalling Windows
155
1
Using Registry Server Listings
155
1
Managing and Configuring the Database
156
3
Monitoring Growth
156
1
Disconnecting Users
157
2
Model Database
159
1
Database Standards
159
5
Naming Conventions
160
2
Numeric Data Type Decisions
162
1
Character Data Types
163
1
Performance Tuning Your Database Model
164
5
Row Size
165
2
Text, ntext, and image Fields
167
1
Minimizing Wasted Column Space
168
1
Summarizing Data
169
1
Using Sample Data
169
3
Using a CROSS JOIN
169
3
Optimizing Stored Procedures
172
3
Determining Parameters for Stored Procedures
172
1
Troubleshooting Cached Stored Procedures
173
1
Tuning Stored Procedure Performance
174
1
Building Dynamic Stored Procedures
174
1
Using Temporary Tables
175
3
Table Data Types for Temporary Tables
176
1
Using the Tempdb Database
177
1
Performance Tuning T-SQL
178
2
Performance Tips for Queries
179
1
Non-logged SQL Statements
180
1
Returning Top Rows
180
2
Ordering Views
181
1
Quoted Identifiers
182
1
Read-Only Databases
183
1
Optimizing Indexes
184
7
Optimizing Index Fill Factors
184
1
Using DBCC SHOWCONTIG
185
4
Defragging Indexes
189
1
Using the Index Tuning Wizard
190
1
SQL Server Profiler
191
4
Web Troubleshooting Resources
195
2
Disaster Planning and Recovery
197
36
Developing a Plan
198
1
Third-Party Backup Programs
198
1
Types of Backups
199
11
Full Backups in Enterprise Manager
199
5
Full Backups in T-SQL
204
2
Configuring Devices with T-SQL
206
1
Differential Backups
206
1
Transaction Log Backups
207
1
Transaction Log Backups in T-SQL
207
1
Backing Up Individual Files and File Groups
208
1
Backupset Table
209
1
Optimizing Backup and Restore Performance
209
1
Database Recovery Models
210
3
Simple Recovery Model
211
1
Full Recovery Model
212
1
Bulk Recovery Model
212
1
Recovery Options
213
1
Maintenance Plans
213
3
Using sqlmaint
214
2
Using xp_sqlmaint
216
1
Restoring
216
11
Full Database Restores
217
2
Full Restore in T-SQL
219
3
Differential Database Restores
222
1
Transaction Log Restores
223
1
Point-In-Time Scenarios
224
1
Fixing Broken Logins
224
1
Using sp_change_users_login
225
1
Recovering a Corrupt Master Database
226
1
Rebuilding Other Databases
227
1
Detaching and Attaching a Database
227
6
Detaching a Database
228
1
Other Methods of Copying Data Files
229
1
Attaching a Database
230
2
Uninstalling SQL Server or Upgrading from an Evaluation Edition
232
1
Scaling SQL Server
233
42
Linked Servers
234
25
Data Flow of Linked Servers
234
1
Myriad Uses for Linked Servers
235
1
Creating a Linked Server in Enterprise Manager
236
3
Creating a Linked Server Through T-SQL
239
2
Linked Server Security
241
4
Configuring the Linked Server
245
2
Configuring Linked Servers Through T-SQL
247
1
Linked Servers Between Heterogeneous Databases
247
3
Deleting a Linked Server
250
1
Querying Linked Servers
250
1
Joining Multiple Servers
251
1
Executing Stored Procedures on Linked Servers
252
1
Getting Verbose Error Messages
253
3
Tuning and Supporting Linked Servers
256
3
Distributed Partitioned Views
259
9
DPV Architecture
259
2
Preparing for a DPV
261
2
Setting Up and Using the Partitioned Views
263
1
Inserting Data into the Partitioned View
264
2
Querying a Partitioned View
266
1
Updating a Partitioned View
266
1
DPV Limitations
267
1
Indexed Views
268
7
Indexed Views Requirements and Restrictions
268
3
Creating an Indexed View
271
2
Querying Indexed Views
273
2
SQL Server Replication
275
40
SQL Server Replication
276
4
Replication Considerations
276
1
Replication Architecture
277
2
Heterogeneous Support for Replication
279
1
Understanding the Types of Replication
280
5
Snapshot Replication
280
2
Merge Replication
282
1
Transactional Replication
283
1
Bidirectional Replication
284
1
Configuring SQL Server Agent Replication
285
1
Preinstallation Concerns
285
4
Data Types Concerns
286
1
Dealing with Identity Columns
287
2
Initial Replication Setup
289
5
Customizing the Initial Installation
291
3
Disabling Replication
294
1
Sanpshot/Transactional Replication Setup
295
7
Merge Replication Setup
302
3
Creating Subscriptions
305
3
Merge Replication Subscriptions
306
1
Configuring Replication After the Wizard
306
2
Schema Changes in Replication
308
2
sp_repladdcolumn
308
2
sp_repldropcolumn
310
1
Monitoring and Troubleshooting Replication
310
1
Troubleshooting Agents
311
1
Recovering from a Disaster
312
1
Optimizing Replication
312
3
A System Tables and Undocumented DBCC Commands
315
26
System Tables
316
18
Tables in Master Database Only
316
10
Tables in Every Database
326
8
Undocumented DBCC Commands
334
7
B Extended Stored Procedures
341
12
xp_availablemedia
342
1
xp_cmdshell
342
1
xp_dirtree
343
1
xp_enum_activescriptengines
343
1
xp_enum_oledb_providers
343
1
xp_enumcodepages
344
1
xp_enumdsn
344
1
xp_enumerrorlogs
345
1
xp_enumgroups
345
1
xp_fileexist
345
1
xp_fixeddrives
346
1
xp_getfiledetails
346
1
xp_getnetname
347
1
xp_loginconfig
347
1
xp_logevent
347
1
xp_logininfo
348
1
xp_ntsec_enumdomains
348
1
xp_readerrorlog
348
1
xp_regdeletekey
349
1
xp_regdeletevalue
349
1
xp_regenumvalues
349
1
xp_regread
350
1
xp_regwrite
350
3
Index
353