rf44 (10/25/2012)

---

Eric M Russell (10/25/2012)

---

rf44 (10/25/2012)

---

Any idea why, when I try to use it, I receive a message:

Line 18 is:

CROSS...

rf44 (10/25/2012)

---

Any idea why, when I try to use it, I receive a message:

Line 18 is:

CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) as b...

nevhancock (10/25/2012)

---

When I run this, the Name of the sp doesn't even exist in the db its matching to. The query text doesn't match the name either. All I was...

The DMV dm_exec_query_stats returns cached query plans, and in...

opc.three (10/23/2012)

---

Eric M Russell (10/23/2012)

---

Instead of separate denormalized columns, I'd rather contain user defined attributes in an XML column, preferably in a seperate extended type table. In the example below,...

Instead of separate denormalized columns, I'd rather contain user defined attributes in an XML column, preferably in a seperate extended type table. In the example below, each extended type (regular,...

Fraggle-805517 (10/19/2012)

---

...

Now, I don't know if this is really called parsing or replacing or something completely, different, but I have a hard time believing that someone hasn't done this before....

CptCrusty1 (10/19/2012)

---

Master Moden,

Absolutely she did... she rolled her eyes as dramatically as possible at the answers to her questions in that area.

Alas... She took a different offer. ...

CptCrusty1 (10/18/2012)

---

UPDATE!!!

Ok... We interviewed 2 candidates that seemed to have plenty of exp. C1 had 17 years of verifiable exp, checked his references, etc. Candidate 2 had FIVE...

SQLRNNR (10/17/2012)

---

I had never considered scheduling a block of time for interruptions by coworkers. Interesting concept. I'm not sure I could do that. But I agree that...

Sqlsavy (10/15/2012)

---

Hi all,

We've a small database (1 GB) and SQL 2005 server is clustered one. Now Business is forecasting that database will be accessed by million users by early...

Accidental DBA: an application or user account that's been granted...

ChrisM@home (10/17/2012)

---

Eric M Russell (10/15/2012)

---

You can simulate the functional equivalent in SQL Server 2000 less gracefully like so:

select C_RECID, H_RECID from

(

select C.RECID C_RECID, H.RECID H_RECID,

(select count(*)...

Don. (10/13/2012)

---

Hi Guys,

Unfortunately neither of those scripts worked as there are multiple identical accountno and lastdate fields. Ideally Id need to filter on the History tables Recid field.

...

...

In my example...

TravisDBA (10/12/2012)

---

Miles Neale (10/12/2012)

---

Meetings can be good. However, they need to be short, to the point, make decisions, and not be rambling sessions where everyone gets their say three...