Viewing 15 posts - 2,401 through 2,415 (of 6,486 total)
Jeff - enquiring minds wanna know - how are you getting your code windows to scroll side to side?
October 15, 2008 at 9:49 pm
Hmm - I just saw one that Jeff posted that scrolls, but a new one I just tried creating in here doesn't do it.
October 15, 2008 at 9:43 pm
Jeff Moden (10/15/2008)
In that case, I'd use a FILL Factor of 100 for that tiny bit more speed on any SELECTS you may do on the table.
True - but that...
October 15, 2008 at 9:25 pm
Jeff Moden (10/15/2008)
Garadin (10/15/2008)
This solution is a variation of Jeff Moden's Running Total Technique, which can be found here:http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
Thanks for the "pass back", Seth. After Matt's index suggestion, looks...
October 15, 2008 at 7:42 pm
Same question, asked in a new package -
http://www.sqlservercentral.com/Forums/FindPost585845.aspx
and
http://www.sqlservercentral.com/Forums/FindPost585851.aspx
No matter what you do with these - you will need to convert them first, then do whatever math you need to...
October 15, 2008 at 12:57 pm
MrB -
Did you ever get a chance to try my version? Assuming you get the right results - it should be a little faster than your original version.
October 15, 2008 at 12:53 pm
You might worry about it if the columns making up the key change a lot. in a similar way to why you worry about fill factor for clustered indexes,...
October 15, 2008 at 12:15 pm
Garadin (10/15/2008)
If someone could confirm that the composite clustered index does what I'm thinking it does here (ie. orders by id, then student, then date), I'd appreciate it.
It does in...
October 15, 2008 at 11:47 am
Steve Jones - Editor (10/15/2008)
I'm with Michael, you need to test.Just going for it is a good way to lose a lot of goodwill at this job.
Never mind your job,...
October 15, 2008 at 9:42 am
(note: you example is now showing data from 2 separate rows now. Just making sure you noticed that).
Considering product Id and Prodcut code seem to be the constants, groups...
October 15, 2008 at 8:13 am
You are missing something. Your syntax is missing some stuff (what is causing your errors).
An update involving another table looks like:
UPDATE myTable
SET
...
October 15, 2008 at 7:35 am
hmm... Nothing you've mentioned so far requires a cursor of any kind. What makes you think you absolutely need to process each row one at a time? I...
October 14, 2008 at 10:14 pm
Let's not forget one of the biggest factors the various models forget to deal with...the power the model itself wields on the underlying system it was designed to monitor. ...
October 14, 2008 at 4:37 pm
Please don't double-post questions.
http://www.sqlservercentral.com/Forums/FindPost585845.aspx
It will have the opposite effect than what was intended, since you will tend to piss people off.
October 14, 2008 at 4:21 pm
Arshad - remember that you're simply build a SQL command. Build the string so that it returns the query you wish.
As to using parameters - you probably...
October 14, 2008 at 4:19 pm
Viewing 15 posts - 2,401 through 2,415 (of 6,486 total)