S

sampled data, 540

SANs (storage area networks), 273–274

save sets, 204

SAVE TRANSACTION function, 587

scalability, 51, 448

scalar functions, 134

scale-out, 9, 212, 256–257, 261–263, 539

scale-up, 256–263, 539

Scatter-Gather I/O, 58

scheduled task events, SQLAgentMail, 93

schema access permission objects, 125

schema definition language. See Data Definition Language (DDL)

schema lock (Sch-M) mode, 492–494

SCHEMA_ID function, 587

SCHEMA_NAME function, 587

SchemaDeclaration, OpenXML, 521

Sch-M (schema lock) mode, 492–494

SCM (Service Control Manager), 17

SCOPE_IDENTITY function, 427, 587

scratch and save sets, 203–204

scroll locks, 62, 494

Search Condition predicate, 587

search conditions, 461–463, 466

secondary data files, 24, 40–41

Secondary Database Settings page, Management Studio, 237–241

secondary files, 144

secondary nodes, SQL Service Cluster, 268–269, 283

secret data, 102–103

securable argument, 134

Secure Sockets Layer (SSL), 115–116

security, 97–136

auditing, 134–135

Common Language Runtime, 332

data security, 98–107

access control, 101–102

authentication, 100–101, 105–106

Kerberos protocol, 106–107

objects and ownership, 98–100

overview, 98

security levels, 102–103

Windows security, 104–105

and executable code, 339

Kerberos tickets, 109–115

key distribution, 110–112

overview, 109–110

trusts, and login delegation, 112–115

Microsoft Certificate Services, 116–117

overview, 97–98

Secure Sockets Layer, 115–116

SQL Server access, 107–109

SQL Server security plan, 135–136

with stored procedures, 399–400

trigger code, 383, 388

trusted access versus nontrusted access, 117–118

security boundaries, 349

security identifiers (SIDs), 104–105, 126

security principals, 104–107

Securityadmin fixed server role, 122

seed, CREATE TABLE statements, 167

SELECT @local_variable function, 587

SELECT function, 587

SELECT INTO statements, 451, 458–459, 468

select into/bulkcopy option, 458–459

select lists, 452

Select Maintenance Task Order dialog box, Maintenance Plan Wizard, 207–208

SELECT statements, 451–459

and Analysis Services, 19

CAST() function in, 322

with COMPUTE clauses, 468

creation of views using, 29–30

and data ecology, 449

defined, 452–454

overview, 451–452

qualifying arguments, 454–456

and query optimization, 68–70

returning result sets, 412

search conditions, 461–463

SELECT ... INTO, 458–459

select list, 456–458

TOP expression as variable, 456

and triggers, 381

and UPDATE statements, 439

self-describing objects, 338–339

SEND function, 587

sensitive data, 102–103

sequence trees, 68

serialization, 490

Server Agent

alerts, jobs, and operators, 16–18

database engine, 87–91

and database engine administration, 75–77

dependencies on, 284

log shipping, 236

log shipping jobs, 243

overview, 81

Server attribute in fail-overs, 251–252

server clusters, 270–285

administrative software, 272–273

creating fail-over, 278–279

interactions, 284–285

limitations of, 270–271

modeling multinode, 273–278

configuring Microsoft Cluster Server, 275

naming virtual server, 277–278

network considerations, 276

other software considerations, 275

overview, 273

SQL Server 2007, 275

verifying hardware solution, 273–274

verifying operating system settings, 274

software, 271–272

step-by-step, 279–284

server cursors, 505

server platforms, 11

Server Profiler, SQL, 533–536

Serveradmin fixed server role, 122

SERVERPROPERTY function, 587

servers

federations of, 262

linked, 480–481

standby, 233

virtual, 267

server-side components, 75–77

Service Broker, 15, 17

Service Control Manager (SCM), 17

service principal names (SPNs), 114

Services Accounts dialog box, MS Cluster Service, 279

session basis locks, 491

session keys, 110–112

session tickets, 110–112

SESSION_USER function, 587

SESSIONPROPERTY function, 587

SET @local_variable function, 587

SET ANSL_DEFAULTS function, 588

SET ANSI_NULL_DFLT_OFF function, 588

SET ANSI_NULL_DFLT_ON function, 588

SET ANSI_NULLS function, 588

SET ANSI_NULLS option, T-SQL, 297

SET ANSI_PADDING function, 588

SET ANSI_PADDING option, T-SQL, 303–304

SET ANSI_WARNINGS function, 588

SET ARITHABORT function, 588

SET ARITHIGNORE function, 588

SET CONCAT_NULL_YIELDS_NULL function, 588

SET CONTEXT_INFO function, 588

SET CURSOR_CLOSE_ ON_COMMIT function, 588

SET DATEFIRST function, 588

SET DATEFORMAT function, 588

SET DEADLOCK_PRIORITY function, 588

SET DISABLE_DEF_CNST_CHK function, 588

SET FIPS_FLAGGER function, 589

SET FMTONLY function, 589

SET FORCEPLAN function, 589

SET function, 587

SET IDENTITY_INSERT function, 589

SET IMPLICIT.TRANSACTIONS function, 589

SET LANGUAGE function, 589

SET LOCK_TIMEOUT function, 589

SET NOCOUNT function, 589

SET NOEXEC function, 589

SET NUMERIC_ROUNDABORT function, 589

SET OFFSETS function, 589

SET PARSEONLY function, 589

SET QUERY_GOVERNOR_COST_LIMIT function, 589

SET QUOTED_IDENTIFIER function, 589

SET REMOTE_PROC_TRANSACTIONS function, 589

SET ROWCOUNT function, 589

SET SHOWPLAN_ALL function, 590

SET SHOWPLAN_XML function, 590

SET statements, 426, 436

SET STATISTICS IO function, 590

SET STATISTICS PROFILE function, 590

SET STATISTICS TIME function, 590

SET TEXTSIZE function, 590

SET TRANSACTION ISOLATION LEVEL function, 590

SET value, UPDATE statement, 438–439

SET XACT_ABORT function, 590

setspn utility, 114

Setup Type dialog box, MS Cluster Service, 279

Setup Wizard, 282–283

Setupadmin fixed server role, 122

SETUSER function, 587, 590

SGAMs (Shared Global Allocation Maps), 39, 42–44

SGML (Standardized General Markup Language), 508

share creation, file, 237–238

shared (S) locks, 492,494

shared assemblies, 346

Shared Global Allocation Maps (SGAMs), 39, 42–44

shared memory components, 78

shared memory model, 259–260

Shared Memory protocol, 14

shared nothing federations, 16

shared with intent exclusive (SIX) locks, 493–494

shared-disk system model, 261

share-nothing architecture, 262

shortcut menu, System Monitor, 544

SHUTDOWN function, 587, 590

side-by-side execution, 340, 349

SIDs (security identifiers), 104–105, 126

SIGN function, 588, 590

signatures, digital, 350

SignByAsymKey function, 590

SignByCert function, 590

signing constants, 293

SIGN(numeric) mathematical function, 318

simple expressions, 294

Simple Network Management Protocol (SNMP), 535

Simple Object Access Protocol (SOAP), 526–530

SIMPLE option, ALTER DATABASE statements, 157–158

simple recovery models, 185–186

SIN function, 590

SIN(float) mathematical function, 318

Single Sign-on Initiative, 107

SINGLE_USER option, 156

SIX (shared with intent exclusive) locks, 493–494

Sixty minutes loss (60) tolerance, 183

Sixty minutes wait (60) restoration, 183

SIZE keyword, 148, 154–155

smalldatetime data type, 302, 572, 590

smallint data type, 581, 590

smallint integers, 301

smallmoney data type, 302, 582, 590

smart card readers, 101

Smee’s component, 340

SMP (symmetric multiprocessing), 51, 259–260

snapshot backups, 189,192

snapshot counters, 554

snapshot files, 139, 277

Snapshot Folder, Management Studio, 226–227

snapshot replication, 214, 216–217, 231

SNMP (Simple Network Management Protocol), 535

SOAP (Simple Object Access Protocol), 526–530

soft mirror errors, 249–250

software

modeling multinode server clusters, 275

pager-to-e-mail, 90

software scale out and scale up, 9

SOME | ANY function, 590

SOME keywords, 463

SOME logical operator, 298

sorted data, 33

SOUNDEX algorithm values, 313

SOUNDEX function, 315, 590

source servers. See mirroring

sp_add_alert stored procedure, 591

sp_add_category stored procedure, 592

sp_add_data_file_recover_suspect_db stored procedure, 592

sp_add_job stored procedure, 592

sp_add_jobschedule stored procedure, 592

sp_add_jobserver stored procedure, 592

sp_add_jobstep stored procedure, 592

sp_add_log_file_recover_suspect_db stored procedure, 592

sp_add_log_shipping_databasestored procedure, 592

sp_add_log_shipping_plan stored procedure, 593

sp_add_log_shipping_plan_databasestored procedure, 593

sp_add_log_shipping_primary stored procedure, 593

sp_add_log_shipping_secondary stored procedure, 593

sp_add_maintenance_plan stored procedure, 593

sp_add_maintenance_plan_dbstored procedure, 593

sp_add_maintenance_plan_job stored procedure, 593

sp_add_notification stored procedure, 593

sp_add_operator stored procedure, 593

sp_add_targetservergroup stored procedure, 593

sp_add_targetsvrgrp_member stored procedure, 593

sp_addalias stored procedure, 591

sp_addapprole stored procedure, 591

sp_addextendedproc stored procedure, 592

sp_addextendedproperty stored procedure, 592

sp_addgroup stored procedure, 592

sp_addlinkedserver stored procedure, 592

sp_addlinkedsrvlogin stored procedure, 592

sp_addlogin stored procedure, 592

sp_addmessage stored procedure, 593

sp_addremotelogin stored procedure, 593

sp_addrole stored procedure, 593

sp_addrolemember stored procedure, 593

sp_addserver stored procedure, 593

sp_addsrvrolemember stored procedure, 593

sp_addtask stored procedure, 593

sp_addtype stored procedure, 593

sp_addump stored procedure, 593

sp_adduser stored procedure, 593

sp_altermessage stored procedure, 593

sp_apply_job_to_targets stored procedure, 594

sp_approlepassword stored procedure, 594

sp_attach_db stored procedure, 594

sp_attach_single_file_db stored procedure, 594

sp_autostats stored procedure, 594

sp_bindefault stored procedure, 594

sp_bindrule stored procedure, 594

sp_bindsession stored procedure, 594

sp_can_tlog_be_applied stored procedure, 594

sp_catalogs stored procedure, 594

sp_certify_removable stored procedure, 594

sp_change_monitor_role stored procedure, 594

sp_change_primary_role stored procedure, 594

sp_change_secondary_role stored procedure, 594

sp_change_users_login stored procedure, 594

sp_changedbowner stored procedure, 594

sp_changegroup stored procedure, 595

sp_changeobjectowner stored procedure, 595

sp_column_privileges stored procedure, 595

sp_column_privileges_ex stored procedure, 595

sp_columns stored procedure, 595

sp_columns_ex stored procedure, 595

sp_configure stored procedure, 352, 392–393, 595

sp_create_log_shipping_monitor_account stored procedure, 595

sp_create_removable stored procedure, 595

sp_createstats stored procedure, 595

sp_cursor_list stored procedure, 595

sp_cycle_errorlog stored procedure, 596

sp_databases stored procedure, 596

sp_datatype_info stored procedure, 596

sp_dbcmptlevel stored procedure, 596

sp_dbfixedrolepermission stored procedure, 596

sp_dboption stored procedure, 392–393, 459, 596

sp_dbremove stored procedure, 596

sp_defaultdb stored procedure, 596

sp_defaultlanguage stored procedure, 596

sp_define_log_shipping_monitor stored procedure, 596

sp_delete_alert stored procedure, 596

sp_delete_backuphistory stored procedure, 596

sp_delete_category stored procedure, 596

sp_delete_job stored procedure, 596

sp_delete_jobschedule stored procedure, 596

sp_delete_jobserver stored procedure, 596

sp_delete_jobstep stored procedure, 596

sp_delete_log_shipping_databasestored procedure, 597

sp_delete_log_shipping_plan stored procedure, 597

sp_delete_log_shipping_plan_database stored procedure, 597

sp_delete_log_shipping_primary stored procedure, 597

sp_delete_log_shipping_secondary stored procedure, 597

sp_delete_maintenance_plan stored procedure, 597

sp_delete_maintenance_plan_db stored procedure, 597

sp_delete_maintenance_plan_job stored procedure, 597

sp_delete_notification stored procedure, 597

sp_delete_operator stored procedure, 597

sp_delete_targetserver stored procedure, 597

sp_delete_targetservergroup stored procedure, 597

sp_delete_targetsvrgrp_member stored procedure, 597

sp_denylogin stored procedure, 597

sp_depends stored procedure, 401, 597

sp_describe_cursor stored procedure, 597

sp_describe_cursor_columns stored procedure, 597

sp_describe_cursor_tables stored procedure, 597

sp_detach_dbsp_dropalias stored procedure, 597

sp_dropapprole stored procedure, 598

sp_dropdevice stored procedure, 598

sp_dropextendedproc stored procedure, 598

sp_dropextendedproperty stored procedure, 598

sp_dropgroup stored procedure, 598

sp_droplinkedsrvlogin stored procedure, 598

sp_droplogin stored procedure, 598

sp_dropmessage stored procedure, 598

sp_dropremotelogin stored procedure, 598

sp_droprole stored procedure, 598

sp_droprolemember stored procedure, 598

sp_dropserver stored procedure, 598

sp_dropsrvrolemember stored procedure, 598

sp_droptask stored procedure, 598

sp_droptype stored procedure, 598

sp_dropuser stored procedure, 598

sp_dropwebtask stored procedure, 598

sp_enumcodepages stored procedure, 598

sp_executesql stored procedure, 429, 443, 599

sp_fkeys stored procedure, 599

sp_foreignkeys stored procedure, 599

sp_fulltext_catalog stored procedure, 599

sp_fulltext_column stored procedure, 599

sp_fulltext_database stored procedure, 599

sp_fulltext_service stored procedure, 599

sp_fulltext_table stored procedure, 599

sp_get_log_shipping_monitor_infostored procedure, 599

sp_getapplock stored procedure, 599

sp_getbindtoken stored procedure, 599

sp_grantdbaccess stored procedure, 599

sp_grantlogin stored procedure, 599

sp_help stored procedure, 599

sp_help_alert stored procedure, 599

sp_help_category stored procedure, 599

sp_help_downloadlist stored procedure, 600

sp_help_fulltext_catalogs stored procedure, 600

sp_help_fulltext_catalogs_cursor stored procedure, 600

sp_help_fulltext_columns stored procedure, 600

sp_help_fulltext_columns_cursor stored procedure, 600

sp_help_fulltext_tables stored procedure, 600

sp_help_fulltext_tables_cursor stored procedure, 600

sp_help_job stored procedure, 601

sp_help_jobhistory stored procedure, 601

sp_help_jobschedule stored procedure, 601

sp_help_jobserver stored procedure, 601

sp_help_jobstep stored procedure, 601

sp_help_maintenance_plan stored procedure, 601

sp_help_notification stored procedure, 601

sp_help_operator stored procedure, 601

sp_help_targetserver stored procedure, 602

sp_help_targetservergroup stored procedure, 602

sp_helpconstraint stored procedure, 600

sp_helpdb stored procedure, 600

sp_helpdbfixedrole stored procedure, 600

sp_helpdevice stored procedure, 600

sp_helpextendedproc stored procedure, 600

sp_helpfile stored procedure, 600

sp_helpfilegroup stored procedure, 142,600

sp_helpgroup stored procedure, 600

sp_helphistory stored procedure, 600

sp_helpindex stored procedure, 601

sp_helplanguage stored procedure, 601

sp_helplinkedsrvlogin stored procedure, 601

sp_helplogins stored procedure, 601

sp_helpntgroup stored procedure, 601

sp_helpremotelogin stored procedure, 601

sp_helprole stored procedure, 601

sp_helprolemember stored procedure, 601

sp_helprotect stored procedure, 601

sp_helpserver stored procedure, 602

sp_helpsort stored procedure, 602

sp_helpsrvrole stored procedure, 602

sp_helpsrvrolemember stored procedure, 602

sp_helpstats stored procedure, 602

sp_helptask stored procedure, 602

sp_helptext stored procedure, 401, 414–415, 602

sp_helptrigger stored procedure, 394–395, 602

sp_helpuser stored procedure, 602

sp_indexes stored procedure, 602

sp_indexoption stored procedure, 602

sp_invalidate_textptr stored procedure, 602

sp_linkedservers stored procedure, 602

sp_lock stored procedure, 495, 534, 602

sp_makewebtask stored procedure, 602

sp_manage_jobs_by_login stored procedure, 602

sp_monitor stored procedure, 534, 602

sp_MShasdbaccess stored procedure, 603

sp_msx_defect stored procedure, 603

sp_msx_enlist stored procedure, 603

sp_OACreate stored procedure, 603

sp_OADestroy stored procedure, 603

sp_OAGetErrorInfo stored procedure, 603

sp_OAGetProperty stored procedure, 603

sp_OAMethod stored procedure, 603

sp_OASetProperty stored procedure, 603

sp_OAStop stored procedure, 603

sp_password stored procedure, 603

sp_pkeys stored procedure, 603

sp_post_msx_operation stored procedure, 603

sp_primarykeys stored procedure, 603

sp_processmail stored procedure, 603

sp_procoption stored procedure, 414, 603

sp_purge_jobhistory stored procedure, 603

sp_purgehistory stored procedure, 603

sp_reassigntask stored procedure, 603

sp_recompile stored procedure, 603

sp_refreshview stored procedure, 604

sp_releaseapplock stored procedure, 604

sp_remoteoption stored procedure, 604

sp_remove_job_from_targets stored procedure, 604

sp_remove_log_shipping_monitor stored procedure, 604

sp_rename stored procedure, 604

sp_renamedb stored procedure, 604

sp_resetstatus stored procedure, 604

sp_resolve_logins stored procedure, 604

sp_resync_targetserver stored procedure, 604

sp_revokedbaccess stored procedure, 604

sp_revokelogin stored procedure, 604

sp_runwebtask stored procedure, 604

sp_server_info stored procedure, 604

sp_serveroption stored procedure, 604

sp_setapprole stored procedure, 604

sp_setnetname stored procedure, 604

sp_settriggerorder stored procedure, 392, 605

sp_spaceused stored procedure, 534, 605

sp_special_columns stored procedure, 605

sp_sproc_columns stored procedure, 605

sp_srvrolepermission stored procedure, 605

sp_start_job stored procedure, 605

sp_statistics stored procedure, 605

sp_stop_job stored procedure, 605

sp_stored_procedures stored procedure, 605

sp_table_privileges stored procedure, 605

sp_table_privileges_ex stored procedure, 605

sp_tableoption stored procedure, 605

sp_tables stored procedure, 605

sp_tables_ex stored procedure, 605

sp_trace_create stored procedure, 605

sp_trace_generateevent stored procedure, 605

sp_trace_setevent stored procedure, 606

sp_trace_setfilter stored procedure, 606

sp_trace_setstatus stored procedure, 606

sp_unbindefault stored procedure, 606

sp_unbindrule stored procedure, 606

sp_update_alert stored procedure, 606

sp_update_category stored procedure, 606

sp_update_job stored procedure, 606

sp_update_jobschedule stored procedure, 606

sp_update_jobstep stored procedure, 606

sp_update_log_shipping_monitor_infostored procedure, 606

sp_update_log_shipping_planstored procedure, 606

sp_update_log_shipping_plan_database stored procedure, 606

sp_update_notification stored procedure, 606

sp_update_operator stored procedure, 606

sp_update_targetservergroup stored procedure, 606

sp_updateextendedproperty stored procedure, 606

sp_updatestats stored procedure, 606

sp_updatetask stored procedure, 606

sp_validatelogins stored procedure, 607

sp_validname stored procedure, 607

sp_who stored procedure, 534, 607

sp_xml_preparedocument stored procedure, 607

sp_xml_removedocument stored procedure, 607

space allocation, 42–44

SPACE function, 316, 591

spindles, 553

SPNs (service principal names), 114

spreadsheets, 26

SQL (Structured Query Language), 12–14

SQL Mail, 91–93

SQL Management Objects architecture (SQL-SMO). See Management Objects architecture, SQL (SQL-SMO)

SQL Management Studio. See Management Studio

SQL Profiler. See Profiler, SQL

SQL Server 2007, 3–20

administrative architecture, 81–82

analyzing bottlenecks on, 555

authentication modes, 107–109

automated administration architecture, 86–87

central design themes, 10

cluster design, 264–268

collateral services, 16–20

connections, 78–81

core architectures, 10–16

application development, 12–14

client/server, 14–16

database, 11–12

DBMs or administration, 12

overview, 10

database engine tools, 82–83

distributed network applications, 7–9

keywords, 27–28

line-of-business applications, 7

mailing engines, 91–93

Net-Libraries, 78–81

versus other relational database products, 3–7

overview, 3, 9

scale-up/scale-out, 261–263

Service Broker technology, 15

and XML, 508–509

SQL Server Agent. See Server Agent

SQL Server Analysis Services (SSAS), 17

SQL Server Books Online, 559

SQL Server Integration Services (SSIS), 17, 213, 220, 431

SQL Server Notification Services (SSNS), 17

SQL Server Profiler, 533–537

SQL Server Reporting Services (SSRS), 17

SQL Statistics SQL Server object, 547–548

SQL_OPTION section, 157

sql_variant data type, 305–306, 591

SQL_VARIANT_PROPERTY function, 591

SQLAgentMail, 92–93

SQLCMD utility, 83

<sql:header> tags, 519

<sql:param> elements, 519, 522

SqlPipe construct, 419

SQL/PSM (SQL persistent storage module), 13–14

<sql:query> elements, 519, 522

SQL-SMO (SQL Management Objects architecture). See Management Objects architecture, SQL (SQL-SMO)

SQRT function, 591

SQRT(float) mathematical function, 318

square brackets, 453

SQUARE function, 318, 591

SSAS (SQL Server Analysis Services), 17

SSIS (SQL Server Integration Services), 17, 213, 220, 431

SSL (Secure Sockets Layer), 115–116

SSL TLS (Secure Sockets Layer Transport Layer Security), 115–116

SSNS (SQL Server Notification Services), 17

SSRS (SQL Server Reporting Services), 17

stack space, 56

Standardized General Markup Language (SGML), 508

standards, Internet, 8

standby servers, 233–235, 244, 261, 266–267

star (*) operators, 448, 457, 460

start tags, 511

startup stored procedures, 413–414

state_option section, 156

statement parser, 68

static assemblies, 345

static filters, 219

static load balancing, 263–264

STATS_DATE function, 591

status statements, DBCC, 557

STDEV aggregate function, 319

STDEV COMPUTE argument, 468

STDEV function, 591

STDEVP COMPUTE argument, 468

STDEVP function, 319, 591

storage, cluster, 270–271

storage area networks (SANs), 273–274

storage engine, 51, 68–69

stored procedures, 399–420

automatically executing, 413–414

calling, 409–410

creation of, 405–409

for database reports, 149

and domain integrity, 362

effects in client tier, 385

example, 415–17

managing, 414–415

nesting, 412

nuances of, 401–402

and on-the-fly results sets, 451

overview, 399–400

plans for, 402–405

procedures and functions on CLR, 418–420

receiving data from, 411–412

rolling back, 412

securing with GRANT, DENY, or REVOKE, 134

sending data to, 410–411

sp_bdoption, 392–393

sp_configure, 352, 392–393

sp_dboption, 459

sp_executesql, 429, 443

sp_helpfilegroup, 142

sp_helptrigger, 394–395

sp_lock system, 495

sp_settriggerorder, 392

SQL Mail, 92

SQL Profiler, 534

temporary, 413

versus triggers, 379

and T-SQL for DBAs, 82

types of, 401

user defined functions in T-SQL, 417

stored queries, 477

STR function, 316, 591

String Concatenation (+) operator, 559

string concatenation operator, 298

string manipulation functions, 311–317

ASCII (character), 311

CHARXNDEX (expression1, expression2, startlocation), 312

CHAR (integer), 311

DATALENGTH(variable expression), 312–313

DIFFERENCE (expression1, expression2), 313

LEFT (string, startindex), 313

LEN (string), 313

LOWER (string), 313–314

LTRIM (string), 314

NCHAR (integer), 314

overview, 311

QUOTENAME (string, quote character), 314

REPLACE (‘expression1’, ‘expression?, ‘expression3’), 314

REPLICATE (character, integer), 315

REVERSE (string), 315

RIGHT (string, integer), 315

RTRIM (string expression), 315

SOUNDEX (string expression), 315

SPACE (value), 316

STR (float expression, length, decimal), 316

STUFF (string expression, start, length, ch expression), 316

SUBSTRING (string expression, start, length), 316–317

UNlCODE (unicode expression), 317

UPPER (character expression), 317

strong name identifiers, 349–351

Structured Query Language. See SQL (Structured Query Language)

STUFF function, 316, 591

style arguments, 322, 324

subqueries, 294, 463

Subscribers component, SQL Server replication services, 215

subscription component, SQL Server replication services, 216

subscriptions

push and pull, 232

updatable, 219–220

SUBSTRING function, 316–317, 591

Subtract (−) operator, 559

Subtract (-) operators, 295

SUM aggregate function, 319

SUM COMPUTE argument, 468

SUM function, 591

Super Socket Net-Library, 79

SUSER_ID function, 591

SUSER_NAME function, 591

SUSER_SID function, 591

SUSER_SNAME function, 591

symmetric multiprocessing (SMP), 51, 259–260

SYMMETRICKEY function, 583

<sync> XML elements, 523–524

synchronized mirroring, 244,246

sysadmin fixed server roles, 122, 165, 442

sys.dm_tran_locks stored procedure, 534

system administrators, 101

system databases, 22

System Monitor, 533, 535–536, 543–544, 556

system roles, built-in, 118

system stored procedures, 401, 591

SYSTEM_USER statement, 607

system.data.dll assembly, 352

system-level data structures, 56

system-supplied values, 426–428