how do you determine the Load performance of any query in
sql server {example how do u determine performance of a
select stmnt which returns Dynamically many no of records
... some times 100,1000,10000 etc., }
No Answer is Posted For this Question
Be the First to Post Answer
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
Can we drop user if user mapped to any logins
Explain what are the basic functions for master, msdb, model, tempdb databases?
How to bind a view to the schema of the underlying tables?
What are different types of Keys? Please explain all the keys with a suitable example.
Can XML be used to access data?
What to perform pattern match with the like operator?
Can we update data in a view?
What does executeupdate return?
How can I tell if sql server is 32 or 64 bit?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
What is Trigger?
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)