Diffrences between sql server 2000 vs 2005
Answers were Sorted based on User's Feedback
Answer / sakthi
for error handling in 2005 we use try catch, new functions
like pivot and unpivot, datatype nvarchar(max), varchar
(max), char(max) to handle xml in 2005 we have special
datatype caller XML.
| Is This Answer Correct ? | 3 Yes | 0 No |
what is call by value & call by reference ?
What are the different Topologies in which Replication can be configured?
Mention the 3 ways to get a count of the number of records in a table.
What is the significance of null value and why should we avoid permitting null values?
Does an index slow down updates on indexed columns?
Do you know what is a linked server in sql server?
How do I create a stored procedure in dbml?
Determine when an index is appropriate?
Explain concepts of analysis services?
How many .ndf files can we create in Sql server 2005?
What is the maximum size of a dimension? : sql server analysis services, ssas
Explain how to send email from sql database?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)