Viewing 15 posts - 47,641 through 47,655 (of 59,064 total)
I'd seriously consider doing some DB and disk maintenance... I don't let the Scan Density get below 90% before I do a rebuild, especially if the clustered index isn't chronological...
October 20, 2008 at 6:55 pm
If you have the file open with something when you try to do the run, you will get an error like you did.
October 20, 2008 at 6:45 pm
Steve Jones - Editor (10/20/2008)
Interesting comments, and no complaints, Jeff. Just wondering. Usually I get a good diatribe if I've stoked your interest.
Heh... which definition of "diatribe" do you mean...
October 20, 2008 at 6:44 pm
I agree with the problems that the folks in the posts above have cited. Further, there is an absolutely glaring problem with this method (no fault of the author)...
"refactor...
October 20, 2008 at 5:46 am
Steve Jones - Editor (10/19/2008)
That's it? I wear you two out on the Financial Crisis poll 🙂
Heh... the one time I agree with anybody 100% and you ask if "That's...
October 20, 2008 at 5:13 am
Prakash.Padmanabha (10/19/2008)
I am recently into SQL Server programming and assuming we need a single row for each line, I have written this query which is giving the results as...
October 19, 2008 at 10:23 am
Heh... I pretty much agree with what Loner said. I'll go a step further... although I feel bad for some of the "Joe Bag-o-Donuts" guys that lost a good...
October 18, 2008 at 6:28 pm
You bet... thank you for the feedback. Let us know if you have any additional problems with this... 🙂
October 18, 2008 at 6:05 pm
senthil_gobi04,
Just to add to the concensus forming here, about the only thing you really need to know about cursors is how to stay away from them. Even a nice...
October 18, 2008 at 6:01 pm
MarlonRibunal (10/18/2008)
GilaMonster (10/18/2008)
October 18, 2008 at 5:46 pm
Debasis,
That seems to bring us right along with what I was talking about and back to your question about the "utility of cursors"... how WOULD you do a running total...
October 18, 2008 at 5:41 pm
GilaMonster (10/18/2008)
October 18, 2008 at 5:30 pm
The problem with this whole thing is the original form of the data. It's in the same form as the report... it's "horizontal" and the column names represent time....
October 18, 2008 at 3:21 pm
deba_20032004 (10/18/2008)
I need a help regarding the aboved subjec. I can't clear my self after reading a sql server book.
Please help me regarding the above subject. what is the...
October 18, 2008 at 10:59 am
Viewing 15 posts - 47,641 through 47,655 (of 59,064 total)