I like the article. Showing common cursor practices and a nice set-based approach to replace them is absolutely the right way to go. Unfortunately, as Jeff already pointed out, you...

Manie Verster (1/2/2009)

---

Sounds like a good idea. I just think that...

I was just reading a blog post by Hugo Kornelis. He said, based on his tests, STATIC was the way to go, that it outperformed FASTFORWARD cursors.

Are you kidding? I write cursors for everything so that I can come back later and "tune" the query.

Jeff Moden (12/31/2008)

---

Grant Fritchey (12/31/2008)

---

Yeah, completely true, but however inefficient msforeachdb is as a cursor, when you're running consistency checks against all the databases on a server, does the extra...

I presented this as a database design at a meeting once.

CREATE TABLE [dbo].[AppTable](

[Id] [int] IDENTITY(1,1) NOT NULL,

[RefId] [int] NOT NULL,

[AppValue] [nvarchar](max) NOT NULL,

CONSTRAINT [PK_AppTable] PRIMARY KEY CLUSTERED

(

[Id] ASC

)WITH...

Jeff Moden (12/31/2008)

---

Tom.Thomson (12/31/2008)

---

Just add "FAST_FORWARD" and "STATIC" to the cursor definition and the cursor method will run as fast as your non-cursor method (and for large datasets...

Thanks for the correction. I wasn't sure and I haven't really looked at the table valued parameters yet. I should have kept my mouth shut.

Even though SQL Server 2005/2008 will store excess values past the 8060 limit when dealing with varchar,etc., you will get performance overhead to go and do that extra retrieve. I'd...

Returning 89000 rows out of 100000 pretty much means that you're going to get scans of the table and/or indexes involved.

However, there might be things that can be done. Can...

Assuming it's not a real text file, in which case, it's just a dump of a database and you'll need to get the structure from another source and then use...

I think you can do that in 2008, not that it helps you in 2005.

Putting data into the tempdb is quite a lot different than putting data into an Excel file. I guess I'm still going to need more information here.

I just glanced...

That procedure might be querying across the databases. It's also possible their login is going to your database by default.

I'm sure it's possible for it to report incorrect connections, but...

It may be clunky, but there is a lot of clarity of information by seperating it into discrete buckets (even though the buckets are a bit abused by some of...