Forum Replies Created

Viewing 15 posts - 241 through 255 (of 626 total)

  • RE: CTE Script Needed for delete statement

    If you are worried about locking a table when deleting a lot of rows you could delete in batches. As far as actual delete speed just make sure you...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    July 5, 2016 at 1:51 pm

    #1888557

  • RE: Today's Random Word!

    Ed Wagner (7/5/2016)

    ThomasRushton (7/5/2016)

    Stuart Davies (7/5/2016)

    Club

    Kitkat

    Candy

    Cane

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    July 5, 2016 at 8:01 am

    #1888457

  • RE: Today's Random Word!

    Manic Star (6/30/2016)

    ZZartin (6/30/2016)

    Luis Cazares (6/30/2016)

    Ed Wagner (6/30/2016)

    Manic Star (6/30/2016)

    Grumpy DBA (6/30/2016)

    Ed Wagner (6/30/2016)

    Race

    Rat

    Tail

    Head

    Body

    Site

    Downtime

    Relaxing

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 30, 2016 at 8:56 am

    #1887909

  • RE: rows to columns

    Charmer (6/29/2016)

    I am getting different values for DatabaseName, ReportID on same date.

    I want to show both values. But pivot choose max value.

    Possible to handle this?

    Do you mean to say that...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 30, 2016 at 7:57 am

    #1887879

  • RE: rows to columns

    durga.palepu (6/28/2016)

    Yet another good alternative to learn but little complex compared to pivot solution.

    Actually only the dynamic aspect makes it seem complicated which would also hold true if built with...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 28, 2016 at 2:09 pm

    #1887430

  • RE: Today's Random Word!

    djj (6/28/2016)

    Ed Wagner (6/28/2016)

    Ray K (6/28/2016)

    crookj (6/28/2016)

    eccentricDBA (6/28/2016)

    Luis Cazares (6/28/2016)

    Ed Wagner (6/28/2016)

    Grumpy DBA (6/28/2016)

    ThomasRushton (6/28/2016)

    Ed Wagner (6/28/2016)

    Red

    Rum

    Shining

    Johnny

    Bravo

    Tango

    Foxtrot

    Whisky

    Delta

    Dawn

    Dusk

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 28, 2016 at 8:13 am

    #1887307

  • RE: rows to columns

    Since I was already working on it here is a dynamic crosstab example Jeff was talking about.

    DECLARE @Actual TABLE (ReportDate date , DatabaseName varchar(10), ReportID int , TotalSum bigint )...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 28, 2016 at 8:10 am

    #1887306

  • RE: Is there a function to format the date like this ?

    I would also like to say that hopefully this is for display purposes only (which could instead be handled by the client side application). Whatever you do, make sure...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 27, 2016 at 9:54 am

    #1887081

  • RE: Reduce Log Database

    Check the properties of your database and find it's Recovery Model.

    Log files are automatically truncated in Simple recovery model. Otherwise if the recovery model is set to FULL or...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 27, 2016 at 8:47 am

    #1887070

  • RE: Nasty Fast N-Grams (Part 1): Character-Level Unigrams

    Excellent article! While I've had no need for this yet, I can easily see how this could come in handy one day. Added to my briefcase...looking forward to...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 23, 2016 at 8:18 am

    #1886545

  • RE: Today's Random Word!

    Ed Wagner (6/23/2016)

    Grumpy DBA (6/23/2016)

    Ed Wagner (6/23/2016)

    Plain

    Jane

    Tarzan

    Lord (of the apes)

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 23, 2016 at 7:55 am

    #1886538

  • RE: Update variable having timestamp value in it.

    It's not clear if your requirement is to round to the nearest hour or just round down or something else?

    If you need to round down or up based on minutes...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 23, 2016 at 7:45 am

    #1886530

  • RE: Today's Random Word!

    Hugo Kornelis (6/21/2016)

    Ed Wagner (6/21/2016)

    Manic Star (6/21/2016)

    Grumpy DBA (6/21/2016)

    Ed Wagner (6/21/2016)

    Luis Cazares (6/21/2016)

    Revenant (6/21/2016)

    Ray K (6/21/2016)

    djj (6/21/2016)

    Roller

    Derby

    Hat

    Sombrero

    Mexico

    Cartels

    Tequila

    Worm

    Sand

    Dune

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2016 at 1:43 pm

    #1886113

  • RE: What is a good way to consume a Rest API with SSIS?

    Personally I find PowerShell well suited for something like this. However, it can be a bit tricky especially if you are new to it.

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 21, 2016 at 7:20 am

    #1886020

  • RE: Run through all user tables, add an user

    Roles are your friend here...you should add the user to the db_datareader role which will have the same effect. You have to ask yourself, do you really want to...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    June 20, 2016 at 7:04 am

    #1885831

Viewing 15 posts - 241 through 255 (of 626 total)