what is difference between primary key and Unique8 4006
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 6110
HOW TO RENAME A COLUMN NAME3 4336
what is cluster and nin-cluster index?4 3447
What are different types of Keys? Please explain all the keys with a suitable example.4 23014
What is row by row processing ?2 5747
can primery key be a non clustered index?10 6740
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.1 3724
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?4 6257
How to find out name of all employees who has salary less than 200 Rs.?8 4379
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.1 1966
ow to bring suspect mode datbase online from scratch
how to use DTS package in 2000,2005,2008 in sql server
If user is owning any SQL Objects, can we drop that user
What is data modeling and Reterminal integrity?
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.
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
tell me the disaster recovery plan
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
how to take backup bcp out for a column in table in sql server?
Why do you want to join software field as you have done your BE in Electronics?
how can u get last observation in an unknown dataset ?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do