Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: Check constraints validating HTML

    It's literally just simple html. Like if you had this as a survey title:

    <b>Come and get it</b> - we <i>love</i> hamburger helper

    I just need to confirm that tags match...

  • RE: Avoiding Sort task in Execution Plan

    What I meant to say when I said it's not a poorly performing query is that the sql generated is very efficient. The query itself still takes too long to...

  • RE: sp_executesql - LINQ - Performance tuning

    I think I solved this so I'll update this for future posters.

    When disassembling the RPC call and replacing all the parameters in the tsql with real values, I was forced...

  • RE: Is a FK also an index

    Probably a misconception due to the fact that a Primary Key DOES add a unique index by nature.

  • RE: HTML tags showing in report

    I found a solution for this problem. Call this javascript function from the body onload event:

    function HtmlReplace(){

    var divs=document.getElementsByTagName("DIV");

    for(var i=0;i<divs.length;i++){

    ...

  • RE: Trap BCP error from Execute SQL Task

    Thanks Michael. I had just tried the first solution and you're right. No workee. I'll take a look at solution #2 and see if it provides some insight.

    Stay tuned.

    Thanks.

    dn

  • RE: How integrated are execution plans with hardware?

    I took snapshots of the production data every day for two weeks so my development environment was always working on the actual data volume that I was going to be...

  • RE: INSERT/UPDATE/DELETE in data flow?

    Thanks crispin. I overlooked the fact that the OLE DB Command would execute sql. It makes sense though. What else would it be for.

    I hear you about it being...

  • RE: How to fix a non-indexed huge table?

    This could take hours depending on your hardware. It will add a int column, set its identity property to true, make it a primary key, and create a unique clustered...

  • RE: Multiple Log Files

    I found this in BOL.

    "If the log contains multiple physical log files, then the logical log will move through all of the physical log files before it wraps back...

  • RE: SQL 2005 installation

    In fact it is not a good idea at all to install sql server on a domain controller.

  • RE: How to fix a non-indexed huge table?

    You should be able to add a integer column with the Identity property set to true on this table. Setting the identity property will not only generate the artibtrary ID's,...

Viewing 12 posts - 1 through 12 (of 12 total)