Forum Replies Created

Viewing 15 posts - 19,426 through 19,440 (of 59,072 total)

  • RE: Automating backup/restore for a non DBA-user

    chrisph (10/14/2015)

    Jeff I don't like the idea because of security and other implications of permissions but am exploring all options.

    Understood but why is it necessary for the user to do...

    --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 14, 2015 at 3:56 pm

    #1833339

  • RE: Automating backup/restore for a non DBA-user

    chrisph (10/14/2015)

    Guys, is there an automatic method a user could employ to specify which database they want backed up/restored from a one instance to another? Thinking something like 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 14, 2015 at 3:06 pm

    #1833336

  • RE: Understanding the OVER clause

    My turn to "stalk", ol' friend. 😀 Very well done!

    --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 14, 2015 at 2:43 pm

    #1833332

  • RE: Fusion-IO or Nimble?

    Nothing yet on that, Michael. We've had the new boxes setup for many months and were supposed to migrate all our systems to the new boxes. Then, as...

    --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 6:40 pm

    #1833109

  • 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

Viewing 15 posts - 19,426 through 19,440 (of 59,072 total)