Forum Replies Created

Viewing 15 posts - 46,981 through 46,995 (of 59,064 total)

  • RE: Missing Indexes in SQL Server 2005

    Wayne West (10/22/2008)

    Thanks for the article, Ranga, very useful. I look forward to getting our ERP system into 2005 or 2008 as I know they're not doing a good...

    November 25, 2008 at 6:43 pm

    #903501

  • RE: The Numbers Table

    thisisfutile (11/25/2008)

    Thanks for the professional approach in your response.

    You just made my day. Thanks for taking it the right way and thanks for the nice compliment!

    November 25, 2008 at 5:55 pm

    #903497

  • RE: Knowledge sharing

    Manie Verster (11/25/2008)

    I was talking about rookies/newbies that are really struggling to do it and in the workplace you don't get a lot of people that wants to help and...

    November 25, 2008 at 6:52 am

    #903100

  • RE: want only date portion from datetime datatype in UPDATE statement

    Yep... the DATEADD function will help in those areas. Check out Books Online for the syntax and parts of the date you can modify.

    November 25, 2008 at 6:41 am

    #903084

  • RE: Exercise to practise SQL

    Yep... that's a totally useful post and link. Glad you were on it.

    November 25, 2008 at 6:39 am

    #903081

  • RE: Knowledge sharing

    I don't have a problem either helping rookies or being patient with them. I do have a problem with people that have a gazillion titles after their name and...

    November 25, 2008 at 12:05 am

    #902946

  • RE: Conditional Where

    jcrawf02 (11/24/2008)

    "jeffIsAGiantGoober" ??? Heh... I guess that's better than some of the things I have been called... 😛

    November 24, 2008 at 11:51 pm

    #902937

  • RE: Advice for array oflarge arrays

    Ok... I've got the split done. I just need to "smear" the Group number, SubGroup number, and a couple of other things throughout the "matrix". Since this isn't...

    November 24, 2008 at 10:33 pm

    #902895

  • RE: Calculate values from previous records in a series

    Thanks, ehlinger ... I appreciate the detail. Just wanted to make sure you were "covered". Good "seeing" you again.

    November 24, 2008 at 9:15 pm

    #902868

  • RE: Function that finds Sundays

    Michael Valentine Jones (11/24/2008)

    Michael Valentine Jones (11/21/2008)

    marty.seed (11/21/2008)

    Sorry, good question. The next Sunday

    So if I was to pass in todays date I would get 11/23/08

    What do you want it to...

    November 24, 2008 at 9:11 pm

    #902866

  • RE: The Numbers Table

    GOC (11/24/2008)

    I must be missing something here. The thing I don't get about the whole tally of numbers discussion is why so much time and effort seems to always be...

    November 24, 2008 at 8:40 pm

    #902859

  • RE: The Numbers Table

    jacroberts (11/24/2008)

    timothyawiseman (11/24/2008)

    jacroberts (11/24/2008)

    Performance isn't always an issue as in my previous example.

    I agree with Jeff that performance should always be a concern. After all, you may eventually need...

    November 24, 2008 at 8:23 pm

    #902856

  • RE: The Numbers Table

    thisisfutile (11/24/2008)

    Jeff Moden (11/24/2008)

    jacroberts (11/24/2008)

    ... queried the table with 4000 rows in in less than 1 second.

    That's pretty slow and performance should be always an issue...

    With all due respect Jeff,...

    November 24, 2008 at 7:41 pm

    #902850

  • RE: The Numbers Table

    Adam Machanic (11/24/2008)

    I'll add that recursion isn't much better than a While loop and is sometimes worse.

    I beg to differ. Recursion (in T-SQL) is always worse than a...

    November 24, 2008 at 6:59 pm

    #902845

  • RE: The Numbers Table

    Adam Machanic (11/24/2008)

    Ed W. (11/24/2008)

    Ok, so you populated a table with numbers. Everyone can argue about how to do that, but the real question is what do you DO with...

    November 24, 2008 at 6:53 pm

    #902843

Viewing 15 posts - 46,981 through 46,995 (of 59,064 total)