New answers tagged

0

Do you define "different content" as row filtering via security settings? That is pretty standard - and pretty unusual (as in: standard for high security, not all databases support this thinking)... SQL Server for example is just adding this with version 2016 due this year. In most cases... people do not bother as the filtering of what data is visible is ...


3

So apparently network packet size setting in sp_configure was changed up to 32kb when it needed to be under 16kb. Once I reconfigured the setting, the jobs ran successfully. Who would have thought...


1

I don't think so. These settings are stored along with a bunch of other UI configuration in a binary file in your user profile directory.


1

Ste, what you are wanting is a point and click solution or a setting somewhere. Unfortunately, none of these currently exist in "off the shelf" form. It would be realllly nice if Microsoft included this in the connection settings for a Registered Server so it could be saved, but alas they do not. This leaves you with one of two options: Write Something ...


2

I don't have an answer to your entire question (though I gave an answer to a similar question today http://dba.stackexchange.com/a/137844/36812) but you mentioned that using ApplicationIntent=ReadOnly doesn't work properly. Have you set up read only routing URLs? Because it's not done out of the box and if you don't do it then these settings and that flag ...


0

On a terminal, type systemctl cat 'postgresql*' That will show you where the PGDATA environment variable is pointing to when you start the service normally via systemd, and all the parameters used for starting and stopping the service.


1

There was a broken link in that wiki page (which I've just fixed), but it was supposed to take you to http://docs.phpmyadmin.net/en/latest/setup.html#linked-tables Basically, they're additional features including bookmarked queries, comments, SQL-history, tracking mechanism, PDF-generation, transformations, relations, and more. By adding the tables (which ...


3

As detailed in this MSDN document, the port number must be unique within any given computer: Note that if more than one server instance on a given computer requires a database mirroring endpoint, specify a different port number for each endpoint. TCP ports can only be served by a single process. When you try to create two endpoints with the same ...


0

Check for high traffic users using MyISAM or ARIA table engine. I run CloudLinux cpanel boxes and even with CPU throttling a single high volume user with lots of writes to MyISAM table can lock the whole server up.



Top 50 recent answers are included