What is compression - row-level and page-level compression?
What is the difference between for auto and for nested?
Rate yourself in .NET and SQL ?
1 Answers Cognizant, HCL, SunGard,
Explain transaction server implicit?
What is the appropriate number of test cases that you can write on a database?
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?
What is the server name for sql management studio?
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.
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is a collation?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What are the steps you must follow to hide sql server instances?
What is difference between joins and subqueries?