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...

I would say the difference is probably attributable to statistics. If you look at the end of the process, the scans & reads for the two are VERY different. For...

I agree with this. I have three of Henderson's books sitting on my shelf right now. Unfortunately, they're beginning to age...

Lin Zhang (12/30/2008)

---

You are right. But I mentioned that you need to do backup ( transactional backup) before change recovery mode, and do full backup after changing mode back to...