Viewing 15 posts - 196 through 210 (of 241 total)
phew.. figured out, I have created one certificate on one of the SQL server and took backup of it, then i restored that certificate to rest of the servers for...
July 21, 2017 at 11:15 am
you can also use visual studio for data/schema comparison
June 30, 2017 at 4:28 pm
There are some limitation when registering database as Data Tier App, I will let you google that info or wizard will help you identify unsupported features, but yes it is...
June 30, 2017 at 4:25 pm
no sir
June 1, 2017 at 4:37 pm
February 16, 2017 at 12:37 pm
I can not tell you what/which transaction caused it, however to shrink log file you have two options
1. you need to take backup of transaction log file and then...
February 13, 2017 at 9:50 am
did you compare the transaction log file sizes?, I suspect it would be log file
February 13, 2017 at 9:18 am
February 11, 2017 at 10:18 am
you dont have to reboot to shrink tempdb, you can always use shrinkfile or shrink database, in case tempdb does not shrink then you can use dbcc freeprcchase after issuing...
February 11, 2017 at 10:14 am
February 10, 2017 at 6:32 pm
use your dev server, and simulate production load on the box before and after CDC to measure the impact.
February 10, 2017 at 11:24 am
my two cents, by spreading database data-files to multi-pal files you can still gain SOME performance improvements as the OS has to use multi-pal separate threads to read/write to the...
February 9, 2017 at 4:34 pm
you can use this trace to create a baseline may be using PAL (performance analysis tool) and use it for future problems. here is the reference how to use it...
February 7, 2017 at 1:56 pm
Viewing 15 posts - 196 through 210 (of 241 total)