Forum Replies Created

Viewing 15 posts - 10,546 through 10,560 (of 39,793 total)

  • RE: SQL Server community and education site

    Thanks, but this is falling on dead ears.

    We are working to implement some SPAM prevention measures and change some code. Hard to get this to be a priority, though.

  • RE: Website defect: Wrong post quoted when a post has been made since last page update.

    I couldn't imagine how this would be a problem, but there must be some counting.

    I've struggled with developers to fix it, which seems odd to me since it must...

  • RE: Random values

    Many people think of this as random. I was trying to point out that there can be issues. I wasn't trying to point out all issues, though I'll change the...

  • RE: Fantasy Football 2014

    I think you're both napping, Ray.

    I was working with the laptop on my legs and the kitty kept attacking my typing fingers. This was about 15 minutes later, she called...

  • RE: The Value of Data

    lshanahan (9/25/2014)


    More data isn't necessarily better data - something aptly demonstrated by the Google Flu trends fiasco.

    How data is collected is just as important as quantity if not moreso, as...

  • RE: Fantasy Football 2014

    Sure

  • RE: Random values

    There's nothing right or wrong about aliasing. It's preference.

    I try to use them often, because I find many queries quickly get complex and it's much harder for me to read:

    select...

  • RE: Random values

    edwardwill (9/25/2014)


    Can you explain why you aliased the sys.syscolumns table?

    SELECT TOP 10

    RAND( ROW_NUMBER() OVER (ORDER BY id))

    FROM sys.syscolumns

    is functionally identical, as far as I am aware.

    habit

  • RE: Random values

    Andrew G (9/24/2014)


    SQL 2000: Error 'Row_Number' is not a recognized function name.

    SQL 2005 to 2012: 10 distinct rows returned, answer should be C.

    you should never expect any of our questions...

  • RE: Random values

    Arrggg, wrong box checked.

    10 is correct. I'll award back points tomorrow.

  • RE: Fantasy Football 2014

    You are NOT going to win. change your avatar now, get one where I'm not smiling.

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (9/23/2014)


    jcrawf02 (9/23/2014)


    any folks have any favorites other than w3schools.org or stackoverflow for getting newbies started on web design? This is someone who has zero experience, so I made...

  • RE: Passing parameters to MSSQL backup job

    You'd have to write code that builds this string and passes it in. I'm not sure how you're calling this, but you'd need a wrapper that queries your databases, builds...

  • RE: Testing in Production

    Dan Guzman-481633 (9/23/2014)


    How much did the choppy video and connection errors really cost Apple in terms of lost revenue or reputation? Testing their CDN performance using a world-wide...

Viewing 15 posts - 10,546 through 10,560 (of 39,793 total)