Interested to Buy Any Domain ? << Click Here >> for more details...
plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005
- 3 Answers
- 5301 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the most common trace flags used with sql server?
Define cross join in sql server joins?
Determine when to use stored procedure to complete sql server tasks?
How do we know if any query is retrieving a large amount of data or very little data?
What do you know about system database? : SQL Server Architecture
How data can be copied from one table to another table?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How do I find query history in sql server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Can you tell me about the concept of ER diagrams?
Tell me something about security and sql azure?
Explain external key management in sql server 2008
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Is it possible in sql table to have more than one foreign key?
What is database architecture? : SQL Server Architecture
