Introduction of rollup clause using sum and group by clause?
Explain hostprotectionattribute in sql server 2005?
How can we get count of the number of records in a table?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
how to create a scrollable cursor with the scroll option? : Sql server database administration
How is a full-text index updated?
How to create nested stored procedure?
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
what is difference between primary key and Unique
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
How to create a view using data from another view?
What is user-defined scalar function?
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.