Forum Replies Created

Viewing 15 posts - 41,701 through 41,715 (of 49,552 total)

  • RE: DBCC CHECKDB doing nothing

    Is it blocked by another query? Is there a wait type, and if so, what is it? (check sysprocesses)

    Are there any entries in the error log? That sometimes happens when...

    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

    January 15, 2009 at 8:22 am

    #927371

  • RE: Are the posted questions getting worse?

    Chris Morris (1/15/2009)

    They take a few moments to string, speshly in the dark, so if Mr Catburglar comes visiting then your best move would be to pin him to 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

    January 15, 2009 at 8:16 am

    #927361

  • RE: Index is not used (but it is, after editing something....)

    By rebuilding the index you have updated statistics and removed fragmentation. Both can make SQL pick an index it previously ignored. My bet's on the statistics.

    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

    January 15, 2009 at 8:07 am

    #927345

  • RE: deciphering the erroelog code.

    There's nothing there that makes any sense and certainly nothing that points to a cause for a deadlock. I've never heard of a deadlock on a communication buffer before.

    Maybe give...

    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

    January 15, 2009 at 8:00 am

    #927334

  • RE: Common Mistakes in T-SQL

    Kent Waldrop (1/15/2009)

    And veto power can stop many problems before they ever happen.

    I officially had veto rights at my last company. I say officially, because the CIO tended...

    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

    January 15, 2009 at 7:58 am

    #927329

  • RE: Common Mistakes in T-SQL

    Jeff Moden (1/15/2009)

    I've been fortunate, recently... I've convinced folks to mostly NOT buy 3rd party software and, when we do, I get to grill both the software and the people...

    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

    January 15, 2009 at 7:25 am

    #927287

  • RE: DBCC won't even run

    So the drive was accessible when SQL started, but something happened a little later. Can you check the windows event log around the same time as the latch errors started?...

    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

    January 15, 2009 at 7:14 am

    #927273

  • RE: Are the posted questions getting worse?

    GSquared (1/15/2009)

    Sounds like quite a nice collection. All I have is handguns, and none of them are particularly pretty (functional, but not quite so aesthetic).

    Grant Fritchey (1/15/2009)

    There are projectile...

    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

    January 15, 2009 at 6:55 am

    #927254

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/15/2009)

    For example, oh Gail, how many swords in your house?

    Only one at the moment. I'm considering buying a basket-hilt rapier (local weapons shop has a nice ornamental...

    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

    January 15, 2009 at 6:41 am

    #927241

  • RE: Common Mistakes in T-SQL

    Kent Waldrop (1/15/2009)

    I would say that biggest source of the problems that I've seen over the years are design problems.

    Agreed. I'm in the middle of a wonderful one now.

    Rather...

    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

    January 15, 2009 at 6:34 am

    #927236

  • RE: DBCC won't even run

    -- Cranfield (1/15/2009)

    I was thinking of renaming the files, dropping the database and then atttempting to attach the files.

    No! Absolutely not. If you do that, there's a good chance...

    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

    January 15, 2009 at 6:21 am

    #927221

  • RE: Cannot shrink log file 2 (LOG FILE) because all logical log files are in use.

    Ol'SureHand (1/15/2009)

    Nevertheless, if databases are small enough to back up in full and we don't have to offer point-in-time data recovery, the log can be truncated every night as it...

    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

    January 15, 2009 at 6:20 am

    #927217

  • RE: Need output as 1,2,3,...10

    arup_kc (1/15/2009)

    Hi Gail,

    This is actualy a question, which I have faced in an interview.

    I thought as much.

    Just note with the solutions above, there's no guarantee of order. It...

    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

    January 15, 2009 at 6:16 am

    #927214

  • RE: Managing the Transaction Log size growth during an index rebuild

    Please read through this - Managing Transaction Logs[/url]

    I just noticed that you're backing up the log with NO_TRUNCATE. Why?

    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

    January 15, 2009 at 4:35 am

    #927176

  • RE: Need output as 1,2,3,...10

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Why do you want to concatenate the values?...

    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

    January 15, 2009 at 4:28 am

    #927175

Viewing 15 posts - 41,701 through 41,715 (of 49,552 total)