Viewing 6 posts - 31 through 36 (of 36 total)
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,...
April 13, 2006 at 8:14 am
#632397
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...
March 22, 2006 at 8:26 am
#628113
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...
March 22, 2006 at 8:15 am
#628110
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())))
March 22, 2006 at 7:59 am
#628102
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...
March 22, 2006 at 7:53 am
#628099
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...
March 22, 2006 at 7:04 am
#628078