chrisph (4/24/2012)

---

Anyone have experience with tracing with Oracle, SQL Profiler is so easy but I'm a bit lost with Oracle. All I need is to see which users are...

Abrar Ahmad_ (4/24/2012)

---

[font="Verdana"]Do we can list down the basic difference in data types of different DBMS like Oracle, SQL, MySQL and DB2, while keeping in view the migration cost minimum?...

markpc2009 (4/13/2012)

---

I need help and pointing in the right direction!

I have a database which is recording employee hours and a spreadsheet that contains additional informtion on how these hours were...

To which port SS2K5 says it is listening to?

To which port SS2K8R2 says it is listening to?

Is SS2K8R2 up?

Can you connect localy to it?

Can you connect remotely to it?

lorne 64075 (4/21/2012)

---

I am very new to SQL Server programming and am finding lots of tutorials and information on the SQL language itself. I have played around a bit...

ppcentral (4/19/2012)

---

@paul-2,

I understand your perspective... and was an interesting answer. But the reality is that you have these agregate tables in real world scenarios assuming the role of a fact...

Well... there is no question asked on your post 😀

Dj463 (4/19/2012)

---

@paul-2, Thanks for the reply

Yes, it is a recurrent process ocuuring every three months to move data older than 3 months to archive database on another server and delete...

tauseef.jan (4/20/2012)

---

I have a similar question.

I tried creating a partition on a table in sql server 2008 R2.

But i do not see the storage option when i right click the...

Lets start with the basics... is there enough space to accomodate the restore?

1- May just add to the missery while...

Check SQL Sentry... http://www.sqlsentry.net/event-manager/sql-server-enterprise.asp

Felicia Coons (4/17/2012)

---

I've been asked to look at load balancing mainly because of the poor (and inconsistent) design of the databases as well as the present server configuration. I also...

Locks acquired by INS/UPD/DEL statements stay put for the lenght of the transaction therefore a system that has transactions taking as much as 30 seconds...

select

ID,

SITE_ID,

TO_CHAR(WHEN_OPENED,'MONTH,YYYY') MONTH_DATE

COUNT(*) OPENCOUNT,

from

OPEN

where

WHEN_OPENED is not null and...