Search:

Type: Posts; User: disruptivehair

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    8
    Views
    836

    Re: Index hints in SQL Server 2005???

    My solution was to comment them all out. :afrog:
  2. Re: Mgt Studio - what does your EXECUTE button look like??

    My execute button is the top one, i.e. a red exclamation mark.
  3. Replies
    8
    Views
    836

    Re: Index hints in SQL Server 2005???

    Yeah, I looked for that too and didn't see any indication that that's allowed but it didn't say it wasn't allowed either. This allegedly works on SQL Server 2000... :confused:

    It gets better...
  4. Replies
    8
    Views
    836

    Re: Index hints in SQL Server 2005???

    I tried the 'with' thing already but I tried it with brackets [] instead of parentheses (). I'll try it again how you wrote it. :thumb:
  5. Replies
    19
    Views
    36,143

    Re: When to use INDEX HINTS!

    No, but the person who programmed the proc that I'm fixing did! His hints don't work in 2005 and now I have to make them work, even though I don't think they're really necessary. Grrr. I don't...
  6. Replies
    8
    Views
    836

    Index hints in SQL Server 2005???

    I've just been given a proc in SQL 2005 to fix and it has a bunch of index hints in it. I know sort of how they work but I don't really use them and evidently the syntax has changed a lot from one...
  7. Re: Weird font problem with Excel...can't figure this out

    More info...if I refer to the chart explicitly by its index number I can change the font face but not the font size...unless I do this:


    With xlSheet.ChartObjects(5).Chart
    With...
  8. Re: Weird font problem with Excel...can't figure this out

    Sorry; I just realized I didn't specify WHAT the problem was. On each chart the fonts on the chart are set to 8 pt except on the last one where they are 4, which is what Excel would set by default...
  9. Weird font problem with Excel...can't figure this out

    Every time I run this code, the font on the axes is set to 8pt on 4 out of 5 charts. I have absolutely no idea what the problem is here. I'm drawing a complete blank. I thought maybe the loop...
  10. Re: Having trouble with SORT_IN_TEMPDB clause

    Buuuuuuuuuuh....huh?
  11. Having trouble with SORT_IN_TEMPDB clause

    The DBAs have requested that we change this setting from OFF to ON when creating clustered indexes. Fine, but when I scripted one with SORT_IN_TEMPDB = ON then ran it, then looked at the create...
  12. Need help with weird results in SQL Server

    I wrote this query to extract all cases from the PPEKBaseData table where the value of OM_Complete was less than 90 days old:


    SELECT * FROM PPEKBaseData
    WHERE Pol_no NOT IN
    (SELECT Pol_no...
  13. Replies
    87
    Views
    3,586

    Re: $12,000,000

    Mmmmmmmmm kaaaaaaaaaaaaaaaaaaaaaay.... :confused:
  14. Re: How do you deal with people who fart openly

    I don't swing that way, sorry. :bigyello:
  15. Replies
    87
    Views
    3,586

    Re: $370,000,000

    *shrug* So?
  16. Replies
    82
    Views
    2,808

    Poll: Re: meat-eaters vs vegetarians

    No, it's because it takes 70-80 calories of energy to produce a single calorie of beef. It's basically one of the most inefficient sources of protein to produce and should be eaten only...
  17. Replies
    13
    Views
    453

    Re: Pray for me!

    Why is an atheist asking us to pray for him?

    edit:

    Damn, someone beat me to it!
  18. Replies
    82
    Views
    2,808

    Poll: Re: meat-eaters vs vegetarians

    I eat meat...chicken, turkey, and fish mostly. We eat a bit of pork; maybe twice a month; and we hardly ever eat beef for environmental reasons. We try to have a veggie dinner at least once a week...
  19. Re: How do you deal with people who fart openly

    What about chicks who wear too much perfume? There's one standing near me right now and it's making my eyes water.
  20. Replies
    87
    Views
    3,586

    Re: $12,000,000

    If someone handed you a bag containing 4-5 million dollars, you'd pee in your pants for joy. ONLY about 4-5 mil. :lol: :lol:
  21. Re: [RESOLVED] This stored procedure doesn't work...probably string parsing problem

    Yay, I did something right! :thumb:
  22. Replies
    87
    Views
    3,586

    Re: $370,000,000

    I know that, but I can dream. :cool:
  23. Replies
    49
    Views
    1,375

    Re: New game - 3 cool things you did today

    Alcohol could be anything tho...liquor is not beer, not wine....BOOZE. I used to work with this one guy who drank a smallish bottle of gin every day at lunch. In full view of everyone. :eek:
  24. Re: [RESOLVED] This stored procedure doesn't work...probably string parsing problem

    I could, but there's only one instance where that column is queried and I have functions that take care of building my parameters and they can't handle it. I guess here I would classify my solution...
  25. Replies
    49
    Views
    1,375

    Re: New game - 3 cool things you did today

    :lol: :lol:
  26. Replies
    49
    Views
    1,375

    Re: New game - 3 cool things you did today

    Aftershave and cologne are two different things. :)

    I DID say liquor! :thumb:
  27. Replies
    87
    Views
    3,586

    Re: $370,000,000

    That reminds me, I should buy a ticket; I think the EuroMillions is on Friday and the national lottery is on Sat. Not much up for grabs, but it's all tax-free. YAY!
  28. Re: [RESOLVED] This stored procedure doesn't work...probably string parsing problem

    OK.

    Is HAVING generally considered to be a bad thing tho? I'm still kind of new at this and I like getting advice from people who are better at this than I am. (I'm not being sarcastic at all!)...
  29. Re: [RESOLVED] This stored procedure doesn't work...probably string parsing problem

    Because the @Filter parameter I pass in already has a where clause sometimes, and I don't want to fiddle around with all the conditionals. The query runs very quickly so I don't see that HAVING...
  30. Re: This stored procedure doesn't work...probably string parsing problem

    Nevermind, figured it out:


    CREATE PROC dbo.sp_FEWeeklyAcceptedTargets2(@Filter nvarchar(200) = NULL, @AcMeth nvarchar(1))
    AS

    DECLARE @strSQL nvarchar(2000)
    DECLARE @strWhere nvarchar(200)
    ...
  31. [RESOLVED] This stored procedure doesn't work...probably string parsing problem

    Here's my proc:


    ALTER PROC dbo.sp_FEWeeklyAcceptedTargets2(@Filter nvarchar(200) = NULL, @AcMeth nvarchar(1))
    AS

    DECLARE @strSQL nvarchar(2000)
    DECLARE @strWhere nvarchar(200)

    SET...
  32. Replies
    49
    Views
    1,375

    Re: New game - 3 cool things you did today

    Hehe...there's this pinky-ring, gelled-hair guy in my office who just got back from there...you know the kind, they come in to work reeking of cologne and come back from lunch reeking of liquor. ...
  33. Replies
    49
    Views
    1,375

    Re: New game - 3 cool things you did today

    Kabul would probably be a party destination if they had cheap booze and Easy Jet flew there for a tenner. I would ask why Brits drink so much but since I live in the UK, I know why: NOTHING ELSE TO...
  34. Replies
    87
    Views
    3,586

    Re: $355,000,000

    Buy houses for all my loved ones.

    Buy an arsenal of classic cars. I'm not a gearhead, I just like how they look.

    Book expensive holidays, first-class all the way; and it would be tough and...
  35. Replies
    49
    Views
    1,375

    Re: New game - 3 cool things you did today

    What is it with Brits and Tenerife?
  36. Replies
    49
    Views
    1,375

    Re: New game - 3 cool things you did today

    On Saturday: Didn't die in a plane crash


    That's it.
  37. Replies
    78
    Views
    2,526

    Re: Anna Nicole Smith

    How embarrassing
  38. Replies
    17
    Views
    556

    Re: College essay advice?

    :lol: :lol:
  39. Replies
    30
    Views
    1,124

    Re: It never snows

    It's going to be 50F here today but it feels warmer than that.

    Today's high in Dallas (where I'm from) is going to be 71F. God, I wish I was there instead of here.
  40. Replies
    17
    Views
    556

    Re: College essay advice?

    It's an application, not an assignment.

    I was lucky...I didn't have to write any essays to get into uni. I just sent my SAT scores and high school transcripts to the University of Texas at Austin...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width