Interested to Buy Any Domain ? << Click Here >> for more details...
plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005
- 3 Answers
- 5333 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hari
in 2005--database mirroring,CLR Integarion,SIS,Data
paratition, xml datatype,Dynamic management views,Mirror
backup
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Does transparent data encryption provide encryption when transmitting data across the network?
What is nolock hint in sql server 2008
Explain triggers in sql?
What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?
3 Answers Microsoft, TCS, Techastrum,
What is the difference between a function and a trigger?
Can we insert data if clustered index is disabled?
please tell me the query to get details of the employee having the second largest salary
what operator performs pattern matching?
what is the Enterprise manager(2000) and management studio (2005)?
How to create a local temporary stored procedure?
Explain atomicity?
What is the difference between varchar and nvarchar datatypes?
-
Oracle (3259) - 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)
