Forum Replies Created

Viewing 15 posts - 32,341 through 32,355 (of 59,099 total)

  • RE: SQL Improvement

    We've only had 2008 boxes at work for a couple of weeks now and haven't explored all of the new joys of SQL Server 2008... that includes filtered indexes. ...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 10:27 pm

    #1392160

  • RE: SQL Improvement

    SpringTownDBA (10/8/2011)

    I like the isnull datediff. Very elegant.

    two questions:

    Would that work in a filtered index?

    "SARGable"?

    Thanks.

    I don't know if it would work in a filtered index because, oddly enough,...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 10:16 pm

    #1392159

  • RE: SQL Improvement

    One other thing (because I see some good folks who GET the idea that "one test is worth a thousand expert opinions" and I want to make life easier for...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 10:13 pm

    #1392157

  • RE: SQL Improvement

    I certainly could be wrong (seen stranger stuff) but your tests may have a flaw, dmoutray... you're not clearing cache between tests and that may make it look like your...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 9:42 pm

    #1392154

  • RE: Poor Data Model

    The following code runs in about 1/5th of the time of the previous code. All I did was separate out the CTE's into invidual pieces of code that populated...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 6:58 pm

    #1392140

  • RE: Poor Data Model

    Almost forgot... you can get the code for the DelimitedSplit8K function from the "Resources" section of the following article...

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 4:41 pm

    #1392131

  • RE: Poor Data Model

    AndrewSQLDBA (10/7/2011)

    i am having issues with a multi part delimiter. One delimiter "$", is at the end of the string. The other delimiter "|", separates the 8 different values so...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 4:39 pm

    #1392130

  • RE: String to rows

    Iulian -207023 (10/8/2011)

    Thank you all,

    Do you have at hand a sample code on how to create the CLR function for splitting a string into rows / fields? I am not...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 3:26 pm

    #1392116

  • RE: Optimal size for a tempdb in production environment

    Sapen (10/8/2011)

    Hi,

    I have few databases in my production SQL Server. I am using SQL Server 2008 Standard Edition SP1 X64 bit. The size of all the databases together is 335GB....

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 3:22 pm

    #1392114

  • RE: Execute Multiple Queries and Maintain Error Logs

    Don't include such a thing in a trigger... if the email system goes down, it'll take that part of SQL Server with it.

    Instead, setup a job to interogate your logs...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 3:08 pm

    #1392113

  • RE: SQL Server 2008 Express Text Field Limit

    I've not used SQL Server Express but I'm pretty sure it will all for the use of VARCHAR(MAX) which will give you capabilities up to 2 billion characters (1 billion...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 3:05 pm

    #1392111

  • RE: New or Existing Database

    Lexa (10/8/2011)

    Hi,

    We're implementing a set of new features for our app and require dynamic creation of tables. My concern is that there will be lots of new data and...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 2:59 pm

    #1392110

  • RE: Backup databases and exclude some of the database

    You probably won't be able to do this through maintenance plans. That's good because I believe that most folks recommend not actually using maintenance plans for various reasons.

    My recommendation...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 2:55 pm

    #1392109

  • RE: License questions

    Lynn Pettis (10/7/2011)

    For a test server (non production) you can purchase the Developer Edition for about $50.

    If the testers are not changing anything in the database, just running the application...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 2:47 pm

    #1392106

  • RE: How Do You Handle Database Documentation?

    dmoutray (10/8/2011)

    Outstanding! Now, this is the kind of insight that I was after! 🙂

    There's more. There's a saying that's actually a paraphrase of a longer version written by...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    October 8, 2011 at 2:41 pm

    #1392105

Viewing 15 posts - 32,341 through 32,355 (of 59,099 total)