You have a SQL Server 2012 database named DB1. DB1 contains four filegroups named FG1, FG2, FG3, and FG4. You execute the following code: Two million rows are added to dbo.Sales. You need to move the data from the first…
You have a database named database1. Each table in database1 has one index per column. Users often report that creating items takes a long time. You need to perform the following maintenance tasks: Identify unused indexes. Identify indexes that need…
You execute the following code: You discover that the Customers table was created in the dbo schema. You need to create a code segment to move the table to another schema named Schema2. What should you create? To answer, drag…
You plan to deploy two stored procedures named SP1 and SP2 that read data from the database. Your company identifies the following requirements for each stored procedure: SP1 must allow dirty reads. SP2 must place range locks on the data…
You have a table named Customers that has a clustered index defined on the ID column. You write a script to create a stored procedure. You need to complete the script for the stored procedure. The solution must minimize the…
You have a SQL Server 2012 database named Database1. Database1 has a data file named Database1_data.mdf and a transaction log named Database1jog.ldf. Database1_data.mdf is 1.5 GB. Database1jog.ldf is 1.5 terabytes. A full backup of Database1 is performed every day. You…
You have a SQL Server 2012 database named database1. Users report that queries that usually take less than one second to execute, take more than 30 seconds to execute. You need to view the server resource consumption when the queries…
You are designing two stored procedures named Procedure1 and Procedure2. You identify the following requirements: Procedure1 must take a parameter that ensures that multiple rows of data can pass into the stored procedure. Procedure2 must use business logic that resides…
You are planning two stored procedures named SProc1 and SProc2. You identify the following requirements: SProc1 must return a table. SProc2 must return a status code. You need to identify which options must be implemented to meet each stored procedure…
You plan to create a custom aggregation function named Function1. You plan to deploy Function1 to SQL Server 2012. You need to ensure that Function1 can access a web service. The solution must minimize the number of changes made to…