The big question to ask yourself before doing this is - is the zero in the original system simply a display item, or is it actually significant? Meaning -...

This might be a situation where encryption of specific data is required. And by encryption I mean - encryption handled by the app, externally to SQL Server. If the...

Is the error not getting caught at all or is the error state not being cleared? There are unfortunately quite a few errors that end up being "batch-terminating". ...

I have read the entire thread. Let's step back for a moment: I am a developer first and foremost, and I perform DBA activities on occasion. Not...

Sounds messy. From what I'm seeing - you'd have to do a running total (running from highest to lowest.) which you divide by the grand total to come up...

Well actually - yes I can. But that's not really the point. ...

Actually - let's clarify some things:

- both stored procedures and ad-hoc queries go through the SAME process when they're called for execution. They both follow the...

Assuming you're not talking about a materialized view, then there should be no difference whatsoever, since during the compile phase of the outer query, the reference to the view is...

You're so very close....:D

You're selecting string constants in your outer SELECT statement. Switch them to referring to columns of the same name instead.

In other words - this is the...

Try this "how to" on for size....

http://www.sqlservercentral.com/articles/Test+Data/61572/%5B/url%5D

There was also a DB engine bug that wasn't recycling temp tables that were going out of scope. Assuming your SSRS is using temp tables, that might be why....

I'm not sure why one run would be better than the other, but - a table variable doesn't accumulate statistics like a regular table does. So - the joining...

If the core of the function involves no data access, you might care to try turning it into a CLR function (deterministic and precise if applicable). Since CLR functions...

Since you're using 2005, a relatively low cost fix (instead of dynamic SQL) might simply be to force that select statement to recompile each and every single time. Meaning...

Are these multi-line or inline? scalar? are they deterministic (and flagged as such)?

Unfortunately, user defined functions in SQL Server aren't known for their performance. There are lots...