M

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