What is compression - row-level and page-level compression?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is the difference between for auto and for nested?

0 Answers  


Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,


Explain transaction server implicit?

0 Answers  


What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,


how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,






What is the server name for sql management studio?

0 Answers  


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,


What is a collation?

0 Answers  


Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,


What are the steps you must follow to hide sql server instances?

0 Answers  


What is difference between joins and subqueries?

0 Answers  


Categories