Tagged: server

November 16, 2010

Creating a Linked Server in SQL Server for a MySQL database

This document describes how to create a Linked Server reference in SQL Server which points at a MySQL database, and how to query through the Linked Server connection. 1. Download the MySQL ODBC driver...

Database

April 14, 2010

How to rebuild every single index in an MS SQL Server database

When you perform any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. When changes are made to the data that affect the index, index fragmentation can occur and the information...

M	T	W	T	F	S	S
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

Tagged: server

Creating a Linked Server in SQL Server for a MySQL database

How to rebuild every single index in an MS SQL Server database

Categories

Tags