Someone mentioned updates, and that has my vote for causing the fragmentation. If you update a variable field with a value that is longer than the original value, you...

And...

GSquared (11/17/2009)

---

TheSQLGuru (11/16/2009)

---

GSquared: did you try hard-coded space-strings instead of the pile of replicates? I would HOPE the optimizer would expand those on compile, but if it doesn't...

GSquared: did you try hard-coded space-strings instead of the pile of replicates? I would HOPE the optimizer would expand those on compile, but if it doesn't that should...

I think the trigger issue has the potential to zap a lot of unsuspecting MERGE users.

I also think that TVPs will...

bell282 (11/15/2009)

---

my server has very high CPU (between 90 - 100%) when certain processes run. However, if i profile what is going on with the server, SQL seems to...

newjcb (11/16/2009)

---

I starting writing this reply saying that this isn't very efficient at all...

However, after I tested it with large strings (I used the HTML source of the article as...

Please provide information from sysfiles for this database. Also run dbcc sqlperf(logspace) and provide the data for the log for this database.

Good solution Jeff, and well documented. However, I was a tad disappointed that you included the LTRIM(RTRIM(. That is unnecessary overhead that is unrelated to solving the stated...

abhijeetv (11/16/2009)

---

BOL (2005) Says:

TRUNCATE_ONLY option with BACKUP, Removes the inactive part of the log without making a backup copy of it and truncates the log by discarding all but the...

CA sells ERwin while IBM sells Rational Rose as part of their tools in software engineering companies these tools are in a network folder for developers to use and in...

Gift Peddie (11/14/2009)

---

TheSQLGuru (11/14/2009)

---

Guess we will have to agree to disagree on this one. In my world, 93.7% of the developers will take the easiest way to slap code...

SQLNewbster (11/14/2009)

---

Here is the sequence of things that have occurred and/or a summary of the information:

1. I am working with a vendor's backend system, using that data to do...

1) Confio

2) SQL Sentry Performance Advisor

The best one is actually ME! 😎

Let me see if I have this right: you are dumping 120K relatively fat rows into a TEMPORARY TABLE then selecting those rows back out and it is taking...