Answer Posted / padmapriya

1.sql server 2005 include interprise manger and query
analyser together in same window we can open many window
tabs in same place but in 2000 it is in different.
2. sql server 2005 support more new datatype like xml
3. we can make more database 2(paw(20))-1 in 2005 in compare
to 2000 where not possible so much database
4. in storeprocedure we can write try catch statemenet in
2005 not in 2000

How can I create a report based on a query? : sql server management studio

1014

---

Can you please explain the difference between primary keys and foreign keys?

1099

---

How to delete duplicate records based on single column from a table?

1042

---

How to convert a unicode strings to non-unicode strings?

1096

---

Tell me what do we need queues in sql service broker?

981

---

What is system stored procedures?

1036

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1096

---

Why I am getting this error when dropping a database in ms sql server?

1070

---

What are horizontal and vertical scaling?

170

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2333

---

What is sql server used for?

1038

---

What to check if a User database is locked?

1060

---

What is stretch database in sql server?

1060

---

How much does sql server 2016 cost?

1051

---

which table keeps the locking information? : Sql server administration

1066

---