Forum Replies Created

Viewing 15 posts - 2,131 through 2,145 (of 9,399 total)

  • RE: How do I SELECT DISTINCT on a field into a new table while including all columns?

    chriso 73655 (12/9/2016)


    I got it to work in SQL but I figured out that it's not a SQL issue this line works:

    select * Into NewTabe from( select *, row_number()over(partition by...

  • RE: DBA without sa rights???

    webrunner (12/9/2016)


    ZZartin (12/8/2016)


    Don't bother trying to fight with a power hungry network admin. Make it known immediately to your supervisor that you are unable to do your job in...

  • RE: have issue with istallation of 2016 /

    kevaburg (12/10/2016)


    From my point of view you quite simply don't have the permissions to perform the installation.

    Have you tried starting the Installation with elevated privileges (Run As Administrator)?

    The Red Cross...

  • RE: Disk space full

    Your reaction to the drive space problem depends on the type of environment you're talking about.

    If this is a production database that feeds a live website for a business and...

  • RE: Disk space full

    kevaburg (12/9/2016)


    Try a shrinkdatabase:

    exec sp_msforeachdb 'DBCC SHRINKDATABASE [?]';

    It is far from ideal and you will most likely experience performance problems during the run (do it in a maintenance window) but...

  • RE: Today's Random Word!

    TomThomson (12/9/2016)


    ZZartin (12/9/2016)


    Luis Cazares (12/9/2016)


    Revenant (12/9/2016)


    djj (12/9/2016)


    crookj (12/9/2016)


    Ed Wagner (12/9/2016)


    Stuart Davies (12/9/2016)


    Manic Star (12/8/2016)


    Alan.B (12/8/2016)


    Gravitational

    Threshold

    Boundary

    Border

    Line

    Vector

    Algebra

    Calculus

    Apple

    Eden

    Adam

  • RE: Are the posted questions getting worse?

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


    Friday, hectic day as I get ready for SQL in the City next week and a flight across the water on Sunday.

    Then I'm off for...

  • RE: Help with query to find duplicate fields from one column and return relevant information

    Hello and welcome to SSC. I think I understand what you're looking for, but we're going to need the DDL for the tables involved. Please see the link...

  • RE: SQL Server 2016 SP1 Features

    Yep, many have already pointed out the error. Wishful thinking, but they have to leave something for EE other than CPU and memory limitations.

  • RE: Today's Random Word!

    Stuart Davies (12/9/2016)


    Manic Star (12/8/2016)


    Alan.B (12/8/2016)


    Gravitational

    Threshold

    Boundary

    Border

  • RE: Today's Random Word!

    Revenant (12/8/2016)


    Kaye Cahs (12/8/2016)


    Manic Star (12/8/2016)


    crookj (12/8/2016)


    Brandie Tarvin (12/8/2016)


    Stuart Davies (12/8/2016)


    Ray K (12/7/2016)


    whereisSQL? (12/7/2016)


    Manic Star (12/7/2016)


    Ed Wagner (12/7/2016)


    djj (12/7/2016)


    Luis Cazares (12/7/2016)


    Ed Wagner (12/7/2016)


    DamianC (12/7/2016)


    Revenant (12/7/2016)


    Manic Star (12/7/2016)


    Limbo

    Stick

    Man

    Machine

    War

    Materials

    Labor

    Delivery

    Midwife

    Midtown

    Midriff

    Bare

    necessities

    oxygen

    Hydrogen

    Bomb

    Explosion

  • RE: Today's Random Word!

    djj (12/7/2016)


    Luis Cazares (12/7/2016)


    Ed Wagner (12/7/2016)


    DamianC (12/7/2016)


    Revenant (12/7/2016)


    Manic Star (12/7/2016)


    Limbo

    Stick

    Man

    Machine

    War

    Materials

    Labor

  • RE: Today's Random Word!

    DamianC (12/7/2016)


    Revenant (12/7/2016)


    Manic Star (12/7/2016)


    Limbo

    Stick

    Man

    Machine

  • RE: Today's Random Word!

    whereisSQL? (12/7/2016)


    crookj (12/7/2016)


    aPed001 (12/7/2016)


    TomThomson (12/7/2016)


    Manic Star (12/7/2016)


    Brandie Tarvin (12/7/2016)


    Ed Wagner (12/7/2016)


    crookj (12/7/2016)


    Ed Wagner (12/7/2016)


    djj (12/7/2016)


    Ed Wagner (12/6/2016)


    Manic Star (12/6/2016)


    whereisSQL? (12/6/2016)


    Revenant (12/6/2016)


    Iceland

    IceCream

    Vanilla

    Sugar

    Brown

    Molasses

    Flood (of 1919)

    Browning (first thing I think of when I...

  • RE: Today's Random Word!

    crookj (12/7/2016)


    Ed Wagner (12/7/2016)


    djj (12/7/2016)


    Ed Wagner (12/6/2016)


    Manic Star (12/6/2016)


    whereisSQL? (12/6/2016)


    Revenant (12/6/2016)


    Iceland

    IceCream

    Vanilla

    Sugar

    Brown

    Molasses

    Flood (of 1919)

    Browning (first thing I think of when I see 1919)

Viewing 15 posts - 2,131 through 2,145 (of 9,399 total)