GSquared (7/8/2008)

---

Just to test this, I tried the following on a table with just over 1-million rows of data:

(...)

I had used fast_forward in the past, based on what BOL says,...

JohnG (7/8/2008)

---

I'm not so sure that the "independent" testing is accurate. Therefore, for purposes of this question, the time it takes to create a copy of all of the...

Christian Buettner (7/8/2008)

---

In general an interesting question, but it is simplified a little too much. Cursors are such a complicated construct with so many nested options and dependencies on the...

Hi David,

My main gripe with dynamic...

Craig, John, Grant - thanks for the feedback.

As I've already indicated elsewhere in this discussion, I was wrong, due to incomplete testing. Both STATIC and FAST_FORWARD should be considered correct...

Mark,

If possible, try eliminating the cursor completely rather than rewriting it using other options.... 🙂

Hi Marius,

Mostly good, solid code, but there are a few caveats:

Select distinct sysobjects.id, name, type

from syscomments, sysobjects

where syscomments.id =...

davidthegray (7/8/2008)

---

Does anybody have a ready made query to find out the list of all the stored procedures in a db having the word 'CURSOR' inside their SQL body text?...

Dave F (7/8/2008)

---

A very worth while read, but I'm not sure if I agree with the conclusion that STATIC is always faster than FAST_FORWARD. The table fitting in cache...

Iggy, Marius, Mark: Thanks for the kind words! 🙂

This is the first time I submitted a QotD, but with reactions like this, I'm sure I'll try to submit some more!

JohnG (7/2/2008)

---

1. I believe that the term "deparated" used in the QoTD was meant to be "separated" (the letter "d" and the letter "s" are next to each other on...

Mark: Startup with -d can indeed be used to move the datafile (and only the datafile) of the master database (and only the master database) - but definitely not if...

magarity kerns (7/2/2008)

---

The ALTER answer was misleading, if not outright incorrect, because it did not spell out the required take offline, put back online steps. If that alter statement were...

Tao Klerks (7/2/2008)

---

Hmm, I'm a little confused...

I assumed the question was talking about files from any arbitrary database - but the "ALTER DATABASE ... MODIFY FILE" clause can only (if...

Thanks for the clarification, Kirsty 🙂

I'm glad you took the question as I...