Viewing 15 posts - 6,016 through 6,030 (of 18,926 total)
That's weird. So the code works for 300K but fails at 400K?
That makes me think the code works, that the server is setup correctly and that maybe you have...
May 18, 2011 at 5:48 am
That won't work correctly. You can have 2 variables declared 1 as nvarchar and 1 as varchar.
To do this you need to save the spot where you find the...
May 17, 2011 at 5:51 pm
How many times do I have to say this before you try it out???
Sampson test2 September 2 2011-12 2011 09
Sort by 2011 THEN 09 and IT WILL WORK 100% SURE....
May 17, 2011 at 2:21 pm
homebrew01 (5/17/2011)
sqluser_8119 (5/16/2011)
If it is a matter of shrinking the database, can I shrink it while it is in use? What are the ramifications?
Shrinking causes fragmentation and uses resources, then...
May 17, 2011 at 2:17 pm
I wouldn't group by the month name, I'd also group by both the year and month (both ints). That will work, that's what I do here.
May 17, 2011 at 11:45 am
Are you sure the date are no in strings instead of datetime?
More to the point, I don't see what the query has to do with the fact that you can't...
May 17, 2011 at 11:43 am
Tim Mitchell (5/17/2011)
Ninja's_RGR'us (5/17/2011)
No fair... you're not supposed to answer your own questions.
If I didn't answer my own questions, the voices in my head would get lonely.
Ninja's_RGR'us (5/17/2011)
May 17, 2011 at 11:42 am
dma-669038 (5/17/2011)
I decided to lower my total throughput I allow for work. I've felt better ever since.
amen to that!!
Just in case some of you wonder. I alot 10...
May 17, 2011 at 11:21 am
Yes. In the sort of the groupings. Sort by 2 columns. #1 is the year, #2 is the month.
so that should give :
2011, 09
2011, 10
2011, 11
2011,...
May 17, 2011 at 11:11 am
You can't just guess at this. You must make sure it's correct. Nobody but you can figure that out. We can give you hints but we can't...
May 17, 2011 at 11:10 am
Steve Jones - SSC Editor (5/17/2011)
Ninja's_RGR'us (5/17/2011)
Why can't we have fun getting done what needs to be done and go home after that? ...
May 17, 2011 at 10:48 am
No fair... you're not supposed to answer your own questions.
Nice catch tho, thanks for the feedback. You should post it as a QOTD.
May 17, 2011 at 10:46 am
What's the point of removing those tables? I've never seen anyone do such a project in those circumstances that anything else than headaches.
May 17, 2011 at 10:39 am
Viewing 15 posts - 6,016 through 6,030 (of 18,926 total)