Latest answer: Parallelism is the process of executing queries
in parallel to increase performance...........
Latest answer: When a query needs to be optimized, an execution
plan is created by the query optimizer........
Latest answer: A clustered index is uses the index key to sort
the data of the table. And since there can be only one sort order, there can be
only one clustered index.........
Latest answer: When the SQL server needs to execute a query, it
makes use of the execution plan available in the memory. If not, the query is
compiled in 4 stages...........
Latest answer: Ensure the server has enough memory, Less number
of indexes on a table.........
Latest answer: When a stored procedure is created using WITH
RECOMPILE option, the execution plan for the procedure is not cached...........
Latest answer: When a stored procedure is created using WITH
RECOMPILE option, the execution plan for the procedure is not
reused............
Latest answer: Page splits are performed when there is no space
in a data page to accommodate more inserts or updates. In a page spilt, SQL
server removes some data from the current data page and moves it to another
data page..........
Latest answer: One of the cheapest ways to capture performance
monitor data is to use performance monitor itself. The performance monitor can
be used to create logs of each activity..........
Latest answer: Most of the times the query design is
responsible for increase in size of tempdb database. The query returns a large
amount of rows when no predicate or where clause is specified............
Latest answer: Partitioned view joins the horizontally
portioned data. This data may belong to one ore more servers. It makes the data
appear as one table.............
Latest answer: Restoring a master database on a SQL server
cluster is required in case of a disaster when the previous backup is
required.............
Latest answer: Estimating the space needed for a database is
essential to figure out the performance of the application and size of
database.............
Latest answer: SQL server cluster does not support load
balancing.............
Latest answer: As the data in a table is modified, each index
on the table needs to be updated. This is certainly an overhead. If the data
modification queries are slowing down, it means that more indexes are used in
the table...........
Latest answer: This usually happens when index statistics are
not up-to-date. They can be by reindexing them and using "Auto Create
Statistics" and "Auto Update Statistics" options from database
settings.............
Latest answer: Server clustering on replication involves many
manual and tedious tasks...........
Latest answer: IIf is most commonly used in Microsoft access to
determine if another expression is true or false............
Latest answer: An integer data type can have a variety of
IDENTITY values like int, bigint, tinyint etc.............
Latest answer: SYSMON/PERFMON utility provides system resources
usage details...........
Latest answer: SSIS has the ability to send SSRS report in
different formats like Excel, PDF etc...........
Latest answer: The only way to alter a User Defined Data Type
is to drop the existing and create a new one............
Latest answer: Even though creating triggers on system tables
should be avoided, following are the probable reasons why one would want to
create triggers on system tables.........
Latest answer: In order to Integrate Performance Monitor and
SQL Profiler, server performance needs to be captured simultaneously using both
Performance Monitor’s Counter Logs and SQL Server Profiler.................
Latest answer: SSAS database backups can be taken using SQL
Server Management Studio (SSMS). In order to create a backup using the SSAS
backup option, a SQL Server Agent Job needs to be created and
scheduled................
Latest answer: Auto incremental numbers in a SSIS package can
be provided using script components.............
Latest answer: COMPUTE BY is used to generate sub totals or
summary of a result set. They are used with an ORDER BY clause............
Latest answer: A KILL command in SQL is used to end or KILL a
sql server process that is identified using a system process id............
Latest answer: Having multiple instances allows SQL server to
have multiple instances that can be helpful in development and testing
environment.........
Latest answer: Mirroring helps to increase database
availability. In situations where mirroring needs to be disabled, ENDPOINT of
the database should be deleted.........
Latest answer: New date and time data types considering time
zones as below..........
Latest answer: The Master database can be rebuilt using the
following steps:.........
Latest answer: Language Integrated Query allows different
features to be integrated in the basic programming language used in an
application............
Latest answer: Catalog views can be used to return information
like objects, logins permissions etc used by SQL server database
engine............
Latest answer: PIVOT is a relational operator used to provide a
more readable or simpler view of a table’s data............
Latest answer: SQLCMD is a command line utility that is used to
run queries from the command prompt..........
Latest answer: TABLESAMPLE is a clause that can be used in a
FROM clause query to limit the number of rows retuned from a result
set..........
Latest answer: EXCEPT clause is used to return records that are
returned by the first query and NOT the second query............
Latest answer: NOLOCK table hint used using WITH clause, is
similar to read uncommitted. This option allows dirty reads are
allowed............
Latest answer: SQL allocates 4 bytes for an integer data type
irrespective whether the number is small or large............
Latest answer: The database can be detached from one server and
attached to another. Methods are : sp_detach_db and sp_attach_db..........
Latest answer: Data from one table can be copied into another
using the INSERT INTO clause..............
Latest answer: CTE is Common Table Expression. It is a
temporary result set for an INSERT, UPDATE or a SELECT query............
Latest answer: Tables without indexes can be found using the
OBJECTPROPERTY method............
Latest answer: DBCC DBREINDEX is an offline operation is used
to rebuild the indexes of a table dynamically...........
Latest answer: The SQL Server 2005 Surface Area Configuration
Tool helps in turning ON features that are turned OFF by default...........
Latest answer: SA account in SQL server can be renamed or
disabled using ALTER LOGIN command............
Latest answer: The WITNESS server is used to enable the mirror
server to recognize the necessity of failover.............
Latest answer: The cursor can be written as a normal query in
case of scenarios when the task needs to be performed repeatedly.............
Latest answer: ReportServerURL is used to set or get URL for
the report server. Jscript uses get ReportServerUrl(uri value) and post
ReportServerUrl(uri value)...........
Latest answer: Network interface is used to monitor activities
of the network cards present on the server...........
Latest answer: Lookup transformation combines data from two
sources. The fields of these sources are matched.........
Latest answer: Execute Process Task in the Control Flow task
can be used to unzip a file............
Latest answer: NULL values in the database for a column
particularly cause problems in searching and comparison.............
Latest answer: Stored procedure performs better in comparison
to user defined functions. Stored procedures are precompiled and executed on
the database server.............
Latest answer: Worst performing queries in my SQL Server
database application can be identified using Dynamic Management views and
Dynamic Management Functions. It helps to find the internal working of SQL
instances and database objects..............
Latest answer: UNION command selects distinct and related
information from two tables. On the other hand.............
Latest answer: Database Consistency Checker Commands give
details in form of statistics about the SQL Server..............
Latest answer: UNION command selects distinct and related
information from two tables. On the other hand.............
Latest answer: A local temporary table lives until the
connection is valid or until the duration of a compound statement..............
Latest answer: STUFF function is used to insert a string into
another string by deleting some characters specified.............
Explain the concepts of faster differential backups.
Explain the concepts of Parallel Database consistency check (DBCC)
Define Indexed view.
Define Distributed partitioned views.
Database backup methods - Full Backups, Differential Backups, Transaction Log
Architecture Backups, File and Filegroup Backups.
RAID is a mechanism of storing the same data in different locations. Since the
same data is stored, it is termed as redundant............
Explain the concepts and capabilities of SOAP. Explain the purpose of Native XML
mode in SQL Server 2005.
Native XML Access vs. SQLXML.
Benefits of Native XML Access in SQL Server 2005.
Limitation for Native XML Web Services.
Here you will learn how to copy a table on an Oracle 10G XE database to a
database on the SQL Server 2005. You will also learn how to install an Oracle
10G XE server and work with its database objects.
