Introduction of rollup clause using sum and group by clause?
What is implicit cursors?
What is the difference between join and inner join?
What is query and its types?
What are page splits? : SQL Server Architecture
Can multiple columns be used in sql group by clause in ms sql server?
Do you know what are acid properties of transaction?
what is database replicaion? : Sql server database administration
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.
How to count groups returned with the group by clause in ms sql server?
What are the disadvantages of using querystrings to send data from one page to another?
can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?
Where are full-text indexes stored?