Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 7,484 total)

  • RE: SPID

    Nakul Vachhrajani (6/20/2011)

    Good question, and easy if one has ever experienced orphaned transactions. Even in the Books-On-Line, this one is hard to find (there's just one reference to the -2...

    June 20, 2011 at 4:19 pm

    #1341502

  • RE: LoginProperties

    paul.knibbs (6/17/2011)

    The more of these questions I see, the more I think there are a significant fraction of respondents who are just clicking an answer at random...surely this isn't difficult...

    June 19, 2011 at 7:01 pm

    #1340934

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (6/19/2011)

    Ok , so we all have differing opinions of Celko, but a response after three and a half years :crazy:

    http://www.sqlservercentral.com/Forums/FindPost1127806.aspx

    I don't think many threadizens will find that...

    June 19, 2011 at 12:59 pm

    #1340889

  • RE: Are the posted questions getting worse?

    GilaMonster (6/17/2011)

    Yes, I'd like a word with whichever bright spark at MS thought that 600MB was a low bandwidth video...

    600MB? I guiess someone must have fixed that, as now...

    June 18, 2011 at 8:42 am

    #1340784

  • RE: Profiler

    Nice interesting question. I got it wrong and learnt something new.

    The reference to an SQL 2000 BoL page is a bit odd though. SQL 2005, SQL 2008, and...

    June 15, 2011 at 4:41 am

    #1338863

  • RE: NUMA

    Nice simple question.

    I guess about two thirds getting it right is reasonable, as it's something a lot of people will not have come across. But currently 16% have...

    June 15, 2011 at 2:10 am

    #1338800

  • RE: Custom Sort Order / Casting Date to Text

    Matt Wright (6/14/2011)

    COALESCE picks the first non-NULL value, so to solve the OP's question, he needs only use the date in a date format with the COALESCE as Lowell said....

    June 14, 2011 at 1:39 pm

    #1338632

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/13/2011)

    Stefan Krzywicki (6/13/2011)

    Brandie Tarvin (6/13/2011)

    I think I figured out why the UG in Jax is so popular. According to some news item floating around, Jacksonville, FL is the...

    June 13, 2011 at 1:37 pm

    #1338032

  • RE: Today's Random Word!

    GilaMonster (6/13/2011)

    What is it about transport companies and their databases? This is the 3rd one I've worked with, all had data problems so severe I wonder how they can stay...

    June 13, 2011 at 1:23 pm

    #1338025

  • RE: Today's Random Word!

    GilaMonster (6/13/2011)

    Data integrity (as in 'What data integrity?')

    That would perhaps be "data integrity" as in "all the data is integral" (even the strings, floating point numbers, and GUIDs) :w00t:

    Or perhaps...

    June 13, 2011 at 12:48 pm

    #1337993

  • RE: Are the posted questions getting worse?

    GilaMonster (6/13/2011)

    jcrawf02 (6/13/2011)

    SQLRNNR (6/13/2011)

    GilaMonster (6/13/2011)

    Anyone noticed that we now have pretty pictures as well as alphabet soup? http://www.sqlservercentral.com/Forums/Topic1123813-359-1.aspx

    Yeah - not too sure what to think of it - much the...

    June 13, 2011 at 11:54 am

    #1337946

  • RE: Are the posted questions getting worse?

    george sibbald (6/13/2011)

    SQLRNNR (6/13/2011)

    The Dixie Flatline (6/12/2011)

    If I passed, could I add "Thread Certified" to my resume` ?

    I thought you already had "Certified" added to your resume.

    He's not only sane,...

    June 13, 2011 at 11:32 am

    #1337931

  • RE: Page Compression

    Good question.

    But one major niggle and one minor niggle:

    Major niggle: if page compression is enabled on a table already containing data, each page is rebuilt and evaluated for page compression;...

    June 13, 2011 at 7:01 am

    #1337724

  • RE: Database Development or Business Intelligence Development and Maintenance

    latinmusic74 (6/9/2011)

    Maybe learning and practicing and using fake information and cross your finger on the interview. :doze:

    I recommend that you don't try that approach. In the unlikely event that...

    June 12, 2011 at 5:39 pm

    #1337533

  • RE: Using SELECT INTO a bad practice?

    CELKO (6/10/2011)

    >> We have lots of reports which use SELECT INTO to insert data into the temp tables. I was told that it's a bad practice. Could anyone please why...

    June 12, 2011 at 5:22 pm

    #1337530

Viewing 15 posts - 5,821 through 5,835 (of 7,484 total)