Inside SQL Server 2005 Tools
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] -d option (SQLCMD) DACs (dedicated administrator connections) 2nd data exporting 2nd importing BCP 2nd bulk imports SSIS data authoring BCP architecture bulk import optimizations command syntax error handling exporting data exporting/importing example format files importing data improvements new features parameters Query Editor architecture Database Engine support execution options fonts/colors Grid Control Grid Storage hotkeys Mobile queries queries, executing Sort View Storage View components XML support Data Definition Language (DDL) data flow Data Flow tab (SSIS Designer) Data Manipulation Language (DML) Data Mining Designer (BI Development Studio) algorithms/viewers association rule filters base columns with varying settings/properties classification matrix reports 2nd data source view, customizing diamond symbols lift chart multiple similar base columns productivity enhancements stored procedures, viewers viewer graphs, copying data mining stored procedures association rule clustering decision trees dependency net Naive Bayes neurel net data mining tools Data Mining Designer algorithms/viewers association rule filters base columns with varying settings/properties classification matrix reports 2nd data source view, customizing diamond symbols lift chart multiple similar base columns productivity enhancements stored procedures, viewers viewer graphs, copying DMX templates (data mining) Web site Data Mining Wizard Data Source Editor dialog box Data Source View Designer (BI Development Studio) cube/dimension/partition definitions customizing Replace tables feature data sources Integration Services Report Designer supported reports choosing OLAP/relational combinations Data tab (Report Designer) database administrators (DBAs) Database Designer (BI Development Studio) Database Diagram Designer Database Engine Agent architecture Database Engine monitoring error log file jobs [See Microsoft, Operations Manager, Agent; Database Engine, Agent, jobs.] metadata tables monitoring capabilities [See Database Engine, Agent, jobs; Database Engine, Agent, monitoring capabilities.] multi-server administration replication security services, configuring stored procedures synchronization script automation task types supported upgrades client network protocols connections features, enabling/disabling 2nd ad-hoc remote queries Agent stored procedures CLR integration Database Mail Native XML Web Service OLE Automation remote DACs Service Broker SQL Mail Web Assistant xp_cmdshell installing 2nd DVD main screen Installation Wizard [See Database Engine, installing, Installation Wizard; installing, SQL Server 2005, Database Engine.] Setup Wizard monitoring network protocols overview Query Editor support single user mode startup parameters trace flags Tuning Advisor (DTA) Database Mail configuring parameters Wizard enabling/disabling Executable Minimum Lifetime parameter log Log File Viewer profiles sending monitoring overview security storage troubleshooting Wizard Database Mirroring Database Tuning Advisor [See DTA (Database Engine Tuning Advisor).] databases AdventureWorks backing up deploying across servers Import Analysis 9.0 mirroring objects creating properties selecting for replication replication agents configuring monitoring [See Database Engine, Agent, replication; databases, replication, monitoring.] Object Explorer icons overview publications [See Database Engine, Agent, replication; administration, replication (Management Studio), publications.] Replication folder subscriptions 2nd 3rd restoring roles sample tools trace data, saving $(DATE) token DBAs (database administrators) DCOM (Distributed Component Object Model) DDL (Data Definition Language) debugging packages decision trees (data mining stored procedure) dedicated administrator connections (DACs) 2nd Define Relationship dialog box Delete command (Notification Services) deleting application obsolete data components full text indexes instances MRU server names multiple objects Dependency Discovery phase (SMO scripting) dependency net (data mining stored procedure) DependencyTreeNode object Deploy Report Project command (Report Designer Build menu) deploying databases across servers instances argument encryption database objects, creating high availability Notification Services NSControl deployment script registration scaling out SQL Server permissions starting instances Windows permissions packages 2nd reports tools Analysis Services Deployment Wizard Copy Database Wizard Management Studio Deployment Wizard designers (BI Development Studio) 2nd 3rd Detail Pane (Publisher) Developer Edition development tools BIDS Visual Studio dialog boxes Add Filter Add Join Add Publisher Add SSIS Connection Manage Advanced Replay Options Advanced System Properties Windows Analysis Server Properties Analysis Services Properties Article Properties Attach Choose Toolbox Items Choose Variable Columns Configure SSIS Logs Connect To Connect to Database Connect to Server Connection 2nd Connection Parameters Data Source Editor Define Relationship Edit Filter Environment Variables Windows Event Rule Properties Export Package Filter Settings Generate Filters Import Package Instance Properties Job History Launch a Script Log Entry Login Management non-modality opening resizability scheduling scriptability Management Studio Options Named Calculation New Alert New Database New Job New Job Schedule New Job Step New Operator New Project New Proxy Account New Server Registration Notification Services Instance Object Explorer Filter Settings Package Configuration Organizer Package Execution Progress Package Roles Performance counter selection Process Project Properties Properties For All Tables Property Expressions Editor Property Pages Refresh Settings Register Instance 2nd Replay Configuration options Restore Database 2nd Restore File and Filegroups Save Copy of Package Security Property Select Computer Set Breakpoints SQL Agent Properties Surface Area Configuration for Features Trace Properties 2nd Update Instance 2nd Update Summary diamond symbols (Data Mining Designer) Dimension Designer (BI Development Studio) Dimension Editor multiple parents rollup with weights tree views UDM picture support Dimension Usage tab (Cube Designer) measure groups dimensionality measure groups granularity Dimension Wizard dimensions attribute relationships creating definitions quick designs 2nd data source customizations Replace tables feature security time types 2nd disabling ad hoc data mining queries ad hoc remote queries Analysis Services features ad hoc data mining queries anonymous connections linked objects user-defined functions anonymous connections applications CLR integration Database Engine features 2nd ad hoc remote queries Agent stored procedures CLR integration Database Mail Native XML Web Service OLE Automation remote DACs Service Broker SQL Mail Web Assistant xp_cmdshell Database Mail HTTP Access instances linked objects Native XML Web Service OLE Automation remote connections remote DACs report deliveries Reporting Services features scheduled events Service Broker SQL Mail user-defined functions Web Assistant Web Services Windows Integrated Security xp_cmdshell Display Estimated Execution Plan command (Query Editor Query menu) Distributed Component Object Model (DCOM) Distribution agents Distributor to Subscriber History tab (Transactional Subscription Detail window) DML (Data Manipulation Language) DMO DMX templates Documenter drop/create events DTA (Database Engine Tuning Advisor) architecture database/table selection grid evaluative tuning recommendations Session Monitor starting Submitting Configuration Information phase tuning options 2nd DTA.exe command line interface dtexec command line utility dtutil command line utility dump directories Dynamic Help command (Management Studio Help menu) Dynamic Help window |
Категории