Viewing 15 posts - 16 through 30 (of 32 total)
June 2, 2015 at 8:57 am
Make that three things you should never discuss in public:
3) Cursors (good OR bad)
June 2, 2015 at 8:01 am
Microsoft Uses Cursors. Boy, if I used that argument, I could get away with almost anything. If I looked hard enough I could probably find some code provided by Microsoft...
June 1, 2015 at 7:50 am
Yes they are, or are browsing as part of their job. Like when I go into a Best Buy and tell them I can buy product X on Amazon for...
October 30, 2014 at 3:33 pm
KenpoDBA: I have a PoSH script that loads a considerable amount of data into a database in different stages. It would be great to include a backup (with CopyOnly =...
May 17, 2013 at 9:12 am
Great article. I hate it when someone says, "Never...." You've proved that there is always more to the picture than what the eye can see (or the statistics tell us)....
August 1, 2012 at 12:27 am
In light of the other posts, this is just to clarify a comment you made in your article. You stated, "the first character is removed and then converted into an...
June 9, 2010 at 8:20 pm
I agree about wording. There is no way you can select one column from a table (SELECT name) and get three columns/fields returned. I guess we are supposed to be...
April 21, 2010 at 3:40 pm
I agree more with trubolotta than the contents of the article. I do not see why there needs to be separate table for one-time meds vs. recurring meds. In fact...
March 15, 2010 at 9:42 pm
I am a bit perplexed by the article. I buiul a tally table in each of my databases a couple of years ago. Static table, 100K rows, PK. When I...
September 22, 2009 at 8:28 am
Lynn Pettis (4/14/2009)
April 14, 2009 at 9:12 am
That is the point I was making. The author assumed that by changing his code from the individual steps to Cookies, with chocolate chips, all of a sudden it was...
April 14, 2009 at 9:09 am
I must say that for an introduction you did an okay job. The only thing I took offense of was the procedural vs. declarative examples and your definition of procedural...
April 14, 2009 at 8:27 am
You might do a search in Google for sp_who_3 (http://vyaskn.tripod.com/sp_who3.htm). Very robust with lots of optional parameters and already built to show the input buffer and a lot...
July 18, 2008 at 7:14 am
"I hate cursors" is an awful vague statement. I hate UPDATE statements. I'd rather do a DELETE and then an INSERT! Wait, that is what SQL does when you update...
June 13, 2008 at 7:42 am