kaushal_shah26 (8/19/2012)

---

In my stored procedure, I create a temp table from table A. Then I modify data on the temp table. I wan to insert the data from temp table...

Database performance is what you want to tackle.

Be sure you understand execution plans and wait events. Be...

Lynn Pettis (8/9/2012)

---

That's where you build a database agnostic DAL and your actual database layer is written to support the RDBMS of choice. To provide a system that performs...

newbieuser (8/6/2012)

---

We need to refresh the data from Oracle database to SQL Server 2005 every hour or so.. We have a linked server from SQL Server database to Oracle.. Can...

SREERAJ. R (8/8/2012)

---

Hi,

As per the business requirement, any SQL script that I make should follow ANSI standard, so that it should successfully execute in both SQL Server 2005 and Oracle....

Let's go to the basics... do you have a proper E/R model for the workflow system?

In most cases each Entity in the E/R model would translated into a physical table...

As a rule of thumbs it should be an index per each dimension pointing to a specific fact table.

Remember that the function of the dimensions is to provide the means...

Long time ago I was a Project Manager in the old sense of the term - at that point in time the "Project Manager" was a Sr Systems Analyst in...

VygonDBA (8/3/2012)

---

...I don't feel that I'm getting the exposure to some of the more challenging issues DBA's are forced to deal with (i.e. data corruption, deadlocks, disk I/O problems, performance...

aadee2ak (8/3/2012)

---

We are currently working on a cloud product. We had a couple of internal meetings about cloud products replacing some old solutions. What solutions do you think will disappear?...

Just for documentation purposes I wouldn't name my TEMP tablespace TEMPDB 'cause it feels like the SQL Server concept of tempdb which does not exist in the Oracle world.

Space allocated...

Monitor the system at 23:40 - see from where the process is connecting to...

surma.sql (8/2/2012)

---

PaulB-TheOneAndOnly (8/2/2012)

---

surma.sql (8/2/2012)

---

hello

I have very wired problem

I schedule my back up at 3:00 AM everyday.and it store backup to different server.

now last 7-10 days I notice, there is...

surma.sql (8/2/2012)

---

hello

I have very wired problem

I schedule my back up at 3:00 AM everyday.and it store backup to different server.

now last 7-10 days I notice, there is one more...

lianvh (8/2/2012)

---

...our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather invest in...