Try this link

Digs (6/7/2011)

---

Hi,

I have two large tables that get updated daily or (added to).

I want to run this TSQL daily.

ALTER INDEX ALL ON DIM_Data REORGANIZE

and

DBCC SHRINKDATABASE (MyDB,10);

Say I have...

Start with SQL server DBA book. Microsoft MCITP books. Some people feel that is helpful. We need some basic knowledge to follow the terms there. Basic knowledge in T-SQL...

try the link below

wobblegobble (6/9/2011)

---

Pre 2007. I have selected ODBC as the datasource. Built a new connection string (not sure if it is file data source or machine data source, I have tried...

zaleeu (6/9/2011)

---

Hi, I would like to export data from database A to Database B .

Database B must be identical in structure but it must only contain data

if the...

Difference Between the MERGE and MERGE JOIN

MERGE - similar to JOIN operation. Only joins only two inputs. If there are more than two inputs UNIONALL is used

MERGE JOIN - select...