how many instance use in sql server 2005
Answer Posted / trived
normally sql sever 2000 16 instance possible
in 2005 50 instance possible
Is This Answer Correct ? | 26 Yes | 2 No |
Post New Answer View All Answers
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the maximum rows in sql server table?
what are user defined datatypes and when you should go for them? : Sql server database administration
How global temporary tables are represented and its scope?
Explain full-text query in sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
How do I find the sql server version?
Where is my database stored on the hard disk in ms sql server?
Explain user defined functions?
What is a fan-out query in SQL Azure?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is page-level compression?
How important do you consider cursors or while loops for a transactional database?
How to provide column names in insert statements in ms sql server?
How you would rewrite the sql query to return the customerid sorted numerically?