Viewing 15 posts - 1 through 15 (of 2,837 total)
This is how I see it. PASS has become a corporate machine. I was very much involved in PASS for a very long time. In the beginning everything was peachy....
June 19, 2020 at 12:53 pm
You could always use Standard edition for subscriber which is not that expensive for reporting and use Transactional replication.
December 10, 2018 at 5:11 am
You can take a look at sys.sp_identitycolumnforreplication
December 10, 2018 at 5:03 am
There are times the queries take bad plan if the IN parameter datatypes does not match the table definition. Do you have any control over the code in the OLTP...
December 10, 2018 at 5:00 am
Thank You. This is the best suggestion I have so far and makes sense. I have been asking it on twitter too and did not get any good suggestion.
September 11, 2017 at 10:13 am
1 Mil is a pretty good number. When we look at Sentry we do see around that range write bytes on our Env.
On another note, will you be at...
October 19, 2016 at 7:22 am
Under what user is the service running? Under your name or a service account. If the service is not running under your account, it does not matter whether you have...
November 13, 2015 at 7:08 am
Did you take a copy of the files before you deleted?
Like Gail asked, did you check the permission before you deleted those files?
November 13, 2015 at 5:30 am
What is the user under which the SSIS is running? The target server and host server, does it also have the same username and password?
November 12, 2015 at 11:18 am
You can make it granular...
You could give just execute permission on sp_help_jobhistory (They need to know the name of the job I think)
Or give them select permission to sysjobhistory...
November 11, 2015 at 7:42 am
Give access to the role SQLAgentReaderRole is MSDB Database.
November 11, 2015 at 7:08 am
Since all the disks are SSDs we did not think of separating the TxLog into a separate LUN. We have seen ASYNC Network IO Waits but never Disk IO. That...
September 1, 2015 at 12:41 pm
It wasnt log back up for sure. This happened at 11:44. Our Log back up runs at 11:55. The batch request per second never went more than 1600 per sec...
September 1, 2015 at 12:15 pm
Thanks for the info... 🙂
December 24, 2014 at 5:09 am
Thats a tough question... Who audits the auditor. I have never worked with Guardium yet. There is no way anyone can manipulate the data when using Guardium?
December 19, 2014 at 11:08 am