Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 8,731 total)

  • RE: Today's Random Word!

    Ed Wagner (8/18/2016)

    Ray K (8/18/2016)

    ThomasRushton (8/18/2016)

    sub

    hoagie

    Steak

    Shake

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 18, 2016 at 10:34 am

    #1896207

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/18/2016)

    Luis Cazares (8/18/2016)

    We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 18, 2016 at 10:13 am

    #1896204

  • RE: SQL Pivot Assistance Needed

    If you're going to generate the pivot in excel, just query the normalized data and create the pivot there. You can create a view which could be the source for...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 18, 2016 at 9:18 am

    #1896185

  • RE: Are the posted questions getting worse?

    We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 18, 2016 at 8:59 am

    #1896178

  • RE: Confused about backups and recovery models

    andrew gothard (8/17/2016)

    Very briefly:

    Full -

    allows you to restore to a point in time - say 4 seconds past 5 this afternoon when someone accidentally...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 17, 2016 at 12:27 pm

    #1896002

  • RE: Rounding in tsql

    I did test as well.

    CREATE TABLE #Test(

    Units decimal(10,5),

    DesiredResult decimal(10,5),

    );

    INSERT INTO...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 17, 2016 at 12:23 pm

    #1896001

  • RE: Rounding in tsql

    ntreelevel (8/17/2016)

    This is the custom case statement that I used

    case when (units - floor(units)) < 0.49 then round(units,2)

    when...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 17, 2016 at 11:35 am

    #1895985

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/9/2016)

    TomThomson (8/9/2016)

    Phil Parkin (8/9/2016)

    This code was generated by a tool.

    Does anyone else subconsciously say "You can say that again" whenever they read this comment in auto-generated code? 🙂

    It's more...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 17, 2016 at 7:07 am

    #1895905

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

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 17, 2016 at 6:47 am

    #1895898

  • RE: Re-ordering a Sequence

    An additional clause should do the trick.

    WITH CTE AS(

    SELECT *, ROW_NUMBER() OVER( ORDER BY CASE WHEN seq = @OldSeq THEN @NewSeq

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 16, 2016 at 2:15 pm

    #1895775

  • RE: Re-ordering a Sequence

    What about this?

    create table #temp(seq int,step varchar(50))

    insert into #temp (seq,step) values (1,'do this first')

    insert into #temp (seq,step) values (2,'then do this')

    insert into #temp (seq,step) values (3,'finally do this')

    insert into #temp...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 16, 2016 at 1:48 pm

    #1895765

  • RE: Re-ordering a Sequence

    adam-639168 (8/16/2016)

    Hello, I have a table where users enter action steps. The SEQ column indicates the step # (step 1, step 2, etc.). I am having trouble updating...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 16, 2016 at 1:12 pm

    #1895758

  • RE: Today's Random Word!

    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

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 16, 2016 at 12:58 pm

    #1895753

  • RE: Query plan analysis

    I'd say that a bad plan is when estimates aren't similar to reality. That would cause choosing the wrong operation.

    There's no such thing as a bad operator, there are only...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 16, 2016 at 9:38 am

    #1895697

  • RE: need to copy a 600 gig table

    Jeff Moden (8/16/2016)

    Luis Cazares (8/12/2016)

    but minimal logging can make the log grow even more than normal logging

    I've never seen actual minimal logging cause such a thing especially since about the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 16, 2016 at 8:07 am

    #1895654

Viewing 15 posts - 2,281 through 2,295 (of 8,731 total)