Forum Replies Created

Viewing 15 posts - 4,111 through 4,125 (of 9,399 total)

  • RE: Strange performance of simple query: sometimes fast, sometimes slow

    Well, it seems as though we're always asking for information and you've already gathered quite a bit, so well done there. Kevin's already asked for good stuff. I'd...

  • RE: Having my query use less resources.

    Like Hugo said, being able to recreate what you you have and knowing what question you're trying to answer is key in solving the problem. See the link in...

  • RE: Query Progress

    One of my favorites. Thanks.

  • RE: Today's Random Word!

    djj (1/27/2016)


    Ed Wagner (1/26/2016)


    crookj (1/26/2016)


    BL0B_EATER (1/26/2016)


    Ed Wagner (1/26/2016)


    Grumpy DBA (1/26/2016)


    Ed Wagner (1/26/2016)


    djj (1/26/2016)


    BL0B_EATER (1/26/2016)


    Ed Wagner (1/25/2016)


    Revenant (1/25/2016)


    bcsims 90437 (1/25/2016)


    Ed Wagner (1/25/2016)


    Luis Cazares (1/25/2016)


    SQLRNNR (1/25/2016)


    Sciuto

    prosciutto

    Pancetta

    BACON!!!!!!

    Kevin 😉

    Footloose

    musical

    Stage

    Theater

    Drive-in

    Movie

    Boring

    Debates

    Misdirection

    Magic

    Disney

  • RE: Disk space

    I love Igor's idea of distributing tempdb to different drives as a short-term solution. You really need to free up space on C: and this will help you do...

  • RE: Is there any risk involving in granting showplan permission to a dev group in devleopment UAT databases?

    SQL-DBA-01 (1/26/2016)


    Hi

    I got the below note in the associated Microsoft URL.

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

    Users who have the SHOWPLAN, the ALTER TRACE, or the VIEW SERVER STATE permission can view queries that are...

  • RE: Bulk Insert a file from FTP to SQL Server

    Excellent. I'm glad to hear you have it working

    It's absolutely possible to delete your script.ftp file once you're done with it. In fact, you can do it before...

  • RE: Today's Random Word!

    crookj (1/26/2016)


    BL0B_EATER (1/26/2016)


    Ed Wagner (1/26/2016)


    Grumpy DBA (1/26/2016)


    Ed Wagner (1/26/2016)


    djj (1/26/2016)


    BL0B_EATER (1/26/2016)


    Ed Wagner (1/25/2016)


    Revenant (1/25/2016)


    bcsims 90437 (1/25/2016)


    Ed Wagner (1/25/2016)


    Luis Cazares (1/25/2016)


    SQLRNNR (1/25/2016)


    Sciuto

    prosciutto

    Pancetta

    BACON!!!!!!

    Kevin 😉

    Footloose

    musical

    Stage

    Theater

    Drive-in

    Movie

    Boring

    Debates

    Misdirection

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/26/2016)


    rodjkidd (1/26/2016)


    In other news,

    Just ran one of Jason scripts!

    So everyone back away from their keyboards for a minute....

    🙂

    Nah, it worked as expected...

    All good here!

    Rodders...

    So all databases were dropped and...

  • RE: The security scheme

    Iulian -207023 (1/26/2016)


    ...

    Tim Ford's Periodic Table of DMVs might help get you going. http://thesqlagentman.com/periodic-table/

    That is excelent, one picture wors 1000 words :-). thanks a lot.

    Iulian

    No problem. Have...

  • RE: The security scheme

    Iulian -207023 (1/26/2016)


    Ed Wagner (1/26/2016)


    Iulian -207023 (1/26/2016)


    I am looking at the sys.dm_exec_connections & sys.dm_exec_sessions on my local machine but I do not see the sessions & connections from...

  • RE: Today's Random Word!

    Grumpy DBA (1/26/2016)


    Ed Wagner (1/26/2016)


    djj (1/26/2016)


    BL0B_EATER (1/26/2016)


    Ed Wagner (1/25/2016)


    Revenant (1/25/2016)


    bcsims 90437 (1/25/2016)


    Ed Wagner (1/25/2016)


    Luis Cazares (1/25/2016)


    SQLRNNR (1/25/2016)


    Sciuto

    prosciutto

    Pancetta

    BACON!!!!!!

    Kevin 😉

    Footloose

    musical

    Stage

    Theater

    Drive-in

    Movie

  • RE: Today's Random Word!

    djj (1/26/2016)


    BL0B_EATER (1/26/2016)


    Ed Wagner (1/25/2016)


    Revenant (1/25/2016)


    bcsims 90437 (1/25/2016)


    Ed Wagner (1/25/2016)


    Luis Cazares (1/25/2016)


    SQLRNNR (1/25/2016)


    Sciuto

    prosciutto

    Pancetta

    BACON!!!!!!

    Kevin 😉

    Footloose

    musical

    Stage

    Theater

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/26/2016)


    TomThomson (1/25/2016)


    GilaMonster (1/25/2016)


    Bandwidth, latency and data out of the country (for 1 and 3)

    I see the same. Plus in the EU it's probably illegal to host the...

  • RE: Can't send dbmail with attachment as SQL Agent Job

    genuiforex (1/25/2016)


    Thank you Ed, your solution works. BTW, i have added the sqlserveragent with role proc_executor membership and everything went well.

    I'm glad you got it working. Thanks for the...

Viewing 15 posts - 4,111 through 4,125 (of 9,399 total)