Christian Bolton has some comments on it at

http://sqlblogcasts.com/blogs/christian/archive/2008/01/07/sql-server-memtoleave-vas-and-64-bit.aspx

While its great to ask, really you should test and review. I highly suggest that you have the db options documented, perhaps in a wiki, and after upgrading...

If you can, spend some time really getting to know mirroring. Once you do, it will be your friend. It makes upgrades, etc. much easier.

use between @StartDate and @EndDate (reportdate and Enddate seem to be the same)

use dateadd to et @Startdate:

select @Startdate = dateadd(month,-12,@ReportDate)

use the DMV to to at the actual column schema info.

such as:

select * from sys.columns where [object_id] = object_id('mytablename')

that will give you access to the column name for your table....

I'd go with the express version, and get the management studio express component. Its free, and has most of what you want.

It almost sounds like the query it self is not working the way you want it to work. Anyway the few times I have to use dynamic SQL (very few)...

Good point on the hyphen. I've found that object names with a hyphen need to be in brackets.

And the winner is...

the CTE based view, by a landslide.

Actually, it was not even close, which makes perfect sense.

I populated a table holding just under 100,000 records, then compared the...

I have to agree, joins should be faster than functions - which you expect to be RBAR.

driven by curiosity, I've done quick process to build a large table with...

Will do. A bit busy today, but will see if I can work it out.

If not, will work over tonight.

The main issue here is to get the previous odometer readings, given the current vehicle ID and reading date. So, first I would setup a function that would return...

Its good to go over the basics. Its the old 80/20 rule, and most problems come from failed or misunderstood basics.

Linchi Shea has a good write up and example on using sp_trace at SQLblog.com:

http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx

It also shows how server trace and profiler impact the server.

😎

If your system is 24/7, you may not be able to do index rebuilds, at least not on large tables.

Index rebuilds take the table off-line - not a good thing...