Forum Replies Created

Viewing 15 posts - 5,086 through 5,100 (of 7,164 total)

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Evil Kraig F (10/5/2011)

    opc.three (10/5/2011)

    Evil Kraig F (10/5/2011)

    opc.three (10/5/2011)

    PS I cannot wait to see the examples of when one would HAVE to use it.

    SQL Express with an on-demand file bulk...

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

    October 5, 2011 at 4:38 pm

    #1391003

  • RE: Permissions needed for SSIS to read metadata

    Cool, happy you got it sorted!

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

    October 5, 2011 at 4:09 pm

    #1390998

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    Evil Kraig F (10/5/2011)

    opc.three (10/5/2011)

    PS I cannot wait to see the examples of when one would HAVE to use it.

    SQL Express with an on-demand file bulk load and archiving.

    My guess...

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

    October 5, 2011 at 4:08 pm

    #1390997

  • RE: I cringe every time I see a recommendation for xp_cmdshell.

    I would consider myself a crusader against enabling and using xp_cmdshell. I have posted many times on these forums advising against the use of it. All too often it is...

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

    October 5, 2011 at 3:58 pm

    #1390994

  • RE: Alternative to sp_spaceused

    george sibbald (10/4/2011)

    declare @dbname sysname

    set @dbname = db_name()

    print @dbname

    select backup_start_date,backup_finish_date,backup_size/1024 as 'size in MB'

    from msdb..backupset

    where database_name = @dbname and type = 'D'

    I have just one tweak. backup_size is...

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

    October 5, 2011 at 11:25 am

    #1390852

  • RE: Migration

    SSIS may be the fastest performer but if you're not versed in it you can use bcp. It is quite fast when using Native format between two SQL Servers. You...

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

    October 5, 2011 at 11:08 am

    #1390842

  • RE: SQL service domain account as local admin group member ?

    awu (10/4/2011)

    Put service account as local admin group will save lots of permission issue , so. wondering besides security concern, what else is really the big problem...

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

    October 5, 2011 at 10:44 am

    #1390820

  • RE: Permissions needed for SSIS to read metadata

    peterjonk (10/3/2011)

    Thanks for your reply. Yes this could be a metadata sync problem, but I already tried refreshing the SSIS metadata.

    The problem occurs in the validation phase of the data...

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

    October 4, 2011 at 7:14 am

    #1390114

  • RE: Powershell output into SSIS variables

    Nice work. Thanks for sharing that.

    This may save you a bit of time down the line. You can add hooks to the PowerShell runtime directly into your SSIS environment enabling...

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

    October 3, 2011 at 5:18 pm

    #1389904

  • RE: HOW TO - Resolve 'An INSERT EXEC statement cannot be nested' Error/Problem

    If you look at the code for sys.sp_helpsubscription you'll notice it calls two procs, sys.sp_MSrepl_getpublisherinfo and sys.sp_MSrepl_helpsubscription. Chances are the proc sys.sp_MSrepl_getpublisherinfo does not make use of INSERT EXEC...

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

    September 30, 2011 at 10:48 am

    #1388935

  • RE: Permissions needed for SSIS to read metadata

    I am not sure why you are not having the issue when you run as a login/user in the db_owner role. Regardless, if you are getting by with a db_owner...

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

    September 29, 2011 at 9:01 am

    #1388433

  • RE: REBUILD for heaps

    You are superb Gail, thank you for your help here 🙂

    GilaMonster (9/27/2011)

    Updates to a heap cause forwarding pointers, which is far more a problem than extent fragmentation and would probably...

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

    September 27, 2011 at 3:15 pm

    #1387468

  • RE: REBUILD for heaps

    GilaMonster (9/27/2011)

    opc.three (9/27/2011)

    In a write-heavy system with lots of updates to variable-length columns (inner-table page splits) and queries producing table scans heap fragmentation can play a bigger role in performance...

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

    September 27, 2011 at 2:12 pm

    #1387442

  • RE: REBUILD for heaps

    GilaMonster (9/27/2011)

    opc.three (9/27/2011)

    GilaMonster (9/27/2011)

    Both.

    From my experience with this client, and admittedly it is my first major dealing with heaps, I see that a high percentage affects performance adversely.

    It probably...

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

    September 27, 2011 at 12:11 pm

    #1387398

  • RE: REBUILD for heaps

    GilaMonster (9/27/2011)

    Both.

    From my experience with this client, and admittedly it is my first major dealing with heaps, I see that a high percentage affects performance adversely. As to how high...

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

    September 27, 2011 at 11:36 am

    #1387378

Viewing 15 posts - 5,086 through 5,100 (of 7,164 total)