Viewing 15 posts - 76 through 90 (of 859 total)
January 7, 2019 at 12:47 am
Change the job timing, where you have low activity.
Enable trace flag 1222,-1 to gather information in the log to review later.
January 6, 2019 at 12:14 am
December 30, 2018 at 10:30 pm
December 30, 2018 at 10:26 pm
December 26, 2018 at 4:25 am
Michael L John - Wednesday, December 19, 2018 10:03 AMInstead of re-inventing the wheel, take a look at these tools:
I...
December 21, 2018 at 2:30 am
December 20, 2018 at 4:52 am
You can write a dynamic SQL script for both backup and restore by using a system tables.
December 19, 2018 at 7:16 am
We are using SQL Server 2012 having Always on High Availability setup ( Active -...
December 19, 2018 at 7:14 am
December 19, 2018 at 2:05 am
In the plan 50+ percentage of cost going to key lookup for the table - [s_stkdetl]. You have to review the existing index and need to create a non clustered index...
December 13, 2018 at 10:21 pm
December 12, 2018 at 7:55 am
I am using Ola Hallengren's script for DB integrity so I tested the script...
December 12, 2018 at 7:46 am
Viewing 15 posts - 76 through 90 (of 859 total)