Hot answers tagged

2

Starting at the beginning: SQL Server uses statistics objects to generate cardinality estimates for the result set steps during the optimization phase. Cardinality estimates are used to generate a query plan, which is the logical plan by which SQL Server will physically access and retrieve the data in order to satisfy the request. Generally speaking, more ...


1

Try making your user account a member of the msdb database's SQLAgentReaderRole. The rights granted by that role membership are described here: https://msdn.microsoft.com/en-us/library/ms188283.aspx Look at the description of rights under SQLAgentReaderRole Permissions. You will see that it has rights to read the information on the jobs. This does not ...


1

What version are you running? 5.6 doc gives the details: innodb_flush_log_at_trx_commit can be set (1) on the commandline, (2) in my.cnf, or (3) via SET GLOBAL. sql_safe_updates can only be set via SET SESSION or SET GLOBAL. Note that SET GLOBAL does not impact anyone currently connected (including yourself). It will effect anyone connecting later, but ...


1

As the other two answers correctly state, Assemblies are loaded into a particular database and are not system-wide (though I'm fairly certain that the assembly_id value is unique system-wide). This means that they are backed up, and restored, with each database that they are loaded into. Also, the enabled / disabled setting of CLR Integration (via ...



Only top voted, non community-wiki answers of a minimum length are eligible