Forum Replies Created

Viewing 15 posts - 15,361 through 15,375 (of 49,552 total)

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    SQL_ME_RICH (12/5/2012)

    Is it true that if I have a T-SQL statement using (NOLOCK) in multiple places in my Stored Procedure (FROM, INNER JOIN, etc...) that those hints are being...

    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

    December 6, 2012 at 1:41 am

    #1566044

  • RE: challenges of sql programming/development with VLDBs

    bagofbirds-767347 (12/5/2012)

    To put it shortly, what challenges does a sql programmer face with VLDBs that he would not with smaller dbs?

    Performance.

    Everything's fast on few hundred rows. With a...

    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

    December 5, 2012 at 12:31 pm

    #1565890

  • RE: Views -between operator in where clause

    var05 (12/5/2012)

    any help on this?

    Yeah, don't store dates as varchars, store them as datetime data types and then the comparisons will be date-based, not string based.

    I strongly recommend fixing 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

    December 5, 2012 at 11:08 am

    #1565868

  • RE: Filegroup and number of files per FG questions - Redesign of 2 TB DB with 2,000+ batches per second

    Looks pretty good.

    Why multiple files in a filegroup? Just to allow for the SAN's snapshot? (check that the snapshot software supports SQL Server databases before you use it). There'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

    December 5, 2012 at 9:36 am

    #1565826

  • RE: Random index corruption

    reguitti (12/5/2012)

    I use the command

    DBCC DBREINDEX(MOV_MAG,' ')

    That's deprecated and has been for about 7 years. Look up ALTER INDEX

    The thing which is giving me some perplexity is that before...

    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

    December 5, 2012 at 9:19 am

    #1565812

  • RE: Filegroup and number of files per FG questions - Redesign of 2 TB DB with 2,000+ batches per second

    Jeff Kelly-310227 (12/5/2012)

    Are there a recommended number of files per Filegroup –some mathematical formula to # of cores/etc…?

    Nope.

    There's two main reasons for going multiple files/multiple filegroups

    1) IO throughput. This requires...

    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

    December 5, 2012 at 8:21 am

    #1565788

  • RE: SQL Server index fragmentation is high after rebuilt

    You still haven't answered my question about shrinks.

    Fill factor is not going to affect how the index rebuild works. It'll affect how the index fragments after that, but not 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

    December 5, 2012 at 7:58 am

    #1565771

  • RE: sys.dm_exec_query_memory_grants

    murugan.shanmugam (12/5/2012)

    Hi,

    Server 32 bit or 64 bit and awe enabled?

    Irrelevant to this question.

    Year and a half old thread

    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

    December 5, 2012 at 6:27 am

    #1565719

  • RE: Random index corruption

    The post title mentioned corruption, but the contents mention performance. Which is it? Do you have random index corruption or do you have poor performance?

    Typically when an index rebuild fixes...

    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

    December 5, 2012 at 6:24 am

    #1565715

  • RE: Force read lock in a table, to avoid problems between parallel processes.

    Bhuvnesh (12/5/2012)

    then there is no guarantee that destination table will have same ID for same records as it has in source table (remember...sequence of insert query will...

    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

    December 5, 2012 at 6:20 am

    #1565713

  • RE: SQL Server index fragmentation is high after rebuilt

    Bhuvnesh (12/5/2012)

    the index rebuild works on the basis of the fill factor and in this case i dont think fill factor will help here.

    What are you trying to...

    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

    December 5, 2012 at 6:18 am

    #1565712

  • RE: Error, not sure where to start: Attept to fetch logical page... failed. incorrect checkum

    If the DB with the errors is just your monitoring DB then that's not so bad.

    Still need the checkDB output to say anything helpful.

    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

    December 5, 2012 at 6:16 am

    #1565711

  • RE: How to failover if Principal is disconnected

    ALTER DATABASE <database_name>

    SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    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

    December 5, 2012 at 12:58 am

    #1565590

  • RE: Database not available after restarting windows services

    Managing Transaction Logs[/url]

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    December 4, 2012 at 1:36 pm

    #1565481

  • RE: Is Table poartition the only way for large Tables

    Partitioning is mostly about maintenance and data loads, not performance.

    Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Searching on something like '%couldnot%' is going to be...

    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

    December 4, 2012 at 12:34 pm

    #1565467

Viewing 15 posts - 15,361 through 15,375 (of 49,552 total)