Forum Replies Created

Viewing 15 posts - 7,771 through 7,785 (of 39,769 total)

  • RE: Execute Proc at Startup Question

    Nothing happens. I created this proc on SQL 2014:

    CREATE PROCEDURE mystarer

    AS

    SELECT 1/0

    EXEC sp_procoption 'mystarer', 'startup', 1

    I then restarted the instance. After loading XP DLLs, the next entry is "Launched...

  • RE: The View Insert

    Fair enough, Tom, but I think it makes perfect sense the way MS has defined this and it works. The view references 6 columns in one table, and since they...

  • RE: Changing Replication Passwords

    Thanks. don't make it hard. Focus on just changing pwds and where, with the immediate implications.

  • RE: Talking baseball

    I don't think the ASG should matter. It ends up getting mismanaged for a game that matters. If it matters, don't change pitchers too often and get everyone in.

    Personally, I...

  • RE: Losing Rows

    So, depending on your scale, there are consistency issues in SQL Server. In flight transactions aren't shown in reports/queries, which can come to life in high volume systems with long...

  • RE: The View Insert

    You are all welcome, and glad I got a good one here. This was something I learned as well.

  • RE: Democratic Data Science

    Jeff Moden (6/28/2016)


    Steve Jones - SSC Editor (6/28/2016)


    However now most major sports, at high amateur and pro levels, use all sorts of analytics.

    And, most of the time, they don't...

  • RE: Changing Replication Passwords

    It is, want to tackle this?

  • RE: Are the posted questions getting worse?

    WayneS (7/12/2016)


    Steve Jones - SSC Editor (7/12/2016)


    It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse....

  • RE: Baby Steps to DevOps

    That stuff is exactly what's a part of CI/CD/DevOps. However, since you're alone, you don't need as much communication or transparency.

    However, I wouldn't knock that and say it's not DevOps....

  • RE: Default tempdb in SQL Server 2106

    I'm trying. Sometimes inspiration is hard.

  • RE: Are the posted questions getting worse?

    It's actually a handicapped equestrian ramp. The horse is between the structures. The right is a platform for an assistant to hold the horse. The left ramp allows a wheelchair...

  • RE: Are the posted questions getting worse?

    So, out Fri and Sat to help my kid work on his Eagle Scout project (finally). We went from this Fri:

    to this by Sat afternoon:

    Proud of his efforts, including managing...

  • RE: Are the posted questions getting worse?

    jasona.work (7/11/2016)


    Yeah, we've looked at a whole-house generator, right now it's just not in the budget. Considering we'd only want to keep the fridge and sump running, it would...

  • RE: Sequence generation

    You could use row_number to build a list that increments from the last item.

    I'm not sure where you need this, or when, so it's hard to do code, but if...

Viewing 15 posts - 7,771 through 7,785 (of 39,769 total)