Forum Replies Created

Viewing 15 posts - 4,036 through 4,050 (of 8,416 total)

  • RE: Are the posted questions getting worse?

    WayneS (4/7/2010)

    Carp... Sorry Paul. I fixed it, but you have me quoted with the wrong name forever...

    Fixed! 😀

    April 7, 2010 at 8:30 pm

    #1147977

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/7/2010)

    Okay, I have read ahead and will heed the warnings. I'll stop.

    That would be nice, yes :satisfied:

    April 7, 2010 at 8:30 pm

    #1147976

  • RE: staging table and indexes

    Jeffrey Williams-493691 (4/7/2010)

    Paul - that would work great if the OP was not working against a SQL 2000 database. From the previous post, he stated that SSRS is at...

    April 7, 2010 at 8:24 pm

    #1147973

  • RE: ANSI_NULLS

    sknox (4/7/2010)

    What's MORE important is how NULLS improve queries and and designs when used properly and when necessary. Sadly that's usually the exception...

    Yes. I do use NULL columns occasionally...

    April 7, 2010 at 8:14 pm

    #1147970

  • RE: ANSI_NULLS

    Oleg Netchaev (4/7/2010)

    Msg 0, Level 11, State 0, Line 0

    A severe error occurred on the current command. The results, if any, should be discarded

    Was a bug. Fixed now,...

    April 7, 2010 at 8:09 pm

    #1147967

  • RE: ANSI_NULLS

    RBarryYoung (4/7/2010)

    Paul:

    Now I'm curious to know how you did on mine...? (here: http://www.sqlservercentral.com/questions/T-SQL/63632/) Its still got one of the lowest correct percentages that I know of.

    Managed to get...

    April 7, 2010 at 8:05 pm

    #1147966

  • RE: ANSI_NULLS

    RBarryYoung (4/7/2010)

    Heh. I have to admit that I got it wrong too. I haven't done anything with ANSI_NULLs disabled in a very, very long time, and I couldn't...

    April 7, 2010 at 8:01 pm

    #1147965

  • RE: ANSI_NULLS

    weitzera (4/7/2010)

    When I first came to use SQL, I was flabbergasted that anyone could think it wise to design a system where x=y could be false and x <> y...

    April 7, 2010 at 7:58 pm

    #1147963

  • RE: ANSI_NULLS

    CirquedeSQLeil (4/7/2010)

    Paul,

    I hope you don't mind. I took your great script and made a modification to it....There are some display issues with < > type symbols - but I...

    April 7, 2010 at 7:54 pm

    #1147961

  • RE: ANSI_NULLS

    Oleg Netchaev (4/7/2010)

    Paul White NZ (4/7/2010)

    Toreador (4/7/2010)

    Is there any situation where setting ansi_nulls off is a good idea?

    I have never come across one. Apart from the bizarre rules illustrated...

    April 7, 2010 at 7:05 pm

    #1147948

  • RE: Creating Indices on Temp Tables from Stored Procedures

    TheSQLGuru (4/7/2010)

    BAH!! I don't need no stinkin' TESTS!! I KNOW my code will run faster than my client's did!!! :w00t: 😀 😎

    Superb.

    April 7, 2010 at 6:47 pm

    #1147944

  • RE: Copy data from one Column to another

    Rob Schripsema (4/7/2010)

    Why would you only use this if it were a small table? What would be the downside (other than a bloated transaction log, I guess) of doing it...

    April 7, 2010 at 6:41 pm

    #1147942

  • RE: Overactive use of Temp Tables?

    bobmclaren (4/7/2010)

    I'm liking the idea of populating permanent tables using bcp and truncate to minimize logging.

    Me too :w00t:

    Think I'll give that a shot.

    If you get time, post back to let...

    April 7, 2010 at 6:36 pm

    #1147938

  • RE: clearing SQL cache

    Dave Ballantyne (4/7/2010)

    Paul White NZ (4/7/2010)

    My guess is procedure cache bloat due to ad-hoc queries.

    Which reminds me , ive still got a half finished blog on forced parametrization hanging around.

    Well...

    April 7, 2010 at 6:34 pm

    #1147937

  • RE: Are the posted questions getting worse?

    WayneS (4/7/2010)

    I see Jason'sPaul's QOD is still running 47%, w/ 1250 attempts.

    *cough*

    Whose QotD? 😛 :rolleyes:

    April 7, 2010 at 6:33 pm

    #1147936

Viewing 15 posts - 4,036 through 4,050 (of 8,416 total)