Tom Brown (9/13/2010)

---

I'm used to SQL Server. Oracle syntax is a bit different. I have Oracle SQL Plus (v9). I've solved most of my problems but need help...

Does...

r.desort (9/15/2010)

---

*ninjaedit: crazy because it's called letch, not latch 🙂 sry

Hi folks,

we have installed a brand new 2008 Sql Server. After moving our databases we discover an performance issue:

Sometimes the...

Jeff Moden (9/12/2010)

---

Owch! Sorry... That's just some plain ol' bad advice, Paul. Table Variables can be a huge performance problem if any size to them occurs especially since...

sporoy (9/12/2010)

---

Hi, we are having blocking issues with tempdb database, blocking transaction is open for 30 minutes and has create table #Table statements in it, because of this...

Dung Dinh (9/12/2010)

---

I have a question and want a support

Can we create a Non-Clustered Index which contain a field which is key in Clustered Index

Eg: I create a table has...

serhan2uk (9/9/2010)

---

I work for a company that provide services and data solutions, data warehouse/ data mining. Servers held on internally and data warehouse developed internaly for the client, and all...

gmamata7 (9/10/2010)

---

I want to use Backup/Restore method for the first time and then I want to refresh the data only from Production database. So in this case which method...

mannaggia (9/5/2010)

---

I have a SQL 2005 database with tables that gets wiped every night (some tables TRUNCATE'd, others DELETE with no WHERE).

Then several of the tables are (for the most...

Check the web for version...

mohammed moinudheen (9/5/2010)

---

After installing the default instance of the SQL Server 2008 R2 eval edition, I tried to install

another named instance. But I am getting below error message. Could...

Jeff Moden (9/4/2010)

---

Heh... ask their Oracle DBA's about that. Of course, that's if you can get their attention on the subject. Most of the Oracle DBA's I've run...

I assume you meant 8i. Oracle v8 is actually two very different animals - what we call 8 - a transitional...

Lynn Pettis (8/31/2010)

---

Found some resources, SQL Reference Guide for Oracle 10g. Guess what, Oracle actually has CTE's, they just don't call it that in the reference manual.

Having access to...

fmurphy (9/2/2010)

---

I've got a problem similar to this contrived example: I need a function/code snippet/whatever to help a large sports marketing firm assign an agent code to each of their...