Forum Replies Created

Viewing 15 posts - 3,316 through 3,330 (of 8,731 total)

  • RE: Simple fill factor question

    You might be missing the fact that clustered indexes are actually the data from the table.

    Fill factor is a setting for building or re-building indexes. So it will 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

    February 19, 2016 at 10:59 am

    #1859902

  • RE: Today's Random Word!

    crookj (2/19/2016)

    Revenant (2/19/2016)

    ThomasRushton (2/19/2016)

    DonlSimpson (2/19/2016)

    ThomasRushton (2/19/2016)

    Stuart Davies (2/19/2016)

    SQLRNNR (2/19/2016)

    mussels

    COCKLES

    Wombles

    Tobermory

    Harbour

    Light

    Speed

    Force

    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

    February 19, 2016 at 10:48 am

    #1859897

  • RE: Optimize Store Procedure

    Most of your OUTER APPLY derived tables can be rewritten as Cross Tabs to reduce the reads on your snapshot tables. I can't give an exact query as I don't...

    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

    February 19, 2016 at 10:01 am

    #1859887

  • RE: SQL Query

    Not to be rude, but you should know this by now:

    http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

    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

    February 18, 2016 at 9:48 am

    #1859626

  • RE: Today's Random Word!

    crookj (2/18/2016)

    djj (2/18/2016)

    Ray K (2/18/2016)

    eccentricDBA (2/17/2016)

    bamboozle

    Bambino

    BamBam

    Dino

    Pebbles

    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

    February 18, 2016 at 8:23 am

    #1859596

  • RE: TRY_CONVERT smaller

    kumar1pr (2/18/2016)

    Anyone can point to the reason why first is converted while second one fail?

    SELECT TRY_CONVERT(DATE,'2016/10/05')

    :w00t:

    SELECT TRY_CONVERT(DATE,'12/31/2010')

    :hehe:

    Because the first has a format that isn't misleading, while the second does. 😎

    That's...

    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

    February 18, 2016 at 8:22 am

    #1859594

  • RE: Windows Functions: Tell me when that changes.

    John Mitchell-245523 (2/18/2016)

    davidawest00 (2/17/2016)

    SS will create ALL THE ROWS for a CTE before it processes the main query, whether it will need all those rows or not

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

    February 18, 2016 at 8:05 am

    #1859588

  • RE: Windows Functions: Tell me when that changes.

    j-1064772 (2/18/2016)

    The execution plans do not tell the whole story. I have seen some cases by Gila Monster where the execution was simplified but the load on the server was...

    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

    February 18, 2016 at 7:56 am

    #1859579

  • RE: Are the posted questions getting worse?

    djj (2/18/2016)

    Hey, who shut down the water cooler? I do not post often here, but I read it every day. Usually there is a lot going on by...

    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

    February 18, 2016 at 7:28 am

    #1859568

  • RE: SQL Insert Statement that increments based on Line Seq

    Probably something like this:

    INSERT INTO #EmailAddrTbl WITH(TABLOCKX)

    (AccountID,

    LineSeq,

    Email)

    SELECT AccountID,

    MaxLineSeq + ROW_NUMBER() OVER(...

    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

    February 17, 2016 at 2:45 pm

    #1859392

  • RE: Pivot based off two columns

    Find more information in this article:

    http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

    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

    February 17, 2016 at 1:49 pm

    #1859368

  • RE: CUBE question

    mw112009 (2/17/2016)

    Can anyone suggest a article/site for me to get started with learning about CUBES

    Do you know the concepts of a data warehouse? I'd start with that.

    Do you want to...

    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

    February 17, 2016 at 1:48 pm

    #1859367

  • RE: Windows Functions: Tell me when that changes.

    These articles with real life examples are great to help people get rid of cursors and change the mentalities.

    I just wanted to make 2 comments:

    For sample data, create a table...

    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

    February 17, 2016 at 1:38 pm

    #1859364

  • RE: Retrieving data per time interval help

    There's nothing in your query that limits the results to one hour, unless the TagName has something to do with it.

    Since you're rounding your Value column, you should use 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

    February 17, 2016 at 1:04 pm

    #1859361

  • RE: Display numeric as empty string based on condition

    Alan.B (2/17/2016)

    Luis Cazares (2/17/2016)

    You might want to reduce your varchar length. I've never heard of a common use for such large numbers.

    haha - I missed the comment about converting to...

    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

    February 17, 2016 at 10:50 am

    #1859331

Viewing 15 posts - 3,316 through 3,330 (of 8,731 total)