Forum Replies Created

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

  • RE: DBCC CHECKDB error

    Then probably TempDB really was low on space (Estimate_Only is an estimate and iirc there's problem with 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

    November 15, 2011 at 3:37 am

    #1407707

  • RE: Mysterious Execution Plan

    Because you're doing a Count(<column name>). That means COUNT(*) where <column name> IS NOT NULL. Hence that has to be added to the predicates.

    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 15, 2011 at 3:35 am

    #1407706

  • RE: Rebuilding clustered index online

    anish_ns (11/14/2011)

    Just trying to figure out the mechanics of how a Clustered index can be built online considering that the leaf of a clustered index stores the table data....

    Exactly 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 15, 2011 at 1:28 am

    #1407661

  • RE: how data will be feched from data pages using index ?

    Have you read this series? http://www.sqlservercentral.com/articles/Indexing/68439/

    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 15, 2011 at 1:24 am

    #1407658

  • RE: Query Plans and Filtered Indexes

    http://sqlinthewild.co.za/index.php/2011/11/09/sql-university-advanced-indexing-filtered-indexes-2/

    Query please?

    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 15, 2011 at 1:22 am

    #1407657

  • RE: DBCC CHECKDB error

    The error is:

    Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent

    It's usually the latter in my experience. Can you...

    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 15, 2011 at 1:21 am

    #1407656

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (11/14/2011)

    Anyone knows this? Permissions to read sql log files?

    http://www.sqlservercentral.com/Forums/Topic1205472-1550-1.aspx

    Well they're text files on the drive, so regardless of SQL permissions, anyone with access to that folder can 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 14, 2011 at 2:33 pm

    #1407541

  • RE: Simple SQL (SET) statements taking time in our recent trace file

    Suresh Kumar-284278 (11/14/2011)

    Thanks for the suggestions.

    Could you please clarify how to check for the wait types? Sorry i am not sure of that.

    Thanks,

    Suresh

    Check sys.dm_exec_requests while they are running.

    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 14, 2011 at 2:32 pm

    #1407539

  • RE: Simple SQL (SET) statements taking time in our recent trace file

    Ninja's_RGR'us (11/14/2011)

    I'd start with, is there more code here?

    1 sec for this is extreme.

    However note that the CPU time is 0.

    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 14, 2011 at 2:32 pm

    #1407538

  • RE: Recovering from FILESTREAM Orphaned File Error

    According to the experts in this, either CheckDB with a repair option (probably repair_allow_data_loss) or just delete the file in question. You've got both the file name and the directory...

    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 14, 2011 at 1:43 pm

    #1407507

  • RE: Simple SQL (SET) statements taking time in our recent trace file

    Did you catch the wait types when they were running?

    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 14, 2011 at 1:25 pm

    #1407501

  • RE: ASYNC_NETWORK_IO, TRACEWAIT wait types

    It's that the client application is not processing data fast enough. SQL is waiting for the client app to accept the rows.

    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 14, 2011 at 12:17 pm

    #1407473

  • RE: High performance issues !!

    http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Chapter 4.

    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 14, 2011 at 11:46 am

    #1407457

  • RE: Error trying to create a DB in sql 2005

    What is he trying to create? A database or an Analysis Services Cube?

    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 14, 2011 at 10:40 am

    #1407410

  • RE: dbcreator server role has permission to change sa password?

    Able to see the screen != able to change the password.

    A member of db_creator cannot change the password. If he can get the dialog up then that's all he'll...

    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 14, 2011 at 10:21 am

    #1407383

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