Viewing 15 posts - 331 through 345 (of 378 total)
This is a really well written article RBarryYoung, my compliments.
Even Jeff learned something here 🙂
The strong case for this article is that you demonstrated with proper examples that gaps in...
April 28, 2009 at 3:52 am
Sorry to have missed this topic, I will spend some time the next week to take a good look at all data and knowledge displayed in this thread. Right now...
April 22, 2009 at 2:29 am
Documentation of code is tricky subject in my experience
Yes I do comment my code and yes it is needed to some degree but there are some risks associated with it...
April 17, 2009 at 9:33 am
RBarryYoung,
First thanks for your quick reply. It seems that last time you understood me wrong and I did not pick up on that. And from there the discussion wend downhill....
April 16, 2009 at 9:06 am
Forgive me if I missed anything by skipping to the end discussion, as after 18 pages of reading I believe I got the theme. It is Time to add my...
April 16, 2009 at 7:06 am
You can problably psychologically trick a potential reader into feeling the post is short.
There are two ways.
Add the test code and the solutions you already tried as sql scripts
This doesnt...
April 14, 2009 at 2:20 am
Lynn Pettis briefly noted something about solving the issue while writing about it and I like to follow up on that 🙂
It is a well known fact that when you...
April 6, 2009 at 9:11 am
Maybe I am known to some of you to have a deep passion for arguments and a temper to match in the threads I participate in. However there are times...
April 6, 2009 at 4:58 am
antonio.collins (2/5/2009)
:peterah. i missed the in-line requirement. then it makes sense, since the function would be just short-hand for a select.
I quickly made a modified version of your...
February 5, 2009 at 9:30 am
antonio.collins (2/5/2009)
Bob Hovious (2/5/2009)
peter (2/5/2009)
When dealing whith functions that are called frequently, it usually pays off to write them as inline table valued functions (also called parameterized views) and then...
February 5, 2009 at 8:12 am
Bob Hovious (2/4/2009)
...
Even using the tally table technique in a user function made the update take MINUTES to run, but that's to be expected when a user...
February 5, 2009 at 2:22 am
A nice basic introduction!
I myself have wrestled with AS2005 in practice and seeing how easy others run into problems given all the post here are about just that, I get...
January 30, 2009 at 6:42 am
Not having access to a developer or Enterprise version of SQL Server I find this topic hard to go into myself. Some of the SQL features used are only available...
January 27, 2009 at 5:58 am
I understand your point of view as well as the theory you put forward as to why it might be different in case of my proof. Therefore I did the...
January 23, 2009 at 9:25 am
Mazharuddin Ehsan (3/16/2008)
I hope to show in this article that the CTEs usefulness is not purely cosmetic.
You are right david. It would be immensely useful in more complicated situations. I...
January 23, 2009 at 8:35 am
Viewing 15 posts - 331 through 345 (of 378 total)