Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 5,685 total)

  • RE: Stored Procedure Insert Locking Until End of Processing

    What exact version and service pack are you using? That shouldn't happen and I want to see if I can recreate your event.

    September 25, 2012 at 10:33 pm

    #1542202

  • RE: Preventing from "create database" with data and log file on C: drive.

    Siva Ramasamy (9/25/2012)

    But when users create databases on the instance, they create it on the C: drive, which is causing the C: drive to run out of space.

    Any idea how...

    September 25, 2012 at 6:06 pm

    #1542161

  • RE: SSIS Loop /script

    This could end up complex. Can you link here to your previous posts so I can try to get an idea of what else you've built so far so...

    September 25, 2012 at 6:03 pm

    #1542160

  • RE: SSIS Package executes successfully in dev/test environment but fails in production

    Ask them to stick the package in a job, setup a step log for the SSIS package, run the package (and fail) and ship you the file.

    There's a ton more...

    September 25, 2012 at 5:56 pm

    #1542158

  • RE: Self referring join condition (tblx.col1 = tblx.col1) alters perf. - WHY?

    Jason Selburg (9/10/2012)

    Can someone explain WHY adding the self referring join condition on acct.BillingType decreases the Estimated number of rows by a factor of 10?

    Offhand... no. The predicate...

    September 25, 2012 at 5:52 pm

    #1542157

  • RE: Sanitizing the data

    SQLCrazyCertified (9/25/2012)

    What about when you refresh the production data to dev server, during that process I know there is data sanitation involved but in out environment, it is done by...

    September 25, 2012 at 5:42 pm

    #1542156

  • RE: Need a Memory Utilization alert SQL Server 2008 r2

    I recommend using Page Faults (not a SQL Server specific indicator) to indicate when the memory is falling to the page/swap file as your indicator. There's usually a little...

    September 25, 2012 at 5:27 pm

    #1542150

  • RE: Sanitizing the data

    Data sanitization is removal of garbage data inbound to the system. It covers a number of smaller minor topics but basically it's a pre-check of the data prior to...

    September 25, 2012 at 5:23 pm

    #1542147

  • RE: asynchronous_file_target access denied error

    jberg-604007 (9/25/2012)

    I am working thru the extended events and I am trying to set the output to a file using asynchronous_file_target. I am getting an access denied error from...

    September 25, 2012 at 5:21 pm

    #1542145

  • RE: Need help auditing

    Old problem, no real new solutions. You're looking at a real mess.

    For some further ideas, it may just be you need some helpful keywords for your google research, you've...

    September 25, 2012 at 5:19 pm

    #1542144

  • RE: rebuilding indexes

    Lexa (9/25/2012)

    2. Does REORGANIZE on a table causes any locks?

    Can't answer #1, not sure.

    Reorganize will take a SCH-S lock to keep the metadata straight. It will also take S...

    September 25, 2012 at 5:14 pm

    #1542143

  • RE: MCITP Certification

    SQLTC (9/25/2012)

    Right courses. Once I complete my courses and i pass the school exams then my voucher to take the MS Exams will be granted.

    Thanks though you have been...

    September 25, 2012 at 5:09 pm

    #1542142

  • RE: Alternative for checkpoint

    On another note, what are you doing in SSIS that you need SSIS in particular for? If you want to keep this completely database driven, BCP and other tools...

    September 25, 2012 at 4:28 pm

    #1542134

  • RE: Alternative for checkpoint

    Sam.... (9/25/2012)

    Initially i thought i can use script task to modify the Disable property of SSIS task?? IS this possible and how?

    You can't enable a task during runtime except via...

    September 25, 2012 at 4:27 pm

    #1542133

  • RE: need answer

    harri.reddy (9/25/2012)

    hi

    i need to know ,what will you do for disaster recovery for your database.

    i need any article and anything you have .

    thanks

    :blink:

    You're not talking articles here, you're talking books...

    September 25, 2012 at 4:14 pm

    #1542129

Viewing 15 posts - 1,126 through 1,140 (of 5,685 total)