Jeffrey Williams (11/26/2008)

Or, you could try using SET FMTONLY OFF; in your stored procedure. One thing the TableAdapter is probably doing is running the stored procedure with format only...

It sounds like you're getting parameter sniffing. You need to force a recompile on the procedure. Take a look at plan guides and see if you can implement one with...

Another vote for that book. Great read and good information.

Just remember that getting the clustered index right should be task #1. All other indexing flows from there.

Sweet!

I'll bet it makes programming easy.

Still, if it came down to it, I'd rather see inplace updates generating the aggregates than a series of columns going across a row. That's just horribly sloppy design. Again,...

No, sorry, I'm not an ASP.Net programmer. I'd suggest trying either MSDN or Simple-Talk, just to get started. Other than that, I'm clueless. Sorry.

Prior to 2005? Suffered.

There really wasn't an easy way to do it back then. The best approach was to have a natural key on the table then you wouldn't have...

You mean like "You're right and I'm wrong" as I just recently posted?

😛

Sorry, you're right. It's leakage from the old days. SCOPE_IDENTITY specifically deals well with triggers. My bad.

I still like the OUTPUT approach becuase it works the same with one row...

It doesn't work on 2005. Period. Full Stop.

It doesn't work terribly well on 2008.

Get Red Gate SQL Prompt. It works great on both and in Visual Studio (although it's a...

I assume you already updated the statistics with a full scan?

After doing that... Can you post the execution plan & query? Some functions that worked well enough in 2k don't...

As good a forum as any. This is a huge topic, but I'll try to...

If you're scripting database creation, two areas are going to cause you problems in terms of time. First, however big the database you create determines, on a given system, how...

This sort of implies that you're only using the GUI to create tables. You can change the schema for the object created in the gui by accessing the properties window,...

It really depends on your business needs. If you need to keep a history of the individual call itself, your method won't work. If all you care about is the...