Define Check points and End Points?
CheckPoints:Whenever we perform any DML operations in the
database,it will go to the checkpoint and then commit in
the database.If we don't have checkpoints,the data will get
store in transaction log file,once it got fill full,it will
make the database performance issues.
Endpoints:Endpoints are objects that represent a
communication point between the server and a client.
Is This Answer Correct ? | 4 Yes | 0 No |
how can we know that how many users are connected in perticuler server??????
What are locks in sql?
What is the difference between resultset and resultsetmetadata?
What are various aggregate functions that are available?
What is master database? : SQL Server Architecture
What is Self Join?
Can we use having clause without group by?
What is lock escalation?
What is the difference between executequery () and executeupdate ()?
How to find 6th highest salary from Employee table ?
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
What happens if the update subquery returns multiple rows in ms sql server?