S

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

SAC (Surface Area Configuration) tool
SAFE setting (CLR executables)
saving Visual Studio custom configurations
scalability
     application design
     architectures
     SQL Server Express Edition
Scalar Functions 2nd
SchemaOnly Command Behavior (ExecuteReader function)
schemas
     SQL Server 2nd
scope
    for connections
         selecting
     object instantiation
scripts
    CLRtest scripts
         creating
         executing
security
     application design
     CLR executables
     connection pools
     ConnectionStrings 2nd
     data restoration
     hackers
     of connections
         selecting connection strategy
     Slammer worm
     SQL Server
         addressing objects
         authentication
         authorization
         connections
         logins 2nd
         object ownership
         overview of
         ownership chains
         roles
         schemas
         security personas
         special accounts
         usernames
     SQL Server Express Edition 2nd
     SQLEv (SQL Server Everywhere Edition)
     SQLinjection attacks, preventing
security personas, creating
SELECT queries
     CLR UDTs (user-defined types)
     creating
     executing
     generating with Query Designer
     JOIN behavior
     joins 2nd
         Cartesian products
         inner joins
         outer joins
     limiting number of rows returned
     ORDER BY clause
     ordering rows returned
     parameters
     WHERE clause
SELECT statement
     creating cursors with
     SELECT INTO
SelectCommand object
SelectCommand property (SqlDataAdapter class)
selecting [See choosing, application architectures.]
SequentialAccess CommandBehavior (ExecuteReader function)
serialization
Server Explorer
     assemblies, managing
     CLR executables, viewing
     compared to SQL Server Object Explorer
     configuring
     creating databases with
     database connections
    Database Diagrams
         creating
         definition of
    servers
         managing
         registering
    stored procedures
         creating complex stored procedures
         creating simple stored procedures
         CustomerByState 2nd
         CustomerUpdate1
         debugging against local instances
         debugging from code
         debugging on remote instances
         debugging with breakpointss
         executing with Run Selection feature
         naming
     Synonyms
     T-SQL Functions
         advantages of
         Inline Functions
         return values
         Scalar Functions
         structure of
         Table Functions
     tables, editing
     UDTs (user-defined types), creating
Server Explorer command (View menu)
server name keyword
server reports
     accessing on Reporting Services
     methods and functions
     parameters 2nd
     rendering
     ServerReport class
server-side cursors
     ADO.NET implementation of
     creating
     disadvantages of
     dynamic cursors
     fetching data from
     fetching entire cursor
     forward-only cursors
     importance of
     keyset cursors
     managing
     opening, closing, and reopening connections
     static cursors
     updating
server-side logic updates
     executing with RowUpdating event
     overview of
     UpdateEvent sample application
         CustomerUpdate stored procedure
         DataRow versions
         Update application
         Update method
ServerReport class [See server reports, accessing on Reporting Services.]
ServerReport property (Report Viewer class)
servers [See also client/server architectures, advantages/disadvantages; SQL Server, action commands.]
     competing demands on
     definition of 2nd
     finding for establishing connections
     managing with Server Explorer
     registering with Server Explorer
Service Accounts (SQL Server)
Service Packs 2nd
services
     connecting to service instances
     inspecting
     starting
     viewing with Server Explorer
SET DEFAULT constraint
SET NULL constraint
SetDataSourceCredentials method
SetParameters method 2nd
Setup program (SQL Server)
Setup program (Visual Studio)
sharing
     in SQLEv (SQL Server Everywhere Edition)
     MDAC stack
     shareable components, building
     shared code performance
     Shared Memory
ShowCredentialPrompts property (Report Viewer class)
ShowDocumentMapButton property (Report Viewer class)
ShowExportControls property (Report Viewer class)
ShowFindControlsproperty (Report Viewer class)
ShowPageNavigationControls property (Report Viewer class)
ShowPrintButton property (Report Viewer class)
ShowPromptAreaButton property (Report Viewer class)
ShowRefreshButton property (Report Viewer class)
ShowReportBody property (Report Viewer class)
ShowToolbar property (Report Viewer class)
ShowZoomControl property (Report Viewer class)
Simple Object Access Protocol (SOAP)
SingleResult CommandBehavior (ExecuteReader function)
SingleRow CommandBehavior (ExecuteReader function) 2nd
SKUs (stock-keeping units)
Slammer worm 2nd
Sleep function
smalldatetime data type
smallint data type
smallmoney data type
Smart Tags
SNC (SQL Server Native Client)
SOAP (Simple Object Access Protocol)
SoftConnectsPerSecond performance counter
SoftDisconnectsPerSecond performance counter
Sort property
     BindingSource class
     DataView class
sp_addextendedproperty stored procedure
sp_dropextendedproperty stored procedure
sp_prepexec stored procedure
sp_updateextendedproperty stored procedure
special accounts (SQL Server)
specifications (project)
SQL engine (SQLEv)
SQL injection attacks
SQL pane (Query Designer)
SQL Profiler
     Application Name property
     CLR executable performance, evaluating
     configuring
     evaluating traces
     filter criteria, adding
     profiling CLR executable deployment process 2nd
     starting traces 2nd
     tips and recommendations
SQL Server
     action commands
         INSERT
         UPDATE
     administrative functions
         Auto Close option
         backups
         importing/exporting data
         .MDF database files, attaching
     batches
     buffer cache
    business rules
         extended properties
         overview of
         T-SQL Rules
    CLR executables [See CLR executables, ADO.NET.]
     comparison of editions
     Configuration Manager 2nd
    connections [See connections, client/server connection management.]
     constraints
     costs
     Developer Edition
     Enterprise Edition
    Express Edition
         administration 2nd
         capabilities
         common instances
         configuring as server
         crippled features
         database deployment
         default instances
         deployment
         eployment
         independent instances
         overview of 2nd
         performance 2nd
         replication
         scalability 2nd
         security 2nd
         Service Packs 2nd
         System Administrator's password
         tools 2nd
         user instances
     ExpressAdvanced Services Edition
     Identity values, managing
     installing
         Advanced Services options
         authentication mode
         collating sequences
         instance names
         quiet installs
         Service Account
         Setup program
         User Instances, enabling
    instances
         multiple instances
         overview of
     logins
     Management Studio
         CLR executables, viewing
         creating queries
         stored procedure management
    monitoring with performance counters
         activating performance counters
         selecting counters
         SqlClient performance counters
    monitoring with SQL Profiler
         Application Name property
         configuring
         evaluating traces
         evaluting CLR executable performance
         filter criteria, adding
         profiling CLR executable deployment process
         starting traces
         tips and recommendations
     object addressing
     Object Explorer
     object ownership
     overview of
     ownership chains
     performance
     QO (Query Optimizer)
    queries [See queries, ad hoc queries, integrating into applications.]
     Query plans
         cached Query plans
         client statistics and alternate plans
         executing
         tuning
         viewing
    Reporting Services [See Reporting Services, architecture.]
     roles
     schemas
     scripts
     security
         addressing objects
         authentication
         authorization
         connections
         injection attacks
         logins
         object ownership
         overview of
         ownership chains
         roles
         schemas
         security personas
         special accounts
         usernames
    services
         connecting to service instances
         inspecting
         starting
     special accounts
    SQLEv (SQL Server Everywhere Edition)
         implementation
         overview of
         programming and maintenance
         security
         sharing and replication
         SQL Server tools
         SQLEngine
         Visual Studio support
     Standard Edition
    statements [See statements, ALTER PROCEDURE.]
    stored procedures [See stored procedures.]
     system databases
     TDS (Tabular Data Stream)
     transaction logs
     transactions
     triggers
         DDL triggers
         DML triggers
     UDTs (user-defined datatypes)
     user databases
         creating
         managing
     usernames
     views
         creating
         Database Snapshots
         indexes
         T-SQL views
     Workgroup Edition 2nd
SQL Server Everywhere 2nd
SQL Server Everywhere Edition [See SQLEv (SQL Server Everywhere Edition), implementation.]
SQL Server Management Studio
SQL Server Native Client (SNC)
sql_variant data type
sql_variant datatype
SqlBulkCopy class
SqlClient namespace
     ADO.NET performance counters
     overview of 2nd
     SqlBulkCopy class
     SQLClientFactory class
     SqlCommand class
     SqlConnection class
     SqlConnectionStringBuilder class
     SqlDataAdapter class
         Fill method
         properties
         Update method
         updates
     SqlDataReader class
     SqlDependency class
     SqlError class
     SqlErrorCollection class
     SqlException class
     SqlParameter class
     SqlParameterCollection class
     SqlTransaction class
SQLClientFactory class
SqlCommand objects
     ad hoc queries, integrating into applications 2nd
     creating
    executing asynchronously
         BeginExecuteNonQuery function
         BeginExecuteReader function
         BeginExecuteScalar function
         BeginExecuteXmlReader function
         callback 2nd
         cautions
         IAsyncResult interface 2nd
         overview of
         polling
         threads
         WaitHandle objects 2nd
     executing synchronously [See also populating data structures, DataSet Load method.]
         connection management
         ExecuteNonQuery function
         ExecuteReader function
         ExecuteScalar function 2nd
         ExecuteXmlReader function 2nd
         overview of
         SqlDataReader object
     methods
         Cancel
         Dispose
         New
         Prepare 2nd
         ResetCommandTimeout 2nd
     parameter-based queries
         access rights and
         ad hoc queries, inserting
         best practices
         default parameter values
         duplicate parameter names
         dynamic SQL
         marking parameters
         NULL values
         Parameters collections
         SqlParameter class
         SqlParameterCollection class
         Unicode literals
         Value property
         what can be parameterized
     properties
         CommandText
         CommandTimeout 2nd
         CommandType
         Connection 2nd
         Notification 2nd
         NotificationAutoEnlist 2nd
         Parameters 2nd
         Transaction 2nd
         UpdatedRowSource 2nd
     SQL injection attacks, preventing
    stored procedures
         executing
         RETURN values
    support functions
         Clone
         CreateParameter 2nd
    validation
         overview of
         sample application
SqlCommandBuilder [See CommandBuilder, action commands, generating.]
SqlConnection class [See connections, client/server connection management.]
SqlConnectionStringBuilder class 2nd
SqlContext class 2nd
SqlDataAdapter class
     Fill method
     properties
     Update method
     updates
SqlDataReader class
     best practice designs
     fetching all columns
     fetching individual rows
     fetching metadata
     Get functions
     GetSchemaTable method
     HasRows function
     overview of
     testing stream for data 2nd
SqlDependency class
SqlError class
SqlErrorCollection class
SQLEv (SQL Server Everywhere Edition)
     implementation
     overview of
     programming and maintenance
     security
     sharing and replication
     SQL Server tools
     SQLEngine
     Visual Studio support
SqlException class 2nd
SqlMethodAttribute property
SqlParameter class 2nd
     access rights and
     best practices
     default parameter values
     duplicate parameter names
     dynamic SQL
     marking parameters
     NULL values
     Parameters collections
     ResetDbType method
     ResetSqlType method
     Unicode literals
    validation
         overview of
         sample application
     Value property
     what can be parameterized
SqlParameterCollection class 2nd
SqlTransaction class
SqlUserDefinedTypeAttribute (UDTs)
SSEE (SQL Server Express Edition)
     administration 2nd
     capabilities
     common instances
     configuring as server
     crippled features
     database deployment
     default instances
     deployment
     eployment
     independent instances
     overview of 2nd
     performance 2nd
     replication
     scalability 2nd
     security 2nd
     Service Packs 2nd
     System Administrator's password
     tools 2nd
     user instances
stand-alone applications (client/server architectures)
     advantages/disadvantages
     building
     connection management
     connection pools
     data binding
     data entry paradigms
     data retrieval
     data storage limits
     data validation
     definition of
     hybrid architectures
     server-side cursors
     stored procedures
     temporary tables
Standard Edition (SQL Server)
Standard Edition (Visual Studio)
starting
     SQL Profiler traces
     SQL Server services
     Visual Studio
state, managing
StateChange event (connections)
statements
     ALTER PROCEDURE
     batches
     case-sensitive queries
     CREATE PROCEDURE
     CREATE RULE
     DECLARE
     DELETE
     Imports
     INSERT
         generating with Query Designer
         Identity values
         NULL and DEFAULT values
     IS NOT NULL
     IS NULL
     NULL values
     preparing for execution
     scripts
    SELECT
         CLR UDTs (user-defined types)
         creating
         creating cursors with
         executing
         joins
         ORDER BYclause
         ordering rows returned
         parameters
         SELECT INTO
         WHERE clause
     UNION
     UPDATE
         BLOBs
         concurrency
         decimal and floating point numbers
         generating with Query Designer
         parameter-based updates
         SET clause
         strings
         strongly typed data columns
         updating cursors
     Using block
static cursors
static ports
statistics, client
stepping through code
stock-keeping units (SKUs)
stored procedures
     CLR stored procedures
         compared to functions
         CountWords example
         creating
         performance
         returning resultsets with SqlContext class
         testing
    creating
         simple complex procedures
         simple stored procedures
     CustomerByState 2nd
     CustomerUpdate
     CustomerUpdate1
     debugging
         with breakpoints
         from code
         against local instances
         on remote instances
     ESPs (Extended Stored Procedures)
     executing 2nd
     managing 2nd
     naming
     RETURN values
     sp_addextendedproperty
     sp_dropextendedproperty
     sp_prepexec
     sp_updateextendedproperty
     TableAdapters
     updating tables with
streams
    SqlDataReader
         fetching all columns
         fetching individual rows
         fetching metadata
         Get functions
         overview of
         testing for data 2nd
     TDS (Tabular Data Stream)
strings
     concatenating
strongly typed data structures [See also configuring, TableAdapters.]
     building Web Services
     consuming and testing Web Services
     data columns
     DataSets
     exposing Web Services Data Sources in the UI
     need for
SubReport item
summary reports
SUMUSD aggregate
Surface Area Configuration (SAC) tool
synchronous execution of SqlCommand objects
     connection management
     ExecuteNonQuery function
     ExecuteReader function 2nd
         CommandBehavior.CloseConnection
         CommandBehavior.Default
         CommandBehavior.KeyInfo
         CommandBehavior.SchemaOnly
         CommandBehavior.SequentialAccess
         CommandBehavior.SingleResult
         CommandBehavior.SingleRow
     ExecuteScalar function 2nd
     ExecuteXmlReader function 2nd
     overview of
    SqlDataReader object
         best practice designs
         fetching all columns
         fetching individual rows
         fetching metadata
         Get functions
         overview of
         testing stream for data 2nd
Synonyms 2nd
sysname data type
System Administrator passwords
system databases
System.Data namespace
     DataColumn objects
     DataRow objects
    DataSet objects
         overview of 2nd
         populating
         strongly typed DataSets
    DataTable objects
         DataColumns
         DataRows
         joins
         overview of 2nd
         populating DataSets with
     naming conventions
     overview of
System.Data.SqlClient namespace
System.Data.SqlTypes namespace
SystemDataAccess setting (SqlMethodAttribute property)