Forum Replies Created

Viewing 15 posts - 1 through 15 (of 184 total)

  • Reply To: Save Data Factory Without Publishing?

    Thanks for the info. I will look into that.

    Thanks,

    Chris

  • Reply To: Use Database name

    "Use DBName" is an excellent practice and will serve you well.

    This, for instance, will fail at the Use statement if the DB doesn't exist and nothing else will execute.

    Use MYDB

    Create...

  • RE: Query to see value matching values from two columns

    I will try this when I get back from vacation.

    Thanks,
    Chris

  • RE: Queries Hung on Memory Request

    Code change was:
        Delete A
         From ACSLog.dbo.AuditLog A With (Rowlock)
         Inner Join ACSLog_Archive.dbo.AuditLog B On A.AuditLogID = B.AuditLogID OPTION (MAXDOP 1)

    To:

  • RE: Queries Hung on Memory Request

    This VM has 6 CPUs. I have at least two data files for TempDB on all servers. This server has 4 data files, of 3.2G, 3G, 36.8G, and 10G.

  • RE: Queries Hung on Memory Request

    Well, learned something new. It is working and working very fast. 1000 records in 3 seconds or less, and 50,000 in, well, it started at 106 seconds vs. the previous...

  • RE: Queries Hung on Memory Request

    If you look at the code I posted I was doing the delete with a join.
           Delete A
            From ACSLog.dbo.AuditLog A With (Rowlock)
            Inner Join ACSLog_Archive.dbo.AuditLog B...

  • RE: Queries Hung on Memory Request

    Yes, sort of. The archive DB only has 90 days worth of history in it. Each quarter we back up the DB and store it offline in case it is...

  • RE: Queries Hung on Memory Request

    Code:
    Set NOCOUNT ON
    declare @enddate datetime, @NumRecordsToGet int, @FirstDayOfQuarter datetime
    Declare @NumRecords Int, @NumAffected Int
    Declare @Err Int, @ErrMsg VarChar(255), @Body1 VarChar(500), @Email VarChar(2000)

    select @enddate...

  • RE: Queries Hung on Memory Request

    Adding the estimated query plans for two options, 1. Current design, with a join on delete, and 2. with mod to use Delete where not in(select from....
    FYI, while I...

  • RE: Queries Hung on Memory Request

    Thanks for the reply. I cannot get the archival query to execute at this time because it can never get a memory grant from SQL Server, so I cannot check...

  • RE: Queries Hung on Memory Request

    1. The server is Enterprise Edition. I would love to give the server more RAM, but people other than the DBA's dictate how much RAM the servers get and we...

  • RE: SQL 2008 Package jobs suddenly failing

    A reboot overnight seems to have cured the problem.

    Chris

  • RE: BIDS 2005 Retro Install

    Have you tried installing SQL 2005 on your box? I have 2005, 2008, and 2012 version of SQL Server and BIDS installed on mine. I know I installed 2005 after...

  • RE: tempdb log 75GB

    If you have to limit TempDB due to space constraints, you gotta do what you gotta do. This will result in failures on the app side if it cannot use...

Viewing 15 posts - 1 through 15 (of 184 total)