Viewing 7 posts - 91 through 98 (of 98 total)
To get a bit more testing data, I used the following code. While not perfect, it should be close enough to what you have described.
--DROP table Family
DECLARE...
August 23, 2006 at 5:07 pm
As mentioned in the first response in this thread, you can enable 'dirty reads' as a possible solution.
This can be done at the statement level, using the NOLOCK hint in...
August 11, 2006 at 12:27 pm
Tuan,
Looking just at what your original post requests, the DATEADD method being discussed for most of this thread will work for you...but...
Keep in mind that the BETWEEN function is INCLUSIVE. ...
August 8, 2006 at 10:55 pm
Sorry if I am missing the point, but why do you need to use @@ROWCOUNT anyway?
Looking at your code above, the only assumption that I can come to, is that...
August 2, 2006 at 6:05 pm
A couple things I have done in the past, to help with similar numbers and DR requirements...
Move all DTS to one server...I had one SQL instance that was devoted to...
January 3, 2006 at 11:04 am
I am afraid that I have to object on the use of the /3GB switch in your environment.
If you were only running one SQL instance, using the switch...
October 3, 2003 at 9:35 am
Actually Chris you all ready had the solution...
With just a slight change to your original subquery, you have what you were looking for. In fact, the solution presented by...
October 3, 2003 at 8:47 am
Viewing 7 posts - 91 through 98 (of 98 total)