What is difference between count (*) and count 1?


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

Post New Answer

More SQL Server Interview Questions

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  


How to add a new dsn with the odbc driver for sql server?

0 Answers  


What is microsoft sql server?

0 Answers  


how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

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  


How do you open a cluster administrator?

0 Answers  


What is inner join? Explain with an example?

0 Answers  


SQL Server Architecture ?

0 Answers   IBM, Sapient,


What is the use of Port no?

1 Answers   Wipro,


What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  


Categories