IceDread (11/8/2011)

---

The only advantage ms sql server has over oracle is it's price. Some would perhaps make an argument for the user interface as well. If ms sql server were...

We've talked about CPU and power usage at the server and network infrastructure level, but the bulk majority of utilization is at the client level. Stuff like Flash, Java, Silverlight,...

JJ B (11/7/2011)

---

If you are interested in monitoring your electric usage, you may want to check out the following, The Energy Detective (TED) which I installed in my house. ...

Indeed, rowset cursors are destroying the planet and a threat to mankind. It's time we stopped beating around the...

One technique the police could use to catch these guys is to get hold of a bunch of cheap non-functional laptops, install them with a GPS tracking device, and then...

Don Bricker - Illinois (10/31/2011)

---

We have a SQL Server 2008 instance in which someone took a database offline couple of weeks ago. I have identified the SPID from the Log...

dm_tapas (11/1/2011)

---

The below stored procedure is taking around 1 hours to execute. but it should not take this much time.

Can some body tune this and tell me...

randy.worrell (11/1/2011)

---

JamesMorrison (11/1/2011)

---

Why are people complaining about the GUI for SQL Server? At least we have a GUI that actually works.

Oracle DBAs are still complaining (for my entire 11 year...

GilaMonster (11/1/2011)

---

The 8-byte RID is only used in...

If the clustered index is on a non-unique key, then...

dva2007 (11/1/2011)

---

if there are more records with the same date in the table, can i create clustered index on that field?

We have 5 years records and the same day have...

As for comparing the cost of hiring a fulltime staff DBA versus the cost of purchasing higher end hardware, the DBA has more value if he/she has expertise in other...

dva2007 (11/1/2011)

---

thanks all for your comments.

As i said i do understand how the table is structured with the index but i am still bit confused.

I have a table which doesnt...

L' Eomot Inversé (10/31/2011)

---

Eric M Russell (10/31/2011)

---

As for the remark

EdVassie (10/31/2011)

---

"The rise of large-memory and large-corecount servers, coupled with the impending tidal wave of SSD storage, means that good...

EdVassie (10/31/2011)

---

Going back to the OP "Where are the good Senior Level DBAs", my experience is there are less people who fit this category than there used to be.

The industry...