Create two jobs named "Revoke Access to A from test" run at 10 AM with @command=N'REVOKE INSERT,UPDATE,DELETE on OBJECT::test from A' and "Grand Access to A on test" run at 1 PM with @command=N'GRANT INSERT,UPDATE,DELETE on OBJECT::...

As per scenario table in database is heavily fragmented, due to this size of database is automatically grown. So first thing is need to put concentration on size of database. You can do this by de-fragmenting table by two ways. 1. Reorganize Index ...

Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...

Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...

Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...

Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...

**RAID 0:** improves read and write performance by spreading operations across multiple disks, no redundancy, does not compete for processor cycles, no fault tolerance. **RAID 1:** Its fault tolerance and generally improves read performance but may d...

if two identical queries posed by the same user using two different sessions with the same session options arrive at a SQL Server simultaneously, two query plans exists while they execute. However, at the end of their executions, plan for only one of th...

Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compared

However, bulk-logged recovery model minimally logs **bulk oprations,the log backup contains both log records and the data pages** that were changed by bulk operations. This is necessary to capture the results of the bulk-logged operations. The formed da...