Viewing 15 posts - 23,086 through 23,100 (of 26,490 total)
hmmm, avatar I too have found
January 8, 2009 at 9:10 am
I have to second Seth on reading the article on Running Totals (also linked in my sig block). The method described in the article can update a 1,000,000 row...
January 8, 2009 at 8:30 am
Okay, I will look into that tomorrow morning (well, it is almost tomorrow morning now for me) when I get into work. I'll let you know what I find.
Thanks
January 7, 2009 at 11:40 pm
Again, you really need to read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/
You only THINK you need to use a cursor at this moment. If you provide the information in the format recommended...
January 7, 2009 at 10:46 pm
Run the following query on you system(s) and let us know the results for your PeopleSoft databases.
select
name,
snapshot_isolation_state,
snapshot_isolation_state_desc,
...
January 7, 2009 at 9:40 pm
RBarryYoung (1/7/2009)
Joe Celko (1/7/2009)
Quit being a whining child who...
January 7, 2009 at 9:23 pm
Mr. Celko,
First, I'm not whining, far from it. I am simply pointing out a basic observation based on reading many of your posts both here on SSC and else...
January 7, 2009 at 5:52 pm
Jeff,
I sent the article to Steve this morning. Thank you for the feedback and the compliments! It makes doing the writing that much more fulfilling.
Lynn
January 7, 2009 at 4:54 pm
anam (1/7/2009)
January 7, 2009 at 4:50 pm
bitbucket (1/7/2009)
I like the open space here in Colorado, even though Colorado Springs does seem to keep growing.
A long long time ago (no not the opening...
January 7, 2009 at 4:40 pm
Read about PIVOT in Books Online, and start with that. If you still have questions, let us know.
January 7, 2009 at 4:06 pm
Mr. Celko, Why do you have to be so acerbic? Not a good way to make friends and influence people. Also, your notion of truly portable code? ...
January 7, 2009 at 3:51 pm
If all they need to do is select data from tables, the only permission they should have in the database db_reader. What permissions do they currently have to the...
January 7, 2009 at 3:28 pm
GilaMonster (1/7/2009)
Lynn Pettis (1/7/2009)
GilaMonster (1/7/2009)
Lynn Pettis (1/7/2009)
hmmm, a question I sense here but not sure what you want.Are you channelling Yoda again?
Sorry, caught a couple of the Star Wars movies...
January 7, 2009 at 3:16 pm
GilaMonster (1/7/2009)
Lynn Pettis (1/7/2009)
hmmm, a question I sense here but not sure what you want.Are you channelling Yoda again?
Sorry, caught a couple of the Star Wars movies on TV this...
January 7, 2009 at 1:36 pm
Viewing 15 posts - 23,086 through 23,100 (of 26,490 total)