Using the SQL Server Documentation SQL Server also comes with extensive electronic documentation. To access this documentation, you select Start ➣ Programs ➣ Microsoft SQL Server ➣ Books Online. Figure 1.9 shows the SQL Server<[r]
through a number of panels, with an SQL statement as the result. SQL Query Builder—The SQL Query Builder is an editor for an advanced user.Both tools can be used to build an SQL statement. After using the SQL Statement Wizard, yo[r]
382 Chapter8•ETLTechniquesEXERCISE 8.9Ex E C U t i n g a n SSIS Pa C k a g EIn this exercise, you will use the DTExecUI utility to execute the package that you created in Exercise 8.7 using the Import and Export Wizard. This exercise assum[r]
[ Team LiB ] Recipe 6.3 Nesting Manual Transactions with the SQL Server .NET Data Provider Problem You need to create a nested transaction using the SQL Server .NET data provider, but the Begin( ) command that you need is only available with <[r]
lowing options best supports changing the properties of a package at runtime?A. Package ConfigurationsB. DTExec command line optionsC. “SQL Server Integrations Services Packages” step in a job.D. DTExecUI optionsCorrect Answer and Explanation: A. Answer A is correct. Pack[r]
Attempting to comprehensively cover any one of these topics alone would easily generate enough material to fill an entire book, so I'm not even going to try doing so. Instead, I’m going to concentrate on what I believe you need to know to create high-quality database applications, based on my own pr[r]
perfect targets candidate for building an OCA.OCAs include phone, PDA, tablet, or other portable device applications, such as thoseneeded by a mobile salesperson, floor manager, insurance adjuster, physician, or any otherprofessional who is on the go. People in these positions cannot be expec[r]
InstallingSQLServer2008•Chapter2 37The key database engine features in the Enterprise Edition address scalability, high availability, and security.Scalability is the ability to add more resources. In SQL Server 2008 Enterprise Edition, th[r]
40. When the data is coming from various database systems, the data type may be in different formats. The Bulk Insert task provides four default data formats that can be imported. You can specify the data type of the input file using the DataFileType[r]
Name Name of the plan guide.create_date Date and time the plan guide was created.modify_date Date the plan guide was last modified.is_disabled 1 = disabled and 0 = enabled.query_text Text of the quer y on which the pla n gu ide is created.scope_type S[r]
Step SQL Server Key Dec SQL Command1 Service master key (SMK)Created by SQL Server at the time of setup, the SMK is encrypted using Windows Operating System’s Data Protection API (DPAPI) and the local computer key that is derived[r]
ptg1340 CHAPTER 36 Query AnalysisFor more information on using SQL Server Profiler, see Chapter 6, “SQL Server Profiler.”NOTEBecause of the capability to view the graphical execution plans in SQL Server Profiler as well as the cap[r]
1.0 QUERYING AND MANAGING DATA USING SQL SERVER 2005 Stored procedures: Are created using the CREATE PROCEDURE statement Are executed using the EXECUTE PROCEDURE statement Syntax: CREATE[r]
286 Chapter7•MaintainingYourDatabaseLet’s examine the important routine management tasks that can be created easily using the Maintenance Plan Wizard: Maintain indexes by reorganizing or rebuilding them with a Fill Factor. Routinely rebuilding indexes prevents ove[r]
solution?A. Implement SQLMailB. Implement Database MailC. Install a 3rd-party SMTP mailerD. Implement Service Broker13. You’ve just upgraded to SQL Server 2008 from SQL Server 2000, and you’ve dropped SQLMail in favor of Database Mail. The IT Manager wants t[r]
processes.14. You are designing a SQL SERVICE BROKER application that will be sending messages from instance to instance. Both instances will be running 554 Chapter12•ServiceBrokerSQL Server 2008 Express edition. The messages will be routed through a third instance of SQ[r]
Rather than exporting all of your old email from Outlook Express to Outlook, create archive folders in Outlook Express for your older email and export only the newest messages to Outlook. You can use a utility called DBXtract to scan Outlook Express's DBX files, break them into[r]
tightly integrated with Windows login information, and SQL Server knows and understands the user's identity. SQL Server recognizes the user's personal identity as well as his Windows group membership. Even if no personal SQL Server
1.0 QUERYING AND MANAGING DATA USING SQL SERVER 2005 FOR XML: Retrieves the XML data using the following directives: RAW: Is used to return an xml file with each row representing an XML [r]