Forum Replies Created

Viewing 15 posts - 36,661 through 36,675 (of 49,552 total)

  • RE: Slow performance

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    September 1, 2009 at 6:33 am

    #1047462

  • RE: You Shouldn't Have Done That

    Mike Stuart (9/1/2009)

    Back to the original statement of "... you shouldn't have installed all that for an evaluation edition" - why not? Isn't that why we have evaluation editions:...

    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

    September 1, 2009 at 6:29 am

    #1047457

  • RE: Incomplete backup failure info in log file viewer

    Not that I'm aware of.

    If you're just interested in which were backed up and which were not, query the backup history tables in MSDB. There's a few of them, backupset...

    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

    September 1, 2009 at 6:25 am

    #1047452

  • RE: Incomplete backup failure info in log file viewer

    Go to the job step, the advanced options. There's an option there to log to a file. Use that, it'll log the full error message.

    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

    September 1, 2009 at 2:31 am

    #1047351

  • RE: NUMA Node

    All it's saying is that the server uses a NUMA architecture (non-uniform memory access) and it's showing you how the NUMA nodes are configured. When the server uses the NUMA...

    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

    September 1, 2009 at 2:30 am

    #1047350

  • RE: Transfer data from Sql2005 to sql2000

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic780445-148-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

    September 1, 2009 at 2:27 am

    #1047349

  • RE: Can we convert SQL Server 2005 SP to Dotnet Assembly.?

    Tell your manager he's an idiot.

    Yes, it's possible, it is however in no way a good idea. CLR is an alternative to T-SQL for procedures, not a replacement. It's good...

    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

    September 1, 2009 at 2:25 am

    #1047347

  • RE: How to return ONE child row for each Parent row?

    Sorry, I left a column and the join condition out. They should be joined on ParentID as that's the foreign key between the tables.

    This should work better

    SELECT Parent.LastName, Parent.FirstName, FirstChild.LastName,...

    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

    September 1, 2009 at 2:20 am

    #1047345

  • RE: SQL 2008 Log Truncation

    Apurva (8/31/2009)

    If you want to shrink your log file in 2008 use the following technique.

    --Use DatabaseName

    --GO

    --Alter Database DatabaseName Set Recovery Simple

    --GO

    --Alter Database DatabaseName Set Recovery Full

    --GO

    And take a full backup...

    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

    August 31, 2009 at 3:00 pm

    #1047171

  • RE: ExecPlan: cost is so high but the execution is very fast

    Please take a look at the article I posted for a way to save the plan in Excel. The text plans are really hard to read.

    The table definition is not...

    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

    August 31, 2009 at 2:59 pm

    #1047169

  • RE: ExecPlan: cost is so high but the execution is very fast

    Then your server is SQL 2000. There's an explaination of how to save an exec plan on SQL 2000 in this article - http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    August 31, 2009 at 2:29 pm

    #1047146

  • RE: Are there issues with ONLINE INDEX REBUILD

    wjones21 (8/31/2009)

    Also, bulk-logged recovery mode still allows for standard transactions from users to be backed up by the periodic trans log backups, correct?

    Yes

    It only effects bulk type transactions...

    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

    August 31, 2009 at 2:28 pm

    #1047145

  • RE: DBCC TRACEON 3604

    Amit Singh (8/31/2009)

    yeah looks more like a monitoring tool ... but the question still remains ... is it causing any problems ???

    Highly unlikely. All it's doing is on one single...

    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

    August 31, 2009 at 2:11 pm

    #1047129

  • RE: Are the posted questions getting worse?

    There's already duplicate users in the system. We've got at least one case where two people have the same username. Something has to be don e about those and I...

    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

    August 31, 2009 at 2:05 pm

    #1047127

  • RE: Are there issues with ONLINE INDEX REBUILD

    wjones21 (8/31/2009)

    My company is obviously concerned about the 10 hour+ exposure without a backup that an online reindexing process will lead to with the DB in SIMPLE recovery mode. 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

    August 31, 2009 at 2:03 pm

    #1047125

Viewing 15 posts - 36,661 through 36,675 (of 49,552 total)