SJanki (8/1/2011)

---

I am also able to call it from .NET application using System.Data.OracleClient and the connection string.

But due to some limitations I have to call it from the SQL Server...

Is RPC enabled on the linked server?

No. They are not one and the same,...

John Paul-702936 (7/27/2011)

---

- how to get the Last 30 days records from a table in Oracle if the column is in format string -

like

Example - the value...

mmmhhh... TimeStamp data type columns may be a deal breaker, check this: http://msdn.microsoft.com/en-us/library/aa933141(v=SQL.80).aspx

nahk.fussuy (7/29/2011)

---

Funnily enough that is how we left it, With the analyst to go back to the biz to see how important history is for this.

I suspect the answer...

Indianrock (7/28/2011)

---

How many of you get some form of compensation for having broadband at home so you can handle after-hours work remotely? Is anyone being provided with an air...

jmorgan 12692 (7/29/2011)

---

one more question pertaining to this....when my NT Backup runs it is gonig to copy that entire 250GB file to backup...do you just let this happen? When...

It works that way by design.

Can't fix what is...

Barkingdog (7/29/2011)

---

This sql extract (from an update statement) causes our tempdb database to grow to 500GB (as well as takes hours to grow that large)

...

inner join <table2>

on AcYear = cast(Year(LDate)...

In simple terms a Data Warehouse is a database designed to serve as a central, historic data...

I'm with you, a SCD of the Type 2 has to be tracked on the DIMension table, that's why we call it Slowly Changing Dimension 🙂

On my experience SCD2 tracking...

That's proprietary code...

Sean Lange (7/27/2011)

---

I often tell business people (which are the ones that usually ask for this kind of silliness) that primary keys are used by the system and therefore are...

robertprice45 (7/18/2011)

---

In regard to physical tape/drive backups, what are the mandatory regulations relating to data backup. I'm aware of standards such as FDA and SOX compliance, but I believe they...