Forum Replies Created

Viewing 15 posts - 5,266 through 5,280 (of 9,399 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/31/2015)


    Luis Cazares (8/31/2015)


    Brandie Tarvin (8/31/2015)


    I am planning to upgrade at least one of my machines. Haven't decided if it'll be the 8.1 or 7. But I'm waiting to hear...

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/31/2015)


    Brandie Tarvin (8/31/2015)


    Ed Wagner (8/31/2015)


    Sean Lange (8/31/2015)


    Grant Fritchey (8/31/2015)


    For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From the Microsoft...

  • RE: Are the posted questions getting worse?

    Sean Lange (8/31/2015)


    Grant Fritchey (8/31/2015)


    For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From the Microsoft forums, quite a few others...

  • RE: The Problem Solver

    Sean Redmond (8/30/2015)


    I use the analogy of cost-based heuristics of the SQL Server query engine. It doesn't always choose the most efficient implementation of a query, rather just one that...

  • RE: Restoring a DataBase in another SQL Server

    I think the goal of moving in that direction is to arrive at a place where the "sa" login can be disabled and left that way. It's a well-known...

  • RE: Counting Rows

    I found this question to be very simple and I was looking for the hidden trick. 😛

  • RE: Are the posted questions getting worse?

    TomThomson (8/30/2015)


    Just upgraded my toy to Windows 10 (MS had work to do to make it possible on tis hardware, so couldn't do it earlier).

    It took a very long time...

  • RE: Jump In

    This is an awesome site and truly great community. The thing I think I enjoy most is the discussion that evolves from the original question. Many times, there's...

  • RE: General question concerning Users and allowing SQL queries on a database

    xsevensinzx (8/29/2015)


    Ed Wagner (8/29/2015)


    xsevensinzx (8/29/2015)


    Ed Wagner (8/28/2015)


    Scott, I agree with you that the point is to run a business. You raise a good point about perspective. It may...

  • RE: Restoring a DataBase in another SQL Server

    Once you get the logins created on the destination server, you can restore from your backup. The only caution is that the SQL Server logins and database user SIDs...

  • RE: General question concerning Users and allowing SQL queries on a database

    xsevensinzx (8/29/2015)


    Ed Wagner (8/28/2015)


    Scott, I agree with you that the point is to run a business. You raise a good point about perspective. It may be that cutting...

  • RE: SQL Performance Elevenses

    Very nice list, Phil. I wish I could get people to understand #11. It would make my life so much easier. I think I'm going to use...

  • RE: Not Exist causing major performance problem

    You've been around long enough to know what's needed to address a problem.

    Like Luis and Lynn said, read your own signature block.

  • RE: CTE within a stored proc

    GilaMonster (8/28/2015)


    Ed Wagner (8/28/2015)


    I've seen the TOP 100 PERCENT...ORDER BY hack used in actual view definitions. I know it worked in SQL 2005, but I seem to recall it...

  • RE: CTE within a stored proc

    I've seen the TOP 100 PERCENT...ORDER BY hack used in actual view definitions. I know it worked in SQL 2005, but I seem to recall it not working in...

Viewing 15 posts - 5,266 through 5,280 (of 9,399 total)