Forum Replies Created

Viewing 15 posts - 19,456 through 19,470 (of 59,098 total)

  • RE: Fusion-IO or Nimble?

    Michael L John (10/13/2015)

    So, which one did you end up going with, and why?

    I am in the middle of this same process.

    Heh... "Nimble".

    Why? "Because they said so". No...

    --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 13, 2015 at 9:49 am

    #1833027

  • RE: Scale out SQL Server Databases

    jonjonben (10/11/2015)

    How will you best architect such requirement?

    "It Depends". I'd have to know a whole lot more than what's been offered on this post, so far. I believe...

    --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 11, 2015 at 8:16 am

    #1832713

  • RE: CTE to improve performance

    Pick the piece that returns the smallest number of rows that the rest of the query will be dependent on. Stuff that into a Temp Table and join to...

    --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 11, 2015 at 8:10 am

    #1832711

  • RE: Deploying tech to the cloud

    To be honest, I don't see anything in your article that should be different between how an application should be developed for the cloud or for non-cloud apps except that...

    --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 11, 2015 at 6:46 am

    #1832703

  • RE: CTE to improve performance

    nadersam (10/11/2015)

    Hi All,

    I was wondering if using CTE could lead to performance enhancement.

    My idea was if i have a big view referencing many tables and some are big tables.

    If some...

    --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 11, 2015 at 6:37 am

    #1832702

  • RE: Scale out SQL Server Databases

    jonjonben (10/11/2015)

    Immensely, incredibly, horribly difficult. There's no easy way to scale SQL out, just lots and lots and lots of work.

    From your posts, seems like scale-up is costly, and scale-out...

    --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 11, 2015 at 6:31 am

    #1832701

  • RE: how to restart or take db in single user mode by hounering all requests.

    rajemessage 14195 (10/10/2015)

    hi,

    some times i need to take db in single user mode , which can be done

    using following

    use master

    go

    alter database db_name set single_user with...

    --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 10, 2015 at 1:42 pm

    #1832690

  • RE: Full Backup Report

    Arjun SreeVastsva (10/9/2015)

    Hi,

    according to envionemnet .we are planning to genrate the weekly full backups report of all the servers.i have developed the SSIS Package that will run in all servers...

    --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 10, 2015 at 1:40 pm

    #1832689

  • RE: Concat

    gary1 (10/9/2015)

    Concat is not working in 2008 R2. Can you please advise how to write the below line without using concat.

    declare @EXPDate varchar(25) = Concat(Convert(varchar(20),dateadd(day,@RetentionDays,getdate()), 101),' ',Convert(varchar(20),dateadd(day,@RetentionDays,getdate()), 108));

    Remove the CONCAT...

    --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 10, 2015 at 1:36 pm

    #1832688

  • RE: How efficient is your covered index?

    Andre Ranieri (10/9/2015)

    Can I get clarification on SARGability related to the predicate CarrierTrackingNumber = ISNULL(@Carrier, CarrierTrackingNumber)? I would have thought that this predicate is still SARGable since the...

    --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 9, 2015 at 6:05 pm

    #1832678

  • RE: No predicate join work around

    SQL_Surfer (10/8/2015)

    I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I can join on these two tables. But...

    --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 9, 2015 at 1:20 pm

    #1832652

  • RE: Slow performance when using Table Type Parameter and passing through c#

    brad.mason5 (10/9/2015)

    Is there a better way to pass 50,000 INTs over the wire?

    Are the numbers are being generated by the app? What I mean by that is it seems...

    --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 9, 2015 at 1:15 pm

    #1832647

  • RE: Make a column immutable, once set it sticks

    terry999 (10/9/2015)

    I hope I remember this checksum computed column for future next time I need something similar.

    Careful now. There IS a thing in SQL Server that's actually called a...

    --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 9, 2015 at 7:48 am

    #1832536

  • RE: Need best way to move historical data out

    krypto69 (9/29/2015)

    These tables are barely used and are taking up way too much space and time for maintenance.

    Are ANY rows that are older than 2 years EVER updated? Also,...

    --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 9, 2015 at 7:32 am

    #1832523

  • RE: Need help putting data into XML format

    philcart (10/8/2015)

    Jeff, surely you're forgetting the times when you need a XSL file and namespaces declarations :-D:-D

    Heh... not forgetting... trying to give it a chance. I figured it was bad...

    --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, 2015 at 9:57 pm

    #1832443

Viewing 15 posts - 19,456 through 19,470 (of 59,098 total)