Are you able to modify the code that is being used to update the tables? If so, you'd be a lot better of doing this explicitely, using some set...

I was curious enough to test this, and got some interesting results. Views beat functions when un-parameterized, but a parameterized function beat calling a view using a Where clause:

--47...

Yeah, I know what you're talking about...I've seen problems like that as well.

My guess is it has to do with the way functions use memory. For example,...

Yeah, it seems to me that there should be SOME method of determining who the actual user is. Not having one method or another would seem to cause a...

Of course there's a way! 🙂 I liked what you were saying about driving a view by what user is logged in, as either table driven or log-in driven....

Andy,

Couldn't you use a function that returns a record-set instead? I mean, for SQL2K people, at least. I found that this works beautifully as a "parameterized" view.

IE: ...

OK, MS is out of date; using a subquery is faster. Like this:

Select t.tname, t.tid,

(

Select count(t1.tid)

From #test t1

where t1.tName < t.tName--This is where you signify the...

This seems obvious to me, but unless they're point-&-click admins, DBA's should always be invited to Dev meetings. David Poole's comment is right on the money. Take any slooow...

select datediff(dd, '12-31-' + cast(datepart(yy, getdate())-1 as varchar), getdate())

nice, consice code. Great way to delete old files; didn't realize it was that easy, you did my homework assignment for me. 🙂

I've created a sproc that ftp's a...

Nevertheless, it makes sense that Date and time should be separate, or at least ALLOWED to be separate.

for SQL2k, datetime ranges from January 1, 1753 through December 31, 9999. So,...

Oops...gljjr already said that. Never mind.

if object_ID('Tempdb..#Test') is not null drop table #Test

-------------------------------------

Have to give Frank credit for this!

There was a URL to MS discussing it. Did caution on large tables.

Maybe Frank still has the URL.

Use PUBSGoselect rank=count(*), a1.au_lname, a1.au_fname ...

The difference between 5 hours and 40 minutes is great, but I have a feeling that you could cut even more time off this.

Basically, follow the rules of building...