dwmllr (10/8/2010)

---

I need to get and integration solution to run on both SQL Server 2005 and Oracle instances of the same database. The Oracle DB exists and I created...

Raunak Jhawar (10/7/2010)

---

PaulB-TheOneAndOnly (10/7/2010)

---

Raunak Jhawar (10/7/2010)

---

Data mining is a bundled package which comes with Business Intelligence. It is not different from BI. Most important, BI is not a product it...

Let me ilustrate with a purchasing pattern discovered in a major drug store chain.

1-Pattern: "from 9pm to 6am 90%...

Now it works 😉

Mad-Dog (10/7/2010)

---

I've a table with 20 mill records.

when i run this simple query but with the sp_executesql the query run for 30 sec

when i run the with out the sp_executesql...

Could be much worse 😀

SQL Server 7 was the first version written from scratch by Microsoft, as somebody poiinted out in a previous post SQL Server 2000 is kinda of...

Raunak Jhawar (10/7/2010)

---

I...

... and the question is? 🙂

saurabh.deshpande (10/7/2010)

---

Hi Paul

Thanks for Short explanation about Oracle RAC.

...

Reo (10/7/2010)

---

SQL Server Logs some Informational messages in error log. I have found like "This instance of SQL Server has been using a process ID of 1588 since datetime"

Does we...

At high-level Oracle RAC is a technology that allows for...

Currently SQL Server provides nothing comparable to Oracle RAC

Brian McGee-355525 (10/7/2010)

---

I have an SP that works on a few thousand rows at a time, and as part of its work, does multiple inserts and updates.

The Merge statement would...

hallidayd (10/7/2010)

---

I am rephrasing Paul's answer in a way that makes sense to me - ignore if you've already got it.

A foreign key is a constraint - it restricts the...

If the system is performing well meaning, as it used to do - I wouldn't be really worried about the metric. I'll probably open...