what is difference between primary key and Unique8 3879
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????3 6025
HOW TO RENAME A COLUMN NAME3 4242
what is cluster and nin-cluster index?4 3346
What are different types of Keys? Please explain all the keys with a suitable example.4 22794
What is row by row processing ?2 5646
can primery key be a non clustered index?10 6546
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.1 3666
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?4 6087
How to find out name of all employees who has salary less than 200 Rs.?8 4250
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.1 1903
How to convert a table data in XML format in sql server?
Tell about MOM Tool(Microsoft Operator Manager)?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
what is the sql equivaent of the dataset relation object ?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is Lock table in SQL?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
how to do partition in sqlserver
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
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 restore performance issues and how to check?
If we delete pack Spec what will be the status of pack Body ?
how can you attach more than 20 ldf files in sql server