Forum Replies Created

Viewing 15 posts - 43,201 through 43,215 (of 49,552 total)

  • RE: Database Mirroring operation-- feasiblity and risk involved

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic600933-146-1.aspx

    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

    November 11, 2008 at 2:37 pm

    #897174

  • RE: Database Mirroring Transport is disabled when setting up Database Mirroring

    That's not SP2. 9.00.1399 is SQL 2005 RTM. The build number for SP2 is 3042.

    Get SP2 and patch that server.

    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

    November 11, 2008 at 2:14 pm

    #897164

  • RE: Default trace - A Beginner's Guide

    Mohit (11/11/2008)

    But what I wanted to know was Adam is there a way to add events to Default Trace? Also how can I make it so it saves more...

    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

    November 11, 2008 at 2:10 pm

    #897161

  • RE: limitting the value

    You can use a case statement

    SELECT CASE WHEN Value > 100 THEN 100 ELSE Value END FROm SomeTable

    Can you post the query? Maybe someone can see something wrong with 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

    November 11, 2008 at 2:05 pm

    #897157

  • RE: Database Mirroring Transport is disabled when setting up Database Mirroring

    anvieph (11/11/2008)

    Hi I tried this:

    -dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T1400

    Upgrade your SQL 2005 instance to Service pack 1 at least (preferably SP2 with CU 6 or...

    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

    November 11, 2008 at 2:03 pm

    #897155

  • RE: Replication who was deleted

    What does the entire of the event log entry read?

    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

    November 11, 2008 at 1:13 pm

    #897133

  • RE: DBA Value

    blandry (11/11/2008)

    A DBA who does not know VS? That's a DBA? I oversee staff for four companies (part of our corporate org) and I have never hired any...

    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

    November 11, 2008 at 10:29 am

    #897064

  • RE: Restoredatabse problem

    What exactly are you trying to do here?

    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

    November 11, 2008 at 9:59 am

    #897039

  • RE: sql backup

    Gaby A. (11/11/2008)

    Easier to backup up full every day, and restore that full and all trans logs since then.

    Depends what kind of maintenance window you have nightly. Last big DB...

    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

    November 11, 2008 at 9:59 am

    #897038

  • RE: Create Non Culstered index

    shree (11/11/2008)

    Users are having performance problems recently.

    I have planned it do at off hours .

    it makes any problem while creating it because table has

    Many forien key relations.

    No problems. Number...

    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

    November 11, 2008 at 9:47 am

    #897033

  • RE: Log Shipping : the tran. log of both the Pri. & Second. servers are large

    marianne.schillings (11/11/2008)

    Hello,

    I have been reading this blog, and I am fearly new to SQL server DB. I am interested to know: SQL DB is on line and can you do...

    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

    November 11, 2008 at 9:46 am

    #897031

  • RE: Database Shrink

    A shrink will never lose data. Why do you want to shrink your database?

    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

    November 11, 2008 at 9:45 am

    #897029

  • RE: Stored Procedure speed versus Select Statement

    Sue (11/11/2008)

    thanks for your hint, Jeff.

    but isn't this better than to give users permissions on tables and generate the whole select statement dynamically as mentioned before?

    But that's pretty 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

    November 11, 2008 at 9:39 am

    #897027

  • RE: execution plan not using correct index

    tvantonder (11/11/2008)

    So I now came to the conclusion that the SQL engin is not that smart and will not create the best execution plan.

    The optimiser is quite smart...

    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

    November 11, 2008 at 9:33 am

    #897020

  • RE: Stored Procedure speed versus Select Statement

    Patrick Russell (11/11/2008)

    It seems that the dynamicSQL is the way to go, the question is how little. What would be the best way to validate the incoming values to make...

    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

    November 11, 2008 at 9:21 am

    #897012

Viewing 15 posts - 43,201 through 43,215 (of 49,552 total)