What are different backups available in sql server?
If we delete pack Spec what will be the status of pack Body ?
What happens if null values are involved in comparison operations?
What are the 3 types of schema?
State the difference between union and union all?
Define inner join in sql server joins?
How to transfer an existing table from one schema to another schema in ms sql server?
what is denormalization and when would you go for it? : Sql server database administration
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
What is SQL Profiler and the use of it?
what is advantages in sql 2005 over sql 2000?
Is sql server is free?
What is de-normalization and when do you do it?