Forum Replies Created

Viewing 15 posts - 22,726 through 22,740 (of 49,552 total)

  • RE: sys.dm_db_index_usage_stats --- User_Seeks has 0 sometimes NULL?

    What query are you using? Because according to BoL, the counters are set to 0 when a row is added. Last user seek can be null, but the user seeks...

    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

    October 25, 2011 at 3:38 pm

    #1399355

  • RE: DBCC SHRINKFILE

    I assume you're trying to shrink the log file. Does it have free space in it? If not, shrink's going to do nothing (btw, TruncateOnly is an option only 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

    October 25, 2011 at 3:35 pm

    #1399354

  • RE: index on big table

    Steve Jones - SSC Editor (10/25/2011)

    However there is physical ordering of the rows inside the pages and in attempts to maintain the rows in the physical order in pages, which...

    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

    October 25, 2011 at 3:27 pm

    #1399346

  • RE: Need to find the user who modified a particular stored procedure.

    The only way to tell who changed it, if you don't have some custom auditing is to check the default trace, assuming the record of the modification is still in...

    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

    October 25, 2011 at 12:34 pm

    #1399260

  • RE: Update Query has me confused

    Hit post too soon?

    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

    October 25, 2011 at 10:07 am

    #1399202

  • RE: index on big table

    Phil Parkin (10/25/2011)

    Clustered index = logical order. Not physical order. Must blog.

    Gail, would you consider writing an article about this? It would generate lots of interest, I am sure.

    I'll write...

    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

    October 25, 2011 at 9:50 am

    #1399195

  • RE: index on big table

    Clustered index = logical order. Not physical order. Must blog.

    The clustered index should be picked to minimize the page splits while also handling range queries (or aggregates) if they're appropriate...

    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

    October 25, 2011 at 9:30 am

    #1399175

  • RE: Deleted data from table

    There's no real easy way to do that, and it's not something SQL can be configured to do. A CLR function would be my guess as to one way, though...

    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

    October 25, 2011 at 8:23 am

    #1399141

  • RE: Cannot Create View - Object_Id Sequencing Issue?! Corruption?

    TZ.DBGeek (10/25/2011)

    Gila-M, thanks for your reply. As I stated querying sys.objects (and all other catalog views) returns 0 records. I found the issue -- a table existed with the same...

    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

    October 25, 2011 at 5:44 am

    #1399039

  • RE: Simple Equal not returning records but Like condition is

    Also worth running this:

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY

    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

    October 25, 2011 at 5:41 am

    #1399036

  • RE: Boot Page Corruption

    Restore from backup. This is not repairable in any way.

    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

    October 25, 2011 at 5:39 am

    #1399035

  • RE: could not start the sql server agent service on local computer

    Those logs are all over a year old. I doubt they're relevant.

    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

    October 25, 2011 at 5:35 am

    #1399031

  • RE: How to shrink the tempdb (without service re-start or re-boot) ?

    As it says, if you shrink TempDB while it's in use, you can get corruption errors that require a restart to fix.

    I suspect the better question here is why are...

    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

    October 25, 2011 at 5:32 am

    #1399029

  • RE: How to shrink the tempdb (without service re-start or re-boot) ?

    http://support.microsoft.com/kb/307487

    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

    October 25, 2011 at 3:17 am

    #1398992

  • RE: Deleted data from table

    Possibly OPENROWSET and read from the file (assuming it's not disabled on your 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

    October 25, 2011 at 3:16 am

    #1398991

Viewing 15 posts - 22,726 through 22,740 (of 49,552 total)