New answers tagged

0

It seems to me that you're falling into an XY Problem. You want to see the data from lots of different databases, and have the mindset that you should only connect to a single database. That line of thinking logically lead you to the conclusion that you need to bring all the information into one central database. IMO your real problem is needing to see the ...


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

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 ...


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 ...


0

If you have AUTO_UPDATE_STATISTICS on, then yes, your statistics should update once 20% of the data has been modified. But, if you know it's this process that's throwing your statistics out of whack, you can also update them yourself after the process has run. https://msdn.microsoft.com/en-us/library/ms187348.aspx Call UPDATE STATISTICS on the affected ...


0

The type of error that you are getting (i.e. Collection was modified;) is most likely caused by sharing the collection across multiple threads. If the variable holding the collection is defined as static, then that variable is not thread-safe since all sessions share the same App Domain for all Assemblies in a particular Database that are owned by the same ...


-1

I would suggest to use SSIS for this task.


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 ...


-3

Command line would be the easiest way.to over come this is exporting data from database as a text file then importing text file to another database.you can look to this. http://stackoverflow.com/questions/11407349/mysql-how-to-export-and-import-an-sql-file-from-command-line


0

What about using one of the existing ETL tools? Talend ETL or Pentaho Data Integration are two examples (performance-wise PDI is better). You can design an ETL job then schedule to run it as you like.



Top 50 recent answers are included