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...

    December 10, 2016 at 9:39 am

    #1917246

  • 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...

    December 10, 2016 at 9:28 am

    #1917245

  • 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...

    December 10, 2016 at 9:16 am

    #1917244

  • 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...

    December 10, 2016 at 9:13 am

    #1917243

  • 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...

    December 10, 2016 at 9:04 am

    #1917194

  • 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

    December 9, 2016 at 11:57 am

    #1917152

  • 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...

    December 9, 2016 at 11:46 am

    #1917151

  • 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...

    December 9, 2016 at 5:27 am

    #1917019

  • 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.

    December 9, 2016 at 5:23 am

    #1917018

  • RE: Today's Random Word!

    Stuart Davies (12/9/2016)

    Manic Star (12/8/2016)

    Alan.B (12/8/2016)

    Gravitational

    Threshold

    Boundary

    Border

    December 9, 2016 at 5:10 am

    #1917015

  • 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

    December 8, 2016 at 8:35 am

    #1916805

  • 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

    December 7, 2016 at 12:35 pm

    #1916610

  • RE: Today's Random Word!

    DamianC (12/7/2016)

    Revenant (12/7/2016)

    Manic Star (12/7/2016)

    Limbo

    Stick

    Man

    Machine

    December 7, 2016 at 10:27 am

    #1916577

  • 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...

    December 7, 2016 at 9:25 am

    #1916557

  • 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)

    December 7, 2016 at 6:45 am

    #1916496

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