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.

How can we use ConnectorJ JDBC Driver with MS SQL?

950

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

840

---

Explain contrast amongst grouped and non-bunched records?

957

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

976

---

How to delete duplicate rows in sql server?

1056

---

How can you set the threshold at which sql server will generate keysets asynchronously?

938

---

What do you know about system database? : SQL Server Architecture

928

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1013

---

How do I start sql server 2017?

887

---

How much memory that we are using in Logshipping Concept?

1727

---

What are built in functions?

951

---

Can we do dml on views?

914

---

Is sql server 2016 free?

884

---

Is it possible to create trigger on views?

934

---

Explain something about security and SQL Azure?

110

---