S


-S switch, using with Sqlcmd, 38–39

SAFE permission, using with .NET database objects, 89

scalar values, extracting from XML data types, 149

Schedule element of ADF, description of, 116

scheduled tuning, support for, 43–44

Schema section of ADF, description of, 118

schemas. See also XSD schemas

creating database objects in, 16

defining for Notification Services applications, 110

definition of, 15

returning with XMLSCHEMA directive, 153–154

Script Wizard, using with Object Explorer, 29

scripting support, availability in Analysis Services, 221

scripting variables, defining with Sqlcmd, 38–39

scripts

Analysis Server scripts, 32

SQL Mobile scripts, 32

SQL Server scripts, 32

secondary XML indexes, creating, 150–151

security

of catalogs, 21

of dialogs in SQL Server Service Broker, 139–140

enhancements in Analysis Services, 224–225

and more granular permissions control, 19–20

of .NET database objects, 89

overview of, 14–15

and password policy enforcement, 20

and stored procedure execution context, 17–19

and user-schema separation, 15–17

Select Build Method window, displaying in Cube Wizard, 229

Select Measures window, displaying in Cube Wizard, 231

SELECT permission, description of, 20

SELECT statements

using with CTEs, 91

using with OPENXML, 155

using with PIVOT operations, 93

using with SQL Server Service Broker application, 135

Select Tables and Views window, displaying in Data Source View Wizard, 227

Select the Data Source window, displaying in Report Wizard, 176

Select the Report Type window, displaying in Report Wizard, 178

semicolon (;), using with WITH keywords, 91

SEND operations, executing in SQL Server Service Broker application, 136

SEND T-SQL DML statement, description of, 133

SENT BY clause, using in SQL Server Service Broker application, 134

server events, features of, 9

server failure, protection against, 50–55

Server Manager, absence of, 24

servers, registering with SQL Server Management Studio, 28

server-side cursors, ADO.NET support for, 97–98

Service Broker. See SQL Server Service Broker

service instances. See conversation groups

services

creating for SQL Server Service Broker application, 135

grouping contracts as, 132

SET statement, using with UDTs, 84–85

SET WITNESS clause, using with Database Mirroring, 54

sets, using in WHERE clause with MDX, 236

Sharepoint versus Report Manager, 172

Showplan, example of, 41

single quotes (‘), using with CREATE XML SCHEMA COLLECTION DDL statement, 144–145

SINGLE_CLOB argument, using with XML bulk load, 156

SMO (SQL Server Management Objects), features of, 46–47

SMP systems, relationship to NUMA, 6

Snapshot Isolation, features of, 61–62

Snapshots, support for, 8

Solution Explorer window

in Business Intelligence Development Studio, 35–37

in Report Designer, 167

in SQL Server Management Studio, 30–32

source control feature

in Business Intelligence Development Studio, 37

in SQL Server Management Studio, 32–33

Source* system variables, purpose in Integration Services, 196

sp_configure, options for, 139

SQL Server 2000, ownership chains in, 18

SQL Server Computer Manager

availability in Analysis Services, 221

features of, 24–25

using with Analysis Services, 222

SQL Server engine enhancements

bulk data loading, 13–14

data partitioning, 10–12

database data files, 9

Database Snapshots and Mirroring, 8

Full-Text search, 14

indexes, 12

MARS (Multiple Active Results Sets), 13

for multiple instances, 7

.NET framework integration, 7

new data types, 7–8

server events and DDL triggers, 9

system catalog and metadata, 12–13

T-SQL query processor, 14

SQL Server Enterprise Manager, replacement of, 25

SQL Server event providers, relationship to Notification Services, 108

SQL Server Management Studio

creating Notification Services applications with, 121

Current Activity window in, 33

Dynamic Help window in, 32

guidelines for use of, 37–38

Object Explorer window in, 27–29

overview of, 25–29

Properties window in, 32

Query Editor in, 29–30

Registered Servers window in, 27–28

relationship to XML bulk load feature, 156

Results window in, 30

Solution Explorer in, 30–32

source control feature in, 32–33

using with Analysis Services, 223–224

SQL Server Management Studio Query Editor. See Query Editor

SQL Server .NET Data Providers. See .NET data providers

SQL Server Project template, using with .NET data providers, 70

SQL Server projects. See projects

SQL Server scripts, using with Solution Explorer, 32

SQL Server Service Broker

activating, 130

administering, 138–140

conversation groups in, 129–130

and dialog security, 139–140

dialogs in, 128–129

and DML statements, 132–133

example application for, 133–138

features of, 126–127

and message transport, 130–131

programming model for, 131–132

queue application design of, 127–128

system views in, 140

and T-SQL DDL, 132–133

SQL Server systems, registering, 28

SQL Server templates. See templates

SqlBulkCopy object, ADO.NET support for, 102–103

Sqlcmd utility

features of, management and development tools, 38–40

starting in dedicated administrative mode, 60

SqlDataReaders, assigning ADO.NET’s asynchronous queries to, 99

SqlPipe ADO.NET objects, using with UDTs, 79

[SqlProcedure] attribute, using with .NET stored procedures, 74

SqlResultSet object, ADO.NET support for, 97–98

SqlServerSystem tag in config.xml file, significance of, 113

SqlTriggerContext ADO.NET objects, using with UDTs, 79

StartTime system variable, purpose in Integration Services, 196

state, maintaining with service instances, 129

stored procedure execution context, relationship to security, 17–19

stored procedures

creating by activation, 130

relationship to .NET CLR, 72

using to retrieve messages from queues, 136–138

using with SQL Server Service Broker application, 135

strongly typed XML data types, overview of, 143–147. See also XML data types

SubLocale section of ADF, description of, 118

Subreport control, using with Report Designer, 166

subscribers, adding to Notification Services applications, 123–124

subscription delivery, implementing with Report Server, 171

subscription management interface, providing for Notification Services, 111–112

Subscription objects, using with Notification Services, 124

SubscriptionClasses section of ADF, description of, 118

subscriptions in Notification Services

adding, 108

overview of, 107

summary line, displaying in Reporting Services reports, 185

Sys.* views in SQL Server Service Broker, descriptions of, 140

sys.assemblies view, viewing assemblies with, 69

system catalog, enhancements in, 12–13

system configuration options, using with SQL Server Service Broker, 139

system variables, Integration Services support for, 195–196

system views, availability in SQL Server Service Broker, 140

System.Data.SqlClient namespace, relationship to ADO.NET’s asynchronous queries, 99

System.Data.SqlServer namespace

contents of, 72

importing, 74

sys.Types view, querying, 84

sys.xml* catalog views, descriptions of, 158

sys.xml_namespaces system view, querying, 146




Microsoft SQL Server 2005 New Features
Microsoft SQL Server 2005 New Features
ISBN: 0072227761
EAN: 2147483647
Year: 2005
Pages: 80
Authors: Michael Otey

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net