Answer Posted / rohit bhosale
Sql SErver 2008 exist with a highly available concepts that
are helpful to provide data security or protection,to
improve performance while SQL Server 2005 is lack of these
concepts hence We all are preferable to use 2008.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain candidate key, alternate key, and composite key?
Where sql server usernames and passwords are stored in a sql server?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is difference between after and before?
Is null vs coalesce?
Explain indexes disadvantages?
what is raid? : Sql server database administration
What are the authentication modes in sql server? How can it be changed?
what is a self join? : Sql server database administration
What is sql server query analyzer?
What is inline variable assignment?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Can we use custom code in ssrs?
What is sql server locking?
What is the recommended total size of your memory optimized tables?