INTERVIEWQUESTIONSPDF.COM

Spool operator scans the input and places a copy of each row in a hidden spool table that is stored in the tempdb database and existing only for the

<b> Density in SQL Server:</b> Density, when used to describe the data in a column, is a measure of how often duplicate values occur in that column. Another w

Depending on the type of access requested, SQL Server uses different lock modes while locking resources: • Shared (S) • Update (U) • Exclusive (X) •

The following query will only return user sessions and will filter out the internal system sessions: SELECT * FROM sys.dm_exec_sessions WHERE is_user

We can easily access session detail by querying the sys.dm_exec_sessions DMV using the following query: SELECT * FROM sys.dm_exec_sessions;

SQL Server implements lock granularities at the following resource levels and in this order: Row (RID) Key (KEY) Page (PAG) Extent (EXT) Heap or B-tree (H

Best practice of creating index for performance tuning. Create indexes on the frequently used columns in the WHERE clause and the JOIN criteria of a S

Step 1: Open SQL Profile and Click on create New Trace Step 2: Step 3: Step 4:

<b> Forwarding pointer:</b> when you update the row in the heap table, SQL Server tries to accommodate it on the same page. If there is no free space availabl

<b> Best practices for SQL Server data types for performance optimization:</b> You can improve the performance of Sql Server query (make fast) by reducing the

Sql Sever Performance tuning Interview Question: How Fixed Length and Variable Length Data types affect performance in Sql server Explain with exampl

Ans: When you delete a row, SQL Server does not physically remove the row from the page. Rather, it flags deleted rows as ghosted (deleted) in the st

<b> Allocation Maps:</b> SQL Server uses special kind of pages, called Allocation Maps, to track extent(collection of 8 pages known as extent) and page usage

<b> Data page: </b> The space in the database is divided into logical 8KB pages. These pages are continuously numbered starting with zero, and they can be refe

<b> What are NDF Files in SQL Server? </b> Sql Server interview questions<b> Filegroups:</b> All database files are grouped into the filegroups. A filegroup is a logic

<b> What do you understand by index_id = 0 and Index_id = 1?</b> If we have a query like select top 100 index_id , * from sys . indexes where index_id = 0 <b> Ans: </b> If you h