Answer Posted / karthik

sql server 2000 sql
server 2005

Query Analyzer and Enterprise manager Both
combined were Management Studio
are separate


XML data type is not used New
data type XML services is used


we can create only 16 instance we are
able to create 50 instances


clustering or log shipping require enterprise
Clustering,Database mirroing,Logshipping is standard edition
edition(Hardware Expensive) Database
mirroing can use cheap hardware


DTS packages SSIS
Packages


Standard stored procedure It is
modified into CLR stored procedure



Scalability:Limited to 2GB, 4CPUs in
Scalability 4 CPU, no RAM limit in Standard Edition.

More 64-
bit options offer chances for consolidation.
Standard Edition.Limited 64-bit support.

Explain datetime2 data type in sal server 2008?

941

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

1100

---

What is it unwise to create wide clustered index keys?

1040

---

Which sql server table is used to hold the stored procedure script?

998

---

What do you mean by an execution plan?

1186

---

What is the server name for sql management studio?

1093

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1165

---

What is resultset concur_updatable?

1051

---

What is indexing in sql server with example?

1036

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1110

---

What is an index. What are the types?

1157

---

How to add an address record into adventureworkslt?

1027

---

Is it important for a database administrator to understand the operating system and file access?

1036

---

What are the triggers in sql?

1156

---

When we should use @@error?

1028

---