|
|
-
rajasekhar Liked 2 Years ago through Syndicated Blogs | 1 Point
When a transaction happens, say for an example data is bening inserted, there are mainly two things happens:
1. data page in the buffer cache is updated.
2. Data is written to the log cache.(This is to ensure the ACID property incase of any rollback...
|
|
|
-
rajasekhar Commented 2 Years ago through Syndicated Blogs | 1 Point
Hi ,
I Think there is no sp_who3,its sp_who2 ( typo error),please check ....
|
-
rajasekhar Liked 2 Years ago through Syndicated Blogs | 1 Point
This Performance Analysis Case Study looks at UPDATE statements on very large tables
and how to use Disable Index and Rebuild Index for performance gains.
A developer was executing an UPDATE statement on an ETL staging tabl...
|
|
|
-
rajasekhar Liked 2 Years ago through Syndicated Blogs | 1 Point
Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis...
|