Forum Replies Created

Viewing 15 posts - 991 through 1,005 (of 7,164 total)

  • RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

    Jeff Moden (6/11/2013)


    For example, sp_MakeWebTask was very well documented and supported and it went away virtually overnight because Microsoft thought everyone would go ga-ga over SSRS :sick:

    sp_MakeWebTask was likely dropped...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

    Jeff Moden (6/11/2013)


    opc.three (6/11/2013)


    Thank you for bringing the conversation back to the original intent. Maybe you doing it will make it stick.

    Great idea but YOU are not the one to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

    Tom_Sacramento (6/11/2013)


    Not to oversimplify, but once the newest file is identified one option is to use script to copy it to a predetermined name like workfile.csv. Then when done, dispose...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Today's Random Word!

    jasona.work (6/11/2013)


    pchirags (6/8/2013)


    SQLRNNR (6/7/2013)


    The Dixie Flatline (6/7/2013)


    L' Eomot InversΓ© (6/7/2013)


    pchirags (6/7/2013)


    bharat

    mata

    hari

    hair

    Jai..

    Alai

    Dania

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Date and Time when Table last queried

    A table with no clustered index is a heap. A heap can have non-clustered indexes on it and it remains a heap. Just clarifying.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: PAGELATCH_UP Won't Let Go!

    calvo (6/10/2013)


    This is on 2008 R2 SP2. I know there's a KB addressing a similar bug for 2008.

    What's you're exact build #?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Benefits in using a unique login for each user.

    Some benefits:

    Auditing - if everyone logs in as themselves then you know who is doing what. If you want capture who changed a row you can use built in T-SQL...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Resource Governor in SQL Server 2008

    Since you're just starting out, SQL Server Books Online would be a great place for you to start. Post back with more specific questions after you have acquainted yourself with...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Sql Serer Data Protection Tool

    poratips (6/9/2013)


    Hi,

    We are looking any Data Security tool for out existing Data for Protection, we would like to do the Data Encryption and Data masking with some user activity reporting.

    Anyone...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

    Jeff Moden (6/10/2013)


    opc.three (6/10/2013)


    Eh, and really, who needs it? πŸ˜€

    Everyone who wants to avoid increasing the surface area by firing up SSIS. πŸ˜‰

    You mentioning Surface Area...laughable πŸ˜›

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

    Eh, and really, who needs it? πŸ˜€

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

    If anyone is interested in taking the detour named "xp_cmdshell" (I am not) please see these posts below where Jeff, and sometimes myself too, espouse the merits and demerits of...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: SSAS - how to view cubes

    Don't forget Visual Studio, the Cube design tool.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS)

    Jeff Moden (6/9/2013)


    opc.three (6/9/2013)


    Note that xp_dirtree is an undocumented stored procedure.

    I absolutely agree. It would be much better to use something that's not only well documented, but tried and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Proactive caching scheduled notification not working

    The old school way uses polling. The .net framework will check a table to see if it has changed data since the last time it was polled. If it has...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 991 through 1,005 (of 7,164 total)