Forum Replies Created

Viewing 15 posts - 5,191 through 5,205 (of 7,164 total)

  • RE: Same statements, different plans?

    I won't go into why it took this long to get a few UPDATE STATISTICS statements run in production, but the results are finally in.

    I removed the parameter switching and...

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

    August 19, 2011 at 7:01 pm

    #1371003

  • RE: Xref table with missing elements

    Sorry...you lost me at "Jab" 😛

    Seriously though, simple to understand sometimes must weigh more heavily than certain technical considerations and it sounds like you got to a place where the...

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

    August 19, 2011 at 5:40 pm

    #1370999

  • RE: DB Role checked but not saved on create new login

    kvanderkley (8/18/2011)

    On SQL 2005 standard...

    This may be an SSMS issue, not a server issue. As suggested, check the script SSMS is producing to see if it is producing what you...

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

    August 19, 2011 at 10:39 am

    #1370896

  • RE: How to import multiple CSV files.

    dji (8/18/2011)

    Jeff Moden (8/18/2011)

    dji (8/18/2011)

    Apologies, Jeff!

    I was most definitely referring to my solution of trying to squeeze the out dated OPENROWSET into the 64 bit environment when mentioning band-aid 🙂

    Understood...

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

    August 18, 2011 at 11:29 pm

    #1370542

  • RE: Using Identity Field as my main relation in joins

    Jeff Moden (8/18/2011)

    Heh... I didn't scroll down before I replied. Maybe there won't be so many people raising hell with me after all. 😀

    I went there too...and later decided...

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

    August 18, 2011 at 11:24 pm

    #1370539

  • RE: Using output parameters with OLE DB Source in Data Flow Task - SSIS 2008

    Evil Kraig F (8/18/2011)

    opc.three (6/7/2011)

    This thread basically explains what I was thinking you would have to do but I would call it a workaround if anything...not really an elegant solution...

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

    August 18, 2011 at 11:21 pm

    #1370537

  • RE: BACKUP to share over UNC path is very slow

    Alex Webber (8/18/2011)

    How could user permissions have anything to do with it? Surely you either have the right permissions or you don't?

    Agreed. I don't see how permissions could play into...

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

    August 18, 2011 at 2:04 pm

    #1370382

  • RE: Getting Session History in SQL Server

    Sujeet Pratap Singh (8/18/2011)

    Thanks opc.three,

    I will surely explore & try server side trace for this kind of work. I think Oracle reports cannot be said a waste of resources, because...

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

    August 18, 2011 at 1:48 pm

    #1370361

  • RE: BACKUP to share over UNC path is very slow

    Alex Webber (8/18/2011)

    True. What I just don't get is that it's gone from 1 hour when backing up to 1 machine over the network to 15 hours when backing up...

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

    August 18, 2011 at 9:54 am

    #1370225

  • RE: Using Identity Field as my main relation in joins

    nm

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

    August 18, 2011 at 9:43 am

    #1370219

  • RE: SQLSERVR.exe *32 Peak Mem Usage > 3GB (!?)

    Don't refer to Task Manager for memory usage...it lies, especially for 32-bit processes where the machine has more than 4GB of RAM.

    Use Performance Monitor or the SQL Server DMOs.

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

    August 18, 2011 at 9:27 am

    #1370204

  • RE: Getting Session History in SQL Server

    Sujeet Pratap Singh (8/14/2011)

    Thanks for providing the useful links although they dont provide the exact thing.

    The short answer is, you have to implement this yourself in SQL Server. I second...

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

    August 18, 2011 at 9:22 am

    #1370199

  • RE: BACKUP to share over UNC path is very slow

    Alex Webber (8/17/2011)

    Thanks for the reply. This is actually backing up to box in the same data centre which we then copy offsite afterwards.

    Also, like I said before, I can...

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

    August 17, 2011 at 5:28 pm

    #1369897

  • RE: Stopping multi row updates

    terryshamir (8/17/2011)

    Hi I'm porting an Access DB to SQL Server 2008.

    Unfortunately there is an excel spreadsheet that gets sent to customers who fill it in, when we get it back...

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

    August 17, 2011 at 3:31 pm

    #1369882

  • RE: Collation-based issues specifically when using Invoke-SqlCmd

    What character encoding is used in the file? If the file is UCS-2 (i.e. "Unicode" in Windows-speak) the character may be the Unicode version (UCS-2 0x20A4) and not the Windows-1252...

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

    August 17, 2011 at 2:46 pm

    #1369862

Viewing 15 posts - 5,191 through 5,205 (of 7,164 total)