Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • Reply To: Using Notebooks in Azure Data Studio

    Thanks for this tutorial, Steve. I just recently learned how useful Markup is, and to be able to have text, code, and code results in the same file is pretty...

  • Reply To: You're not really that good at SQL Server

    I tend to agree with this post, for the most part. I've been working with SQL Server full time now for over six years, and I still feel very much...

  • RE: Are too many linked servers possible?

    Thank you, Chris. I was not aware of the OpenQuery function. I'll have to take a closer look to see if I can get it incorporated.

  • RE: Computed column storage size

    DesNorton (10/19/2016)


    A computed column is not stored, therefor there is no need to be concerned about the size. HOWEVER, SQL has to recompute the value every time that it...

  • RE: Query processing

    drew.allen (10/4/2016)


    I think the main issue is a confusion between logical query processing and physical query processing. The physical query processing does not need to match the logical query...

  • RE: Index guidance needed

    GilaMonster (9/15/2016)


    What's the table frequently filtered by?

    GilaMonster (9/16/2016)


    Good start

    What's the most common predicate used against that table?

    I'm new to index/performance tuning. Could you please explain how to tell what the...

  • RE: Opinions on triggers

    So then what is an appropriate use of a trigger?

  • RE: Opinions on triggers

    TomThomson (3/23/2016)


    ...never rely on applications to maintain data integrity, epecially when the data is used by multiple applications written by different development teams.

    I really like this quote and am going...

  • RE: Opinions on triggers

    Wow. That is a lot of food for thought and exactly what I was looking for.

    It appears that there's somewhat of a consensus on how triggers could/should be used....

  • RE: The Advent of Code

    There are already two excellent sites that look like a lot of fun. They'll definitely come in handy to help me with my New Year's resolution to watch less TV....

  • RE: The Advent of Code

    This is a terrific idea! I never knew anything like this existed. I would love to learn other languages as well as enhance my current skill set, but my problem...

  • RE: What will happen with below code???

    Yep. Got burned by the lack of 'ALL'. That will teach me to read a little more carefully.

Viewing 12 posts - 1 through 12 (of 12 total)