Of course the best answer you'll get is "It Depends..." but anyway, How is the table indexed? If the default indexing (clustered on all four ints) is used,...

Yes, you do:

http://msdn.microsoft.com/en-US/library/ms188388%28v=SQL.90%29.aspx

You've explicitly set the fill factor to 80% which means that the database engine will leave 20% of the pages empty (this is a good thing,...

Also, you probably don't want those two nested if statements. (unless you do...)

The way you have it now, if there's a intake scheduled for 5:45, and another scheduled for 3:11...

Hugo, 5+the number of your children is obviously 7... I think maybe you messed up your inner select 🙂

I think that this does illustrate a point that has not...

When I first came to use SQL, I was flabbergasted that anyone could think it wise to design a system where x=y could be false and x <> y could...

regarding when the non-clustered pk might be good, the oversimplification is that if you do a lot of updates, you probably want the table clustered on the PK, because you...

A little bit of a different viewpoint: Most people have focused on the clustered vs nonclustered aspect of the question, but when I first read it, I thought the...

Thanks for looking at this,

That's an interesting suggestion about the statistics on the tvf, I just assumed that because the query plan looked like the problem was with SARGability, that...

They have identical costs in the query plan.

On your hidden parameter copy the expression from the default value section, and also put it in the available values section. (you need it in both places)

In ssrs 2005,...

I didn't take a look at your attachment, but I think, if I remember from a long time ago, what you want to do is put the default value in...

So this has me confused, as it goes contrary to what I've previously read and experienced.

As a quick test I ran a select * against a clustered table, ordered both...

This is what you were looking for:

http://www.sqlservercentral.com/articles/Backup+and+Recovery/restoringtoapointintime/1905/

As an aside though, the begin/end statements are just another statement in the stored proc; Anything after the end is included in...

Not quite clear on the nature of your question. Are you wondering technically how to do it or how should you do it?

The method for creating optional parameters in...

No problem, glad I could help.

You should probably move the update statement inside the try block. If there is an error that will be caught by the try (for...