Category: SQL

Tune MySQL and MariaDB
article #790, updated 820 days ago

Here’s a good place to start:

http://mysqltuner.com/

Categories:   SQL   

==============

Effective MS SQL Database Maintenance
article #784, updated 846 days ago

An interesting article:

https://technet.microsoft.com/en-us/magazine/2008.08.database.aspx

Categories:   SQL   

==============

Download SQL Studio 2008 R2
article #761, updated 930 days ago

Go to this page:

http://www.microsoft.com/en-us/download/details.aspx?id=30438

which looks like it is for SQL as a whole, check the downloads list; the ones you want are near the bottom.

Categories:   SQL   

==============

Download SQL Studio 2008
article #760, updated 930 days ago

Go to this page:

http://www.microsoft.com/en-us/download/details.aspx?id=30438

which looks like it is for SQL as a whole, check the downloads list; the ones you want are near the bottom.

Categories:   SQL   

==============

Automatic Microsoft SQL backup job settings
article #562, updated 1432 days ago

Open SQL Studio, under the server, Management, Maintenance Plans.

Categories:   SQL   

==============

SQL Server 2008 internal backup
article #272, updated 2302 days ago

In SQL Studio for SQL 2008, under a database object, go to Management, then Maintenance Plans. If you double-click on an item under there, you’ll see a Visio-like flowchart; double-clicking on any of the items will permit reconfiguration.

Categories:   SQL   Servers

==============

Move an SQL Server transaction log
article #224, updated 2418 days ago

A very good series of steps, actually one command-line and one GUI, are here:

http://www.mssqltips.com/tip.asp?tip=1774

Categories:   Servers   SQL