Forum Replies Created

Viewing 15 posts - 8,851 through 8,865 (of 9,399 total)

  • RE: Number of FOREIGN KEY Constraints in a Table

    Okay, this means that you don't have a single "huge foreign key" at all, but rather a lot of foreign keys to a primary key on a single table. ...

  • RE: Number of FOREIGN KEY Constraints in a Table

    shahi.alokchandra (10/25/2013)


    I have few more question which is raise after getting replies.

    1. Should i create such a huge foreign key on any table if having such type of requirement,that means...

  • RE: How to Identify name starting with a specific letter without using like operator?

    It sounds like a homework question to me. The lesson would be that, aside from the obvious approach, there's more than one way to accomplish something. In this...

  • RE: Number of FOREIGN KEY Constraints in a Table

    shahi.alokchandra (10/25/2013)


    I am managing creation detail of each records due to some reason.so saving login with each entry.and i am having more then 300 tables in which i am referencing...

  • RE: Number of FOREIGN KEY Constraints in a Table

    Koen Verbeeck (10/25/2013)


    shahi.alokchandra (10/25/2013)


    Why would you need so many FK on a single table?

    Agreed. There may be a "small design issue" that needs to be addressed if you need...

  • RE: Are the posted questions getting worse?

    mickyT (10/24/2013)


    L' Eomot Inversé (10/24/2013)


    wolfkillj (10/23/2013)


    I've published my first technical blog post. I'd appreciate any feedback from this group on both the technical aspects and the writing. Thanks, everyone!

    Nice article....

  • RE: SQL Server 2012 service accounts

    Toreador (10/25/2013)


    "Exceptions are ..."

    So the correct answer is actually "it depends"?

    Agreed - the same as so many other answers. It usually depends on __.

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (10/24/2013)


    mickyT (10/24/2013)


    For some open data options you may want to have a look at the following site. They may have a link to something that may help....

  • RE: How can i get all the servers disk space in to one table

    What if you run it on the C: drive only? What is your output here?

    execute xp_cmdshell 'fsutil volume diskfree c:';

  • RE: Copy all jobs between SQL Server 2008 R2 and SQL Server 2012

    rray 44280 (10/23/2013)


    I'm feeling a bit dense here :-). F7 to get the Object Details was a breakthrough. I was able to select all the jobs (or Control-Click to get...

  • RE: Concatenate Fields, But Evenly Space

    The query Luis or Bill posted will work, but as Luis also pointed out, it will depends on the font face. If you're putting this into a standard dropdown,...

  • RE: Today's Random Word!

    Peace and quiet

  • RE: How can i get all the servers disk space in to one table

    I don't know about getting it into a table with power shell and batch files, but here's an approach that would work in SQL. It'll fire the fsutil DOS...

  • RE: Today's Random Word!

    Kurt W. Zimmerman (10/23/2013)


    Ed Wagner (10/23/2013)


    Revenant (10/22/2013)


    Ed Wagner (10/22/2013)


    crookj (10/22/2013)


    Daniel Bowlin (10/22/2013)


    jasona.work (10/22/2013)


    Ed Wagner (10/22/2013)


    crookj (10/21/2013)


    jasona.work (10/21/2013)


    Ed Wagner (10/21/2013)


    Revenant (10/18/2013)


    Ed Wagner (10/18/2013)


    crookj (10/17/2013)


    Ed Wagner (10/17/2013)


    Daniel Bowlin (10/17/2013)


    breviloquent

    succinct

    laconic

    terse

    brief

    boxer

    Rocky

    and Bullwinkle

    Rabbit

    season!

    Elmer Fudd

    "Be vewy...

  • RE: Today's Random Word!

    Revenant (10/22/2013)


    Ed Wagner (10/22/2013)


    crookj (10/22/2013)


    Daniel Bowlin (10/22/2013)


    jasona.work (10/22/2013)


    Ed Wagner (10/22/2013)


    crookj (10/21/2013)


    jasona.work (10/21/2013)


    Ed Wagner (10/21/2013)


    Revenant (10/18/2013)


    Ed Wagner (10/18/2013)


    crookj (10/17/2013)


    Ed Wagner (10/17/2013)


    Daniel Bowlin (10/17/2013)


    breviloquent

    succinct

    laconic

    terse

    brief

    boxer

    Rocky

    and Bullwinkle

    Rabbit

    season!

    Elmer Fudd

    "Be vewy vewy quiet, I'm hunting wabbits"...

Viewing 15 posts - 8,851 through 8,865 (of 9,399 total)