Why union all is faster than union?
How we Resize table,temp table, database and log file size in SQL Server 2005
How to drop an existing user defined function in ms sql server?
What are different types of schemas?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
how insert selected column only ?
How to loop through the result set with @@fetch_status?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
How to delete an existing row with delete statements in ms sql server?
What are relationships and mention different types of relationships in the dbms
How to convert a unicode strings to non-unicode strings?
What is dimension table? : sql server analysis services, ssas
List the advantages of using stored procedures?