Forum Replies Created

Viewing 15 posts - 211 through 225 (of 3,666 total)

  • RE: Welcome SQL Agent job experts

    caojunhe24 (11/10/2015)

    Hi all experts,

    I'm trying to schedule a job using SQL JOB AGENT

    The logic- the SSIS package should run on every

    Monday :12pm-10pm..(should run every 30 mins)

    Tuesday 8am-9pm..(should run every...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    November 10, 2015 at 2:13 pm

    #1838980

  • RE: Blanking Out On How Joins Work

    jarid.lawson (11/10/2015)

    I'm better than this! I KNOW I'm better than this. Just the same I am hitting a brick wall, and I could use an extra set of eyes to...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    November 10, 2015 at 1:03 pm

    #1838949

  • RE: Are the posted questions getting worse?

    I received notifications.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    November 10, 2015 at 12:38 pm

    #1838944

  • RE: Daily newsletter

    simon.whale (11/10/2015)

    Yes, someone I work with still gets the daily news letters through our work email system, hence why I thought I'd try here.

    You did the right thing.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    November 10, 2015 at 8:23 am

    #1838869

  • RE: Daily newsletter

    Did you read the message at the top of the home page?


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    November 10, 2015 at 8:15 am

    #1838862

  • RE: DTExec.exe using up all server memory and driving SQL Server memory to 300mb

    Been there seen that, but don't know of any way to avoid the high memory usage.

    FYI, limiting SQL Server to no more than X MB will not help in any...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 22, 2015 at 1:13 pm

    #1835010

  • RE: Group by doesnt work

    Lowell (10/22/2015)

    DDL, sample data and expected results then?

    Lowell, you reminded me of one of the most honest sign I saw a homeless person holding.

    It said: "NEED BEER!"

    😀


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 22, 2015 at 1:00 pm

    #1835008

  • RE: Do You Have to Run an SSIS Package with Original Package Author Account?

    Reread ...

    [p]

    ...The current user cannot decrypt secrets from the package. This scenario can occur if the current account or the execution account differs from the original package author, and...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 22, 2015 at 12:47 pm

    #1835002

  • RE: Delete Orphanes users from multiple databases- Challeging to change teh authorization to DBO

    For changing ownership, take a look at:

    https://msdn.microsoft.com/en-us/library/ms173423.aspx


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 21, 2015 at 2:29 pm

    #1834773

  • RE: How to add a primary key for existing column in the table

    Lynn Pettis (10/21/2015)

    Determine if ColumnA has duplicate values:

    select

    ColumnA,

    count(*)

    from

    dbo.MyTable

    group by

    ColumnA

    having

    count(*) >...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 21, 2015 at 9:54 am

    #1834715

  • RE: Are the posted questions getting worse?

    GilaMonster (10/21/2015)

    Grant Fritchey (10/21/2015)

    GilaMonster (10/21/2015)

    Grant Fritchey (10/21/2015)

    GilaMonster (10/20/2015)

    I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.

    There are sessions that we...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 21, 2015 at 8:05 am

    #1834680

  • RE: Are the posted questions getting worse?

    Grant Fritchey (10/21/2015)

    GilaMonster (10/21/2015)

    Grant Fritchey (10/21/2015)

    GilaMonster (10/20/2015)

    I'll probably do my usual, look at the schedule over breakfast and decide then what I want to see.

    There are sessions that we get...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 21, 2015 at 7:41 am

    #1834664

  • RE: Problem attaching database to re-install of SQLExpress 2014

    Blame Windows.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 20, 2015 at 12:19 pm

    #1834457

  • RE: Can't CAST as INT and back again

    Jeff Moden (10/20/2015)

    Alvin Ramard (10/20/2015)

    Lynn Pettis (10/20/2015)

    Alvin Ramard (10/20/2015)

    Or:

    set @testTime = '23:45';

    SELECT @testTime = cast(dateadd(minute, 15, cast(@testTime as time) ) as char(5));

    SELECT @testTime;

    Remember, the OP is working with SQL...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 20, 2015 at 12:08 pm

    #1834451

  • RE: Can't CAST as INT and back again

    Jeff Moden (10/20/2015)

    This problem deserves "KISS". 😀

    --===== Setup the test. This is NOT a part of the solution.

    DECLARE @testTime CHAR(5);

    SELECT @testTime = '23:45';

    --===== Exploit the simplicity of implicit conversions...


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    October 20, 2015 at 12:05 pm

    #1834449

Viewing 15 posts - 211 through 225 (of 3,666 total)