|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
| Sub Categories | |||||
 |
Certification (SQL 2005) 70-431 (15) MCDBA, MCITP, SQL 2005, Exam
|
||||
|
Showing: 1-8 of 8
Articles
|
|||||
 |
what is the method to change location of tempdb?
1. Determine the logical file names of the tempdb database and their current location on the disk.
SELECT name, physical_name FROM...
|
||||
|
|||||
|
what is ONLINE INDEX?
Online Index is a feature available after SQL Server 2005, prevously DBAs had to build index during off-peak hours as SQL Server locks data for...
|
||||
|
|||||
|
Which Stored procedure will be used to create an alert in database?
sp_add_alert procedure.
|
||||
|
|||||
|
which clause specified while creating a stored procedure causes the stored procedure to recomplile every time it is run?
the WITH RECOMPILE clause
|
||||
|
|||||
|
What is Data Mapping
Data mapping is a very important aspect in data integration. In fact, it is the first step in the many complex tasks associated with data integration...
|
||||
|
|||||
|
Which stored procedure is used to change the password for the distributor?
Sp_changedistributor_password procedure
|
||||
|
|||||
|
What is an Ad Hoc Query?
An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need...
|
||||
|
|||||
|
How to know which index a table is using?
SELECT table_name,index_name FROM user_constraints
|
||||
|
|||||
Powered by
KBPublisher (Knowledge base software)