Forum Replies Created

Viewing 15 posts - 22,621 through 22,635 (of 49,552 total)

  • RE: Standard Edition on mirroring high-performance mode?

    ananda.murugesan (10/31/2011)

    Does this edition can be possible to configure in asynchronous, high-performance mode?

    No. Standard edition is synchronous only

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 31, 2011 at 2:23 am

    #1400954

  • RE: first attempt at automated backup plan

    SQLAgent running?

    Hourly full backups? That's a little unusual...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 31, 2011 at 2:10 am

    #1400953

  • RE: user mappings getting messed up when I restore a database to integration server

    Expected behaviour because when you created the login on the other server you used the same name but did not specify the SID. Hence the SID is different between the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 31, 2011 at 2:09 am

    #1400952

  • RE: Trigger Help

    If the hostname is showing the server name, then the SQL connection is being initiated from the server and, as far as SQL is concerned, where the connection starts is...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 31, 2011 at 2:05 am

    #1400950

  • RE: Index Rebuild - Job running over 16 hours.....

    David Moutray (10/28/2011)

    Dropping an index and then recreating it will also bypass the transaction log, however.

    Nope and creating a clustered index is fully logged in full recovery. Everything...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 5:44 pm

    #1400913

  • RE: Server out of memory

    mpdillon (10/30/2011)

    Good to hear that it is a .Net error. I thought it might have something to do with the result set being displayed. I was not on a workstation,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 5:37 pm

    #1400912

  • RE: Per Call Performance Monitoring

    Extended events?

    But similar to profiler it's more something you'd have running for a period and analyse in general rather than doing that online.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 3:23 pm

    #1400897

  • RE: Time Elapsed Testing

    bdotjones (10/27/2011)

    Is there a way to hook into the event when getdate() is called and then modify the value from the system clock and pass back the new value?

    Without rewriting...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 12:54 pm

    #1400887

  • RE: Index scan vs. seek

    Jeff Moden (10/30/2011)

    I'm actually a bit surprised you'd ever get a seek on that index for the original query you posted...

    select f1 from t1 where f2 = @val

    I suspect that...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 12:51 pm

    #1400885

  • RE: Server out of memory

    mpdillon (10/30/2011)

    When I try to return all the record a table of 200,000,000 records, I receive and error message:

    "An error occurred while executing batch. Error message is: Exception of type...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 12:48 pm

    #1400884

  • RE: SSMS Query behavior question

    mpdillon (10/30/2011)

    The results appeared on the Execution plan tab. But they exented beyond the visible window and there were not any scroll bars. Nor could I find a way to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 12:00 pm

    #1400878

  • RE: SSMS Query behavior question

    mpdillon (10/30/2011)

    This was obtained by Right clicking on the table name and sending the "Create To" output to a file. There isn't any indexing statements in this Create To output....

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 8:47 am

    #1400865

  • RE: how to validate the data Length of image field ?

    SELECT DataLength(ImageColumn) FROM TheTable

    But the max length of an image column is 2GB, as is the max size of a variable of type image, so there's probably not that much...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 2:54 am

    #1400856

  • RE: Failover Cluster & Domain Controller

    larrykl (10/29/2011)

    Thanks for the reply. Yes, IIS won't be clustered, there will be two instances, one on each machine. I'm aware that it is not recommended to run...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 30, 2011 at 2:51 am

    #1400854

  • RE: Failover Cluster & Domain Controller

    They should still all be up.

    p.s IIS and SQL on the same server is generally recommended against, and afaik, IIS can't be clustered (it can be load-balanced)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 29, 2011 at 4:59 pm

    #1400847

Viewing 15 posts - 22,621 through 22,635 (of 49,552 total)