ehat is the default port no of sql 2000?
Answers were Sorted based on User's Feedback
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition
How do I create a stored procedure in dbml?
Does union all remove duplicates?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is the process of normalization?
What are the acid properties?
What is deploy, process and build? : sql server analysis services, ssas
What are the different types of replication? How are they used?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is difference between createstatement and preparedstatement?
How to receive output values from stored procedures?
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)