You will have to take plan caching and parameter sniffing into account.

See this great guide by MVP Erland Sommarskog:

http://www.sommarskog.se/dyn-search.html

EDIT: I'm unable to spell "URL"...

Thanks for the feedback, very useful.

Kit G (11/3/2010)

---

1) If I leave things as they are, will SQL Server eventually reduce the size of the transaction log for the 15GB database? If SQL Server needs...

:-D:hehe:

LOL! I'm sure DATEDIFF can do nothing with them!

Roy Ernest (11/3/2010)

---

Just wanted to give an update. Things are much better now. It did not rain much. The sky is still totally covered with cloud. Still raining but not...

From BOL:

RESTORE

If the database being restored does not...

I think they implemented the intellisense to work with any kind of collation, so that it sorts field names with "binary" sort instead of using database collation settings.

I don't think...

Here's a great guide on the subject:

http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

There's DATEDIFF for that kind of thing:

http://msdn.microsoft.com/it-it/library/ms189794.aspx

Agreed. Since I don't have the definition for that UDF I didn't include it in the rewrite.

I suggest comparing the exec plans with and without the UDFs.

Scalar UDFs generally speaking don't handle well this kind of situation.

Consider rewriting it as an ITVF or code the update directly in the calling SQL:

UPDATE R

SET DataSourceID =

CASE UPPER(dbo.fnGetValueAndType(R.AssetType_Code,...

GilaMonster (11/3/2010)

---

BrainDonor (11/3/2010)

---

I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down...

I tend to use virtual machines to play with new things. At least until...

I wouldn't change things to cursors, I would find offending rows with a query instead.

It's not very difficult to find, for instance, non-numeric values stored in a column that has...

It's a paradigm I don't like very much.

It seems to me that could easily transform things into complete chaos.

Who's responible for the projects? Who's the business owner? Who steers the...