Forum Replies Created

Viewing 15 posts - 3,406 through 3,420 (of 7,164 total)

  • RE: AppDomain 12 (mssqlsystemresource.dbo[runtime].11) is marked for unload due to memory pressure.

    32-bit?

    Do you use the Spatial Types in your database code?

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

    August 14, 2012 at 12:35 pm

    #1525733

  • RE: Can you execute a VB.NET .exe from within SQL?

    N11689 (8/14/2012)

    We have a new app that needs to automatically create a pdf and email it.

    We will be writing a new Crystal Report that will call a sql stored procedure...

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

    August 14, 2012 at 12:32 pm

    #1525731

  • RE: Can you execute a VB.NET .exe from within SQL?

    N11689 (8/14/2012)

    From what I have 'googled', I don't think we want to use xp_cmdshell.

    What about SQL CLR? Can you call a vb.net exe (not dll) using an...

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

    August 14, 2012 at 11:43 am

    #1525697

  • RE: How to identify a SQL Agent job by Schedule number

    Schedules are attached to jobs so the best you can do is figure which job or jobs are using that schedule:

    USE msdb;

    SELECT j.name

    FROM dbo.sysschedules s

    ...

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

    August 14, 2012 at 11:33 am

    #1525689

  • RE: create procedure with execute as

    From my perspective you should be looking at turning this process inside-out and using PowerShell to execute whatever you're doing with xp_cmdshell, bcp.exe to load your file and sqlcmd or...

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

    August 14, 2012 at 10:28 am

    #1525644

  • RE: Store proc or trigger

    Know that the number of triggers is not the determining factor for performance. Instead consider the complexity of the trigger and the volume and frequency of transactions against these tables....

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

    August 14, 2012 at 10:17 am

    #1525637

  • RE: Can you execute a VB.NET .exe from within SQL?

    It should be noted that xp_cmdshell is disableb by default in SQL Server (since 2005) and for good reason. Consider carefully before enabling it the security implications. Do you want...

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

    August 14, 2012 at 10:05 am

    #1525625

  • RE: Help designing a patent database

    Another advantage of INT declared as IDENTITY for surrogate keys is the increased potential of keeping fragmentation down over time. Are patent ids ever-increasing in value over time as they...

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

    August 13, 2012 at 3:03 pm

    #1525299

  • RE: Split one row into two rows using CTE??

    martin.david (8/12/2012)

    Peter Brinkhaus (8/12/2012)

    Assuming that the TradeID column is unique (primary key?), why not use a UNION ALL instead of UNION. This avoids a (expensive) distinct sort to filter out...

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

    August 13, 2012 at 2:43 pm

    #1525283

  • RE: Using the Konesans File Watcher Task in SSIS to Process Data Files

    dcdanoland (8/13/2012)

    Thank you so much for your detailed comments. They have been most helpful. I hadn't thought of dividing the task up into file watching and file processing, but that...

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

    August 13, 2012 at 1:09 pm

    #1525243

  • RE: Using the Konesans File Watcher Task in SSIS to Process Data Files

    dcdanoland (8/13/2012)

    Thanks for referencing the discussion on the WMI article. It was most helpful. Your description of the standard batch processing and ETL design matches my experience.

    What sort of load...

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

    August 13, 2012 at 12:01 pm

    #1525207

  • RE: Today's Random Word!

    Ray K (8/13/2012)

    ChrisM@Work (8/13/2012)

    Ray K (8/13/2012)

    meh

    Meths

    Mets

    Suburbanites

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

    August 13, 2012 at 10:31 am

    #1525163

  • RE: Using the Konesans File Watcher Task in SSIS to Process Data Files

    dcdanoland (8/13/2012)

    You make very good points regarding Microsoft testing and the WMI Event Watcher Task. I guess my qualm is that it seems to be an afterthough by Microsoft. All...

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

    August 13, 2012 at 10:15 am

    #1525148

  • RE: Using the Konesans File Watcher Task in SSIS to Process Data Files

    James Stephens (8/13/2012)

    I agree the Konesans may be easier to implement, but I just finished a rebuild of a set of ETL tasks in which I gutted Konesans and went...

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

    August 13, 2012 at 9:43 am

    #1525135

  • RE: Using the Konesans File Watcher Task in SSIS to Process Data Files

    dcdanoland (8/13/2012)

    Thanks for the article. I've been intrigued by this component, but have shied away from it because I have qualms about the architecture. I worry about having an SSIS...

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

    August 13, 2012 at 9:31 am

    #1525126

Viewing 15 posts - 3,406 through 3,420 (of 7,164 total)