+612 9045 4394
 
CHECKOUT
SQL Server 2000 : Survival Guide for System Administrators - Harshad Nadkarni

SQL Server 2000

Survival Guide for System Administrators

Paperback Published: 1st January 2001
ISBN: 9780072130973
Number Of Pages: 388

Share This Book:

Paperback

RRP $98.00
$74.50
24%
OFF
Ships in 7 to 10 business days

"Call on Admin911 to learn what's going on with your network, to understand your options, and pick the right solutions." --David Chernicoff, Windows 2000 MagazineThis survival guide for SQL Server 2000 administrators explains how to implement preventive problem-solving strategies and minimize downtime. Helpful call-outs throughout the book include: Take Command--Specific command-line utilities relating to the topic at handCode Blue--Things to do when your system is in troubleBug Alert--Common and little-know problems and pitfallsThis book will also help you: *Manage SQL Server, including memory and security*Optimize and automate administration using SQL Server Agent and other tools*Debug Jobs*Monitor and tune SQL Server unsing the system monitor and alerts*Optimize T-SQL and stored procedures*Scale SQL Server using linked servers and Distributed Partitioned Views*Troubleshoot database performance*Implement disaster recovery procedures.

"Call on Admin911 to learn what's going on with your network, to understand your options, and to pick the right solutions." -David Chemicoff, Windows 2000 Magazine"

Acknowledgmentsp. xiv
Architecture and Installationp. 1
SQL Server's Rootsp. 2
Architecture Overviewp. 3
Net-Libraryp. 3
Open Data Servicesp. 3
The SQL Server Enginesp. 4
Installation Tipsp. 4
SQL Server 2000 Editionsp. 7
Preinstallation Decisionsp. 9
Removing SQL Serverp. 12
Starting SQL Server and Agentp. 12
Upgrading from SQL Server 4.2p. 13
Upgrading from SQL Server 6.0 or 6.5p. 14
Upgrading from SQL Server 7.0p. 15
Upgrading Stored Proceduresp. 17
Tricks and Tips for Upgradingp. 17
Files and Directoriesp. 19
Moving the Tools Directoryp. 20
Managing SQL Serverp. 21
Managing the Serverp. 22
Managing Multiple Instancesp. 22
Renaming a Serverp. 23
Tweaking Configuration Optionsp. 24
Managing the Databasep. 31
Tweaking Database Configuration Optionsp. 32
Managing Securityp. 38
Common Security Concernsp. 39
Avoiding Dangerous Settingsp. 41
Deploying Your Databasep. 43
Service Packsp. 44
Optimizing and Automating SQL Server Administrationp. 45
Startup Stored Proceduresp. 46
SQL Mailp. 47
Configuring SQL Mailp. 47
xp_sendmailp. 49
Other Mailer Optionsp. 50
Optimizing SQL Server Agentp. 51
General Tab Optionsp. 51
Advanced Tab Optionsp. 52
Alert System Tab Optionsp. 52
Job System Tabp. 53
Connection Tabp. 53
Operatorsp. 54
Adding an Operatorp. 54
Scripting Operatorsp. 55
Jobsp. 57
Creating Jobsp. 58
Job Categoriesp. 60
Debugging Jobsp. 60
Scripting Jobsp. 61
Centralized Administrationp. 61
Managing Multi Server Jobsp. 61
Creating a Multi Server Jobp. 62
Administering DTSp. 63
DTS Connectionsp. 64
Saving a Packagep. 65
Managing Package Versionsp. 66
Securing a Packagep. 67
Executing Packagesp. 68
Managing Package Locationsp. 69
Using DTSRunUIp. 70
Scheduling a Packagep. 70
Optimizing Packagesp. 71
DTS Without SQL Serverp. 74
Troubleshooting DTSp. 75
Monitoring and Tuning SQL Serverp. 79
Managing Messagesp. 80
Error Message Severity Levelsp. 81
Raising an Errorp. 82
xp_logeventp. 83
System Monitorp. 83
Adding Countersp. 84
Performance Counters to Watchp. 86
System Monitor Loggingp. 87
Viewing Performance Logsp. 89
sp_monitorp. 90
Trace Flagsp. 91
Setting Trace Flagsp. 91
Alertsp. 94
Creating an Alertp. 94
Setting Performance Alertsp. 96
Setting Job Notificationsp. 96
Forecasting Growthp. 97
Database Growth Reportsp. 97
sqldiagp. 99
Black Boxp. 99
Automating Administrative Tasksp. 101
Query Analyzerp. 102
Command-Line Optionsp. 102
Distributing Configuration Filesp. 104
Object Browserp. 104
Getting Around the 256-Character Limitp. 104
Shortcut Queriesp. 105
Finding Objectsp. 106
Templatesp. 106
Creating Your Own Templatesp. 107
Administrative T-SQLp. 108
Simplifying Cursorsp. 108
Extended Stored Proceduresp. 111
Administrative DBCC Commandsp. 119
System Functionsp. 127
Working with Identitiesp. 130
Extended Propertiesp. 135
OLE Automationp. 140
Alternate Method of Counting Recordsp. 144
Optimizing and Troubleshooting SQL Serverp. 147
Optimizing Windows 2000 Networks for SQL Serverp. 148
Optimizing Operating System Componentsp. 148
Optimizing Network Settingsp. 149
Optimizing Name Resolutionp. 151
Registry Dependenciesp. 154
Rebuilding SQL Registry Entries After Reinstalling Windowsp. 155
Using Registry Server Listingsp. 155
Managing and Configuring the Databasep. 156
Monitoring Growthp. 156
Disconnecting Usersp. 157
Model Databasep. 159
Database Standardsp. 159
Naming Conventionsp. 160
Numeric Data Type Decisionsp. 162
Character Data Typesp. 163
Performance Tuning Your Database Modelp. 164
Row Sizep. 165
Text, ntext, and image Fieldsp. 167
Minimizing Wasted Column Spacep. 168
Summarizing Datap. 169
Using Sample Datap. 169
Using a Cross Joinp. 169
Optimizing Stored Proceduresp. 172
Determining Parameters for Stored Proceduresp. 172
Troubleshooting Cached Stored Proceduresp. 173
Tuning Stored Procedure Performancep. 174
Building Dynamic Stored Proceduresp. 174
Using Temporary Tablesp. 175
Table Data Types for Temporary Tablesp. 176
Using the Tempdb Databasep. 177
Performance Tuning T-SQLp. 178
Performance Tips for Queriesp. 179
Non-logged SQL Statementsp. 180
Returning Top Rowsp. 180
Ordering Viewsp. 181
Quoted Identifiersp. 182
Read-Only Databasesp. 183
Optimizing Indexesp. 184
Optimizing Index Fill Factorsp. 184
Using DBCC SHOWCONTIGp. 185
Defragging Indexesp. 189
Using the Index Tuning Wizardp. 190
SQL Server Profilerp. 191
Web Troubleshooting Resourcesp. 195
Disaster Planning and Recoveryp. 197
Developing a Planp. 198
Third-Party Backup Programsp. 198
Types of Backupsp. 199
Full Backups in Enterprise Managerp. 199
Full Backups in T-SQLp. 204
Configuring Devices with T-SQLp. 206
Differential Backupsp. 206
Transaction Log Backupsp. 207
Transaction Log Backups in T-SQLp. 207
Backing Up Individual Files and File Groupsp. 208
Backupset Tablep. 209
Optimizing Backup and Restore Performancep. 209
Database Recovery Modelsp. 210
Simple Recovery Modelp. 211
Full Recovery Modelp. 212
Bulk Recovery Modelp. 212
Recovery Optionsp. 213
Maintenance Plansp. 213
Using sqlmaintp. 214
Using xp_sqlmaintp. 216
Restoringp. 216
Full Database Restoresp. 217
Full Restore in T-SQLp. 219
Differential Database Restoresp. 222
Transaction Log Restoresp. 223
Point-In-Time Scenariosp. 224
Fixing Broken Loginsp. 224
Using sp_change_users_loginp. 225
Recovering a Corrupt Master Databasep. 226
Rebuilding Other Databasesp. 227
Detaching and Attaching a Databasep. 227
Detaching a Databasep. 228
Other Methods of Copying Data Filesp. 229
Attaching a Databasep. 230
Uninstalling SQL Server or Upgrading from an Evaluation Editionp. 232
Scaling SQL Serverp. 233
Linked Serversp. 234
Data Flow of Linked Serversp. 234
Myriad Uses for Linked Serversp. 235
Creating a Linked Server in Enterprise Managerp. 236
Creating a Linked Server Through T-SQLp. 239
Linked Server Securityp. 241
Configuring the Linked Serverp. 245
Configuring Linked Servers Through T-SQLp. 247
Linked Servers Between Heterogeneous Databasesp. 247
Deleting a Linked Serverp. 250
Querying Linked Serversp. 250
Joining Multiple Serversp. 251
Executing Stored Procedures on Linked Serversp. 252
Getting Verbose Error Messagesp. 253
Tuning and Supporting Linked Serversp. 256
Distributed Partitioned Viewsp. 259
DPV Architecturep. 259
Preparing for a DPVp. 261
Setting Up and Using the Partitioned Viewsp. 263
Inserting Data into the Partitioned Viewp. 264
Querying a Partitioned Viewp. 266
Updating a Partitioned Viewp. 266
DPV Limitationsp. 267
Indexed Viewsp. 268
Indexed Views Requirements and Restrictionsp. 268
Creating an Indexed Viewp. 271
Querying Indexed Viewsp. 273
SQL Server Replicationp. 275
SQL Server Replicationp. 276
Replication Considerationsp. 276
Replication Architecturep. 277
Heterogeneous Support for Replicationp. 279
Understanding the Types of Replicationp. 280
Snapshot Replicationp. 280
Merge Replicationp. 282
Transactional Replicationp. 283
Bidirectional Replicationp. 284
Configuring SQL Server Agent Replicationp. 285
Preinstallation Concernsp. 285
Data Types Concernsp. 286
Dealing with Identity Columnsp. 287
Initial Replication Setupp. 289
Customizing the Initial Installationp. 291
Disabling Replicationp. 294
Snapshot/Transactional Replication Setupp. 295
Merge Replication Setupp. 302
Creating Subscriptionsp. 305
Merge Replication Subscriptionsp. 306
Configuring Replication After the Wizardp. 306
Schema Changes in Replicationp. 308
sp_repladdcolumnp. 308
sp_repldropcolumnp. 310
Monitoring and Troubleshooting Replicationp. 310
Troubleshooting Agentsp. 311
Recovering from a Disasterp. 312
Optimizing Replicationp. 312
System Tables and Undocumented DBCC Commandsp. 315
System Tablesp. 316
Tables in Master Database Onlyp. 316
Tables in Every Databasep. 326
Undocumented DBCC Commandsp. 334
Extended Stored Proceduresp. 341
xp_availablemediap. 342
xp_cmdshellp. 342
xp_dirtreep. 343
xp_enum_activescriptenginesp. 343
xp_enum_oledb_providersp. 343
xp_enumcodepagesp. 344
xp_enumdsnp. 344
xp_enumerrorlogsp. 345
xp_enumgroupsp. 345
xp_fileexistp. 345
xp_fixeddrivesp. 346
xp_getfiledetailsp. 346
xp_getnetnamep. 347
xp_loginconfigp. 347
xp_logeventp. 347
xp_logininfop. 348
xp_ntsec_enumdomainsp. 348
xp_readerrorlogp. 348
xp_regdeletekeyp. 349
xp_regdeletevaluep. 349
xp_regenumvaluesp. 349
xp_regreadp. 350
xp_regwritep. 350
Indexp. 353
Table of Contents provided by Syndetics. All Rights Reserved.

ISBN: 9780072130973
ISBN-10: 0072130970
Series: Admin911 Series
Audience: Professional
Format: Paperback
Language: English
Number Of Pages: 388
Published: 1st January 2001
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 22.23 x 18.42  x 2.54
Weight (kg): 0.75