Shurkadze (8/22/2011)

---

PaulB-TheOneAndOnly (8/22/2011)

---

Shurkadze (8/22/2011)

---

PaulB-TheOneAndOnly (8/22/2011)

---

Shurkadze (8/22/2011)

---

The DW contains small subset of columns of OLTP. Relying on timestamp may not be meaningful since only a small subset of columns changed should...

Shurkadze (8/22/2011)

---

PaulB-TheOneAndOnly (8/22/2011)

---

Shurkadze (8/22/2011)

---

The DW contains small subset of columns of OLTP. Relying on timestamp may not be meaningful since only a small subset of columns changed should trigger load...

Shurkadze (8/22/2011)

---

The DW contains small subset of columns of OLTP. Relying on timestamp may not be meaningful since only a small subset of columns changed should trigger load into DW.

Why...

Shurkadze (8/19/2011)

---

We have a transactional database with every table containing create_date and update_date columns.

We designed a data warehouse and developed ETL process (initial and incremental).

Is it a valid concern to...

Good for you! 🙂

krishnakumar-293737 (8/21/2011)

---

Is SQL Server dba a good career especially...

ESAT ERKEC (8/22/2011)

---

I tried this also.....

DBCC FREESYSTEMCACHE ('ALL')

DBCC FREEPROCCACHE

DBCC SHRINKFILE('tempdev', 1000, NOTRUNCATE )

DBCC SHRINKFILE('tempdev', 1000 )

DBCC SHRINKFILE: Page 1:3376992 could not be moved because it is a work table...

Please check SQLServerCentral thread at http://www.sqlservercentral.com/Forums/Topic1087892-1044-1.aspx

Michael.Gagne (8/19/2011)

---

Hi there,

I'm working on a Windows 2008 server (64 bit), SQL 2008 R2 (64 bit) and I've installed Oracle 11g (64 bit).

My data source is an Oracle 10g database.

I...

I'm with David - I don't understand either what flexibility or advantage you think XML will bring to the table in a data warehouse environment.

In my case I'll suggest to...

newbieuser (7/27/2011)

---

Hi all,

We have a select for update query in Oracle, to xlock the rows in the select statement before the update statement..

select * from slm where area_code='SI' for...

sirzatkoc (8/18/2011)

---

I have been working on SSIS SSRS projects more than 3 years.

Now i wonder how to develop similar projects for oracle. I'm planning moving my career way to oracle

but...

hwells (8/18/2011)

---

My company uses software from a cloud based vendor. All data relevant to the application is stored with them. We have read only access to the SQL Server data...

In this context "performance" is not our day-by-day performance but the...

The size of a full backup should be about the size of all pages within allocated extents plus...

Stamey (8/17/2011)

---

I need to clear this up in my head, after reading what I could find with a search.

I know that the "GO" statement is an OSQL command that separates...