Forum Replies Created

Viewing 15 posts - 32,026 through 32,040 (of 49,552 total)

  • RE: Getting page count of all indexes in a SQL server

    Jose A. Hernandez (7/2/2010)

    Since taking over this SQL server administrative wise (more like thrown into actually) a couple of weeks ago, I disabled these jobs and implemented Ola Hallengren’s...

    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

    July 2, 2010 at 10:57 am

    #1188362

  • RE: How many clustered indexes can a table have?

    Sanz (7/2/2010)

    Even I have had this doubt for a sometime now... Have seen different views in blogs more than once on this topic...

    Then those blogs are wrong. There can...

    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

    July 2, 2010 at 10:56 am

    #1188359

  • RE: Shrink Log File

    Why do you want to shrink the log file?

    How much free space is in it? (DBCC SQLPERF(LogSpace))

    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

    July 2, 2010 at 10:53 am

    #1188358

  • RE: Getting page count of all indexes in a SQL server

    Query sys.dm_db_index_physical_stats. You'll need to use the detailed mode, and filter for index_level=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

    July 2, 2010 at 10:51 am

    #1188356

  • RE: performance tuning

    Google is your friend

    http://www.google.com/search?q=how+to+set+up+a+server+side+trace+%22SQL+Server%22

    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

    July 2, 2010 at 10:47 am

    #1188355

  • RE: hi i need cursor program

    Why do you want to use a cursor?

    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/

    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

    July 2, 2010 at 10:43 am

    #1188352

  • RE: what happens if i delete BUILT/IN Adminstrator

    Do you have another sysadmin login (windows authentication or SQL authentication)?

    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

    July 2, 2010 at 10:39 am

    #1188349

  • RE: What is the cause for Database goes to SUSPECT MODE

    Is this an academic question, or do you have a suspect database?

    If you have a suspect database, do you have a backup?

    If you query sys.databases, what's the exact value for...

    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

    July 2, 2010 at 10:38 am

    #1188348

  • RE: I really need some recommendations for this query

    Chris Morris-439714 (7/2/2010)

    Anthony, anybody wishing to get involved with this thread will need to convert your spreadsheet data into statements which can be interpreted by SQL Server. That could take...

    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

    July 2, 2010 at 10:33 am

    #1188346

  • RE: Truncating Transaction Log Files

    singhsatnam84 (7/2/2010)

    It acts as a publisher for replication. The problem is that corressponding subscribers have been disabled.

    The fact that the subscribers have been disabled does not change that 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

    July 2, 2010 at 5:11 am

    #1188111

  • RE: performance tuning

    Then investigate what's causing tempDB to grow and fix the root cause. Trying to shrink a database that needs to grow is not a solution.

    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

    July 2, 2010 at 5:06 am

    #1188109

  • RE: performance tuning

    p.s Why are you shrinking TempDB? If you're getting errors about tempDB full, it means that it needs to be bigger, not smaller. Shrinking is likely making the problem worse.

    Either...

    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

    July 2, 2010 at 4:07 am

    #1188095

  • RE: performance tuning

    Most likely bugs in the code that maintains the page allocations.

    Are you really running SQL 2008? those bugs should all be fixed in 2008, they were prevalent and common on...

    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

    July 2, 2010 at 4:04 am

    #1188094

  • RE: SQL users deleted

    Restore the backup that you took before deleting the users

    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

    July 2, 2010 at 3:29 am

    #1188086

  • RE: performance tuning

    DBCC UPDATEUSAGE

    run it in the context of TempDB.

    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

    July 2, 2010 at 3:29 am

    #1188085

Viewing 15 posts - 32,026 through 32,040 (of 49,552 total)