Fernando (7/30/2008)

---

Thank you to everyone for their input. Rebuild the indexes is a maintenance tasks and it runs weekly. Memory difference? That might something else. I have 1.5 of RAM...

You can get this information from the INFORMATION_SCHEMA.TABLE_CONSTRAINTS and INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS views.

Is this one-way or two-way replication? Is it Immediate Updating or Queued?

Jack Corbett (7/30/2008)

---

Michael Taylor (7/30/2008)

---

I would tend to disagree with this editorial in almost every way. The only real argument I saw as viable was the point about creating...

Shaun McGuile (7/30/2008)

---

Jack Corbett (7/30/2008)

---

Michael Taylor (7/30/2008)

---

I would tend to disagree with this editorial in almost every way. The only real argument I saw as viable was the point...

Brian Knight (7/29/2008)

---

I use a combination of a tool called Zoomit (free from SysInternals.com) to zoom in and out. Camtasia does all the recording with the highlighted cricle and click...

By the way, if you have SQL Server 2005, you should be posting in the SQL2005 forums. 🙂

CTE's are as safe to use as anything. They scale up just fine (assuming they are not recursive). The real limitations are in the overall query, not in...

By the way, I have my doubts that checkpointing is the "Cause" of this. It may be controlling when it happens, but even if you had no write-caching, I...

Checkpointing is controlled by the Recovery Interval setting which is usually 60 seconds. What is yours set to? Microsoft does not recommend raisning this value because it can...

MrBaseball34 (7/29/2008)

---

[highlight="Yellow"]EXEC @ReturnID = rr_Insert_ptEncounterDetail[/highlight]

when called in other procedures returns the valid value.

Here is how we are doing it in the abovbe procedure (simplified):

CREATE PROCEDURE rr_Insert_ptEncounterDetail

@ptEncounterDetailID int

AS

BEGIN

...

Chris Morris (7/29/2008)

---

create...

No, that is not...

FYI: In general the proper palce to put OUTER JOIN conditions is in the OUTER JOIN's ON clause. Though it will also work (and sometimes is faster) to...

Timmer (7/28/2008)

---

The LDF is 7 GB. The MDF is 350GB. Does that mean 7GB is the size it needs to be or is 7GB the biggest it has...