Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)
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] maintenance DBMSs in SQLEv (SQL Server Everywhere Edition) Make Table Query type (Query Designer) Management Classes Management Studio (SQL Server) creating queries Object Explorer queries [See queries, ad hoc queries, integrating into applications.] stored procedure management managing concurrency CommandBuilder Identity column values overview of generating parameters parameters resources server report parameters 2nd server-side cursors 2nd servers with Server Explorer SqlConnection objects stored procedures temporary tables user databases market share marking parameters MARS (Multiple Active Resultsets) 2nd 3rd 4th master databases Matric report building custom report cache table data considerations grouping data initial SELECT Query layout testing 2nd maximum connection pool size MaxLength property (DataColumn objects) MDAC stack, sharing .MDFdatabase files, attaching memory buffer cache Shared Memory Merge function Message Queuing messages InfoMessage messages, populating Message Queuing metadata, fetching from SqlDataReader streams methods and functions 2nd [See also stored procedures.] Accumulate Add 2nd AddRange 2nd AddTrustedCodeModuleInCurrentAppDomain Append AppendFormat BeginExecuteNonQuery BeginExecuteReader BeginExecuteScalar BeginExecuteXmlReader BuildAndExecuteAsyncCommands Cancel CancelEdit Clear Clone Close CLR aggregates CLR functions addressing in T-SQL deploying UDT methods compared to stored procedures connections ConvertToDollars CountWordsInString CreateParameter 2nd Dispose 2nd EndEdit ExecuteNonQuery ExecuteReader 2nd CommandBehavior.CloseConnection CommandBehavior.Default CommandBehavior.KeyInfo CommandBehavior.SchemaOnly CommandBehavior.SequentialAccess CommandBehavior.SingleResult CommandBehavior.SingleRow ExecuteReportInCurrentAppDomain ExecuteReportInSandboxAppDomain ExecuteScalar 2nd ExecuteXmlReader 2nd Fill 2nd Find 2nd FindRows Format GetBoolean GetByte GetBytes GetChars GetDataSourceNames GetDataSources GetDataTypeName GetDateTime GetDecimal GetDefaultPageSettings 2nd GetDocumentMap GetDouble GetFieldTypeName GetFloat GetGuid GetHashCode GetInt16 GetInt32 GetInt64 GetName GetOrdinal GetParameters 2nd GetProviderSpecificFieldType GetProviderSpecificValue GetProviderSpecificValues GetSchemaTable 2nd GetServerVersion GetString GetTotalPages 2nd GetValue GetValues HasRows 2nd IDENT_CURRENT() Init instructors IsDBNull JumpToBookmark JumpToDocumentMapID ListRenderingExtensions 2nd Load LoadReportDefinition 2nd LoadSubreportDefinition LOWER Merge MoveFirst MoveLast MoveNext MovePrevious MovePrevoius New NewRow Parse 2nd PerformBack Prepare 2nd Read Refresh 2nd RefreshReport RemoveFilter RemoveSort Render 2nd RenderStream Reset ResetBindings ResetCommandTimeout 2nd ResetCurrentIrem ResetDbType ResetItem ResetSqlType ResumeBinding Set Parameters SetDataSourceCredentials SetParameters Sleep T-SQL Functions advantages of Inline Functions return values Scalar Functions structure of Table Functions Terminate ToString 2nd ToTable TVFs (table-valued functions) Update 2nd UPPER WaitAll WaitAny metrics (performance) Microsoft Learning team product documentation product updates Microsoft.SQL Server.Server namespace minimum connection pool size MissingMapping Action property (SqlDataAdapter class) MissingSchemeAction property (SqlDataAdapter class) Mixed Mode (SQL Server) model database money data type monitoring SQL Server connection pools overview of with performance counters activating performance counters selecting counters SqlClient performance counters with SQL Profiler Application Name property configuring evaluating traces filter criteria, adding starting traces tips and recommendations MoveFirst method MoveLast method MoveNext method MovePrevious method msdb database MSDE Edition (SQL Server) [See Express Edition (SQL Server), administration.] MSDN documentation, installing MSDN Search Index Utility multi-column primary keys multi-tiered application design multi-user issues Multiple Active Resultsets (MARS) 2nd 3rd 4th multiple breakpoints, setting multiple databases multiple SQL Server instances |
Категории