Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 9,399 total)

  • RE: SOME/ANY/ALL

    I learned something new today, so thank you.

  • RE: Issue with synonyms across servers

    tarr94 (8/16/2016)


    I've reviewed the permissions carefully for the synonym and the linked server we have set up to go between the two servers.

    You've reviewed permissions for the synonym, but have...

  • RE: Determining the most populated zip code in a county

    Check out the site http://www.geonames.org/. They have free and paid levels of data you can download. Be forewarned that the files are not small and it changes frequently,...

  • RE: "set nocount on" question

    The SET NOCOUNT ON tells SQL Server to not print out the number of rows affected by each query. When connecting via external applications, I've seen it shown that...

  • RE: Execution Plan Question

    I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the JOIN and WHERE clauses. If you...

  • RE: Today's Random Word!

    whereisSQL? (8/17/2016)


    Revenant (8/17/2016)


    Manic Star (8/17/2016)


    HappyGeek (8/17/2016)


    Ed Wagner (8/17/2016)


    djj (8/17/2016)


    Kaye Cahs (8/16/2016)


    Luis Cazares (8/16/2016)


    whereisSQL? (8/16/2016)


    Ed Wagner (8/16/2016)


    Ray K (8/16/2016)


    Ed Wagner (8/16/2016)


    whereisSQL? (8/16/2016)


    HappyGeek (8/16/2016)


    Grumpy DBA (8/16/2016)


    Y.B. (8/16/2016)


    Pop

    Soda

    Water

    Ice

    Broken

    Wings

    Hot

    Buffalo

    Bison

    Burger

    Fries

    Onion Rings

    onion bhaji

    Raita

    Yogurt

    Frozen

    Custard

  • RE: Today's Random Word!

    Manic Star (8/17/2016)


    HappyGeek (8/17/2016)


    Ed Wagner (8/17/2016)


    djj (8/17/2016)


    Kaye Cahs (8/16/2016)


    Luis Cazares (8/16/2016)


    whereisSQL? (8/16/2016)


    Ed Wagner (8/16/2016)


    Ray K (8/16/2016)


    Ed Wagner (8/16/2016)


    whereisSQL? (8/16/2016)


    HappyGeek (8/16/2016)


    Grumpy DBA (8/16/2016)


    Y.B. (8/16/2016)


    Pop

    Soda

    Water

    Ice

    Broken

    Wings

    Hot

    Buffalo

    Bison

    Burger

    Fries

    Onion Rings

    onion bhaji

    Raita

    Ratatouille

  • RE: Need query for After Trigger on update,delete

    Jeff Moden (8/17/2016)


    ScottPletcher (8/17/2016)


    Again, auditors would not have access to the original table.

    But they have direct access to the audit table? That doesn't make sense to me but, of...

  • RE: Are the posted questions getting worse?

    jasona.work (8/17/2016)


    Man, take a week and change off from here, and have a lot to catch up on...

    Forums being moved to a new back-end, cheap beer pubs with hair in...

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/17/2016)


    Luis Cazares (8/17/2016)


    Brandie Tarvin (8/17/2016)


    Eirikur Eiriksson (8/17/2016)


    BrainDonor (8/17/2016)


    ChrisM@Work (8/17/2016)


    We have git hubs all over the UK. They're also known as Weatherspoons.

    You owe me a new keyboard...

    😀

    ...just managed to save...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/17/2016)


    Eirikur Eiriksson (8/17/2016)


    BrainDonor (8/17/2016)


    ChrisM@Work (8/17/2016)


    We have git hubs all over the UK. They're also known as Weatherspoons.

    You owe me a new keyboard...

    😀

    ...just managed to save mine

    😎

    I have apparently...

  • RE: Index Usage

    ChrisM@Work (8/17/2016)


    There is a use case for having an ordinary index with the same leading edge column as the clustered index. If your table is very wide (meaning less rows...

  • RE: Today's Random Word!

    djj (8/17/2016)


    Kaye Cahs (8/16/2016)


    Luis Cazares (8/16/2016)


    whereisSQL? (8/16/2016)


    Ed Wagner (8/16/2016)


    Ray K (8/16/2016)


    Ed Wagner (8/16/2016)


    whereisSQL? (8/16/2016)


    HappyGeek (8/16/2016)


    Grumpy DBA (8/16/2016)


    Y.B. (8/16/2016)


    Pop

    Soda

    Water

    Ice

    Broken

    Wings

    Hot

    Buffalo

    Bison

    Burger

    Fries

    Onion Rings

  • RE: The Max datetime

    Like Paul pointed out, the question asks about the max of a datetime. Given the answers provided, it wasn't too hard to figure out. Sure, it's an inaccurate...

  • RE: Database not listed in SSMS object explorer

    Does the database actually exist? Do you need to refresh the database list in SSMS?

Viewing 15 posts - 2,716 through 2,730 (of 9,399 total)