How many non clustered indexes there can be on table ?


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

Post New Answer

More SQL Server Interview Questions

How do you size a resultset?

0 Answers  


How to start sql server browser service?

0 Answers  


Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  


Which virtual table does a trigger use?

3 Answers  


What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,






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?

2 Answers   Cognizant,


What are character string data types in ms sql server?

0 Answers  


What is nonclustered index on computed columns?

0 Answers  


How to add additional conditions in SQL?

0 Answers   Amdocs,


What is meant by dirty read?

0 Answers  


Why do you need a sql server?

0 Answers  


What are the acid properties?

0 Answers  


Categories