Paul,

The problem is that from the info I obtained with the DBCC PAGE statement, it is impossible for me to know to which object the page is referring.

In other words,...

hi Nash,

One of the best ways to boost join performance is to limit how many rows need to be joined. This is especially beneficial for the outer table in a...

Vladan,

You can use the functions to fill variables which you then use in the select statement, like you mentioned in your first post.

Complicated or not, I believe that your code...

hi Bill

You could use a conversion (yeah, I know...) to obtain that result, like so:

select getdate(), convert( datetime, floor( convert( decimal(12, 4), getdate())))

hi Vladan,

Well, as you already stated, reusability is the main reason. Other than that I admit looking at you piece of code is easier to read, but I like to...

Hello,

You could make 4 seperate functions which take a date as input parameter (e.g. @date) from the code I pasted below. I hope this is what you need .

--input argument

declare...