Forum Replies Created

Viewing 15 posts - 3,646 through 3,660 (of 7,164 total)

  • RE: Using the WMI Event Watcher Task in SSIS to Process Data Files

    Upsert (7/2/2012)

    kpatrick (7/2/2012)

    Some questions to consider:

    1. What kind of Windows Server security permissions does the identity running the SSIS package need in order to execute the WMI query? ...

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

    July 6, 2012 at 8:00 am

    #1509701

  • RE: PowerShell - Get Permissions

    I didn't feel like learning your code because I provided a solution to get you to a list of directories. Picking up where my code left off you could do...

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

    July 6, 2012 at 7:42 am

    #1509691

  • RE: Peer review request - SQL 2008 Encryption

    I'd be happy to have a look too.

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

    July 5, 2012 at 1:32 pm

    #1509331

  • RE: How to dicrease the ram utilization

    jagadesh.kedar (7/5/2012)

    We have to Change in All the instances..

    Suppose if you have 10 GB Ram,Than assaign 8 to 9 GB RAM for SQL(8-9 GB is combindely for all the instances)...

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

    July 5, 2012 at 5:14 am

    #1509034

  • RE: Db size is not decreasing

    GilaMonster (7/3/2012)

    opc.three (7/3/2012)

    If it's a heap you may need to rebuild the table, not sure how ghost records work with heaps.

    They don't. Ghost records only appear in indexes.

    http://www.sqlskills.com/blogs/paul/post/ghost-cleanup-redux.aspx

    Thanks.

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

    July 4, 2012 at 8:17 am

    #1508789

  • RE: Moving sql users to new domain

    Indianrock (7/4/2012)

    Our Systems guys finally got most if not all of the domain trust issues worked out so now a migrated user can connect even if no new sql login...

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

    July 4, 2012 at 7:42 am

    #1508778

  • RE: How to actually display a Deadlock Graph via Extended Event XML

    This sounds like a bug thathas been fixed. What build of SQL Server are you on?

    Connect Item: Invalid XML in Extended Events xml_deadlock_report output by Jonathan Kehayias

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

    July 3, 2012 at 2:49 pm

    #1508495

  • RE: Db size is not decreasing

    Minto Minto(quendans) (7/2/2012)

    Dear All,

    In our environment Due to one table Db is growing high.Due to this disk space is is high..We have truncated the table.But still disk is showing same...

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

    July 3, 2012 at 2:45 pm

    #1508494

  • RE: Does a user defined function tied to a constraint have visibility to the inserted data?

    Bruce Hendry (7/3/2012)

    Passed into the function as an in memory representation, like a trigger, e.g. select SomeData from inserted? Or passed in explicitly via parameters when calling the function? Thanks.

    It's...

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

    July 3, 2012 at 2:22 pm

    #1508493

  • RE: Database ownership best practices

    Before having the conversation I recommend reading up on the difference between being a dbo (Database Owner) and being a member of the db_owner (a Fixed Database Role). There are...

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

    July 3, 2012 at 2:01 pm

    #1508478

  • RE: Altering char to varchar

    Consider that while CHAR columns would occupy more space if your columns were not mostly full they help us avoid page splits when inserting and updating. If your tables receive...

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

    July 3, 2012 at 12:18 pm

    #1508418

  • RE: insert output to temp table

    Lowell (7/3/2012)

    there's a bit of a work around you can try by using openrowset:, it tends to be a LOT slower, but it works:

    --database name required

    SELECT *

    INTO #tmp

    FROM ...

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

    July 3, 2012 at 12:07 pm

    #1508411

  • RE: Does a user defined function tied to a constraint have visibility to the inserted data?

    Bruce Hendry (7/3/2012)

    If I have a scalar function tied to a constraint, and it selects data from the table, is the inserted data visible or does it have to be...

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

    July 3, 2012 at 11:53 am

    #1508401

  • RE: Moving sql users to new domain

    Indianrock (7/3/2012)

    Well we have more testing to do. So far it seems that as people are migrated their old domain login is automatically disabled. One co-worker who has...

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

    July 3, 2012 at 9:28 am

    #1508292

  • RE: Using the WMI Event Watcher Task in SSIS to Process Data Files

    mleehayes (7/2/2012)

    Well done. Very understandable.

    Thanks

    -Mike Hayes

    Thank you, Mike. I am happy you liked it and appreciate the feedback.

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

    July 2, 2012 at 3:45 pm

    #1507951

Viewing 15 posts - 3,646 through 3,660 (of 7,164 total)