Viewing 15 posts - 316 through 330 (of 341 total)
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
The more you are prepared, the less you need it.
August 28, 2008 at 7:19 am
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...
The more you are prepared, the less you need it.
August 28, 2008 at 7:09 am
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.
The more you are prepared, the less you need it.
August 28, 2008 at 7:06 am
use between @StartDate and @EndDate (reportdate and Enddate seem to be the same)
use dateadd to et @Startdate:
select @Startdate = dateadd(month,-12,@ReportDate)
The more you are prepared, the less you need it.
August 28, 2008 at 7:04 am
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....
The more you are prepared, the less you need it.
August 28, 2008 at 6:55 am
I'd go with the express version, and get the management studio express component. Its free, and has most of what you want.
The more you are prepared, the less you need it.
August 28, 2008 at 6:50 am
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)...
The more you are prepared, the less you need it.
August 28, 2008 at 6:46 am
Good point on the hyphen. I've found that object names with a hyphen need to be in brackets.
The more you are prepared, the less you need it.
August 27, 2008 at 11:53 am
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...
The more you are prepared, the less you need it.
August 27, 2008 at 10:29 am
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...
The more you are prepared, the less you need it.
August 27, 2008 at 9:13 am
Will do. A bit busy today, but will see if I can work it out.
If not, will work over tonight.
The more you are prepared, the less you need it.
August 27, 2008 at 8:03 am
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...
The more you are prepared, the less you need it.
August 27, 2008 at 7:22 am
Its good to go over the basics. Its the old 80/20 rule, and most problems come from failed or misunderstood basics.
The more you are prepared, the less you need it.
August 27, 2008 at 6:40 am
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.
😎
The more you are prepared, the less you need it.
August 20, 2008 at 1:07 pm
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...
The more you are prepared, the less you need it.
August 13, 2008 at 2:43 pm
Viewing 15 posts - 316 through 330 (of 341 total)