Forum Replies Created

Viewing 15 posts - 15,211 through 15,225 (of 49,552 total)

  • RE: Some doubts on T-SQL basic fundamentals

    ganeshkumar005 (12/17/2012)

    But my concern remain unanswered is - how exactly the update process will occur internally? All in one shot? Or in a sequntial manner -- If yes, which row...

    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 17, 2012 at 1:51 am

    #1569041

  • RE: Instance level backup

    SQL backups are at a database level, so to backup an instance you need to take database backups of all databases on that instance (don't forget the system DBs)

    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 17, 2012 at 1:28 am

    #1569035

  • RE: DBCC Commands

    If you retain your backups for a week or more, running CheckDB just on weekends is fine. Just be sure that you retain backups (full and log) long enough that...

    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 17, 2012 at 1:25 am

    #1569034

  • RE: Some doubts on T-SQL basic fundamentals

    Could you be more specific please?

    If you mean something like this:

    UPDATE Table SET SomeColumn = SomeValue WHERE SomeID between 1 and 10 -- updates 10 rows

    then there's no temp table...

    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 17, 2012 at 1:01 am

    #1569031

  • RE: SQL 2012 Startup Duration?

    Were the TempDB files where they should be? Or did SQL have to create them?

    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 17, 2012 at 12:58 am

    #1569030

  • RE: dbcc indexdefrag vs reorganize

    Firstly, stop using the DBCC commands, they're deprecated, included only for backward compatibility with SQL Server 2000 and should not be used in new development. The replacements are ALTER INDEX...

    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 17, 2012 at 12:56 am

    #1569029

  • RE: DB Shrink

    shindle 17293 (12/16/2012)

    Am I correct in explaining that the compressed backup size will not reduce further even if I perform a shrink on the database as the backup has already...

    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 17, 2012 at 12:44 am

    #1569027

  • RE: Missing Indexes on Temp tables

    ganeshmuthuvelu (12/16/2012)

    Can anyone confirm that SQL Server 2008 R2 provides no way to find these out?

    The missing index information should be in the execution plan.

    Even with normal tables, 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

    December 16, 2012 at 10:35 am

    #1568959

  • RE: Formatting Phone Number

    Edit: nm

    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 16, 2012 at 9:56 am

    #1568954

  • RE: Missing Indexes on Temp tables

    Get the user to run then and send you the execution plans. Analyse and see if the index suggestion in there (if any) is sensible. Otherwise analyse the plan and...

    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 16, 2012 at 9:55 am

    #1568953

  • RE: ORDER BY Should be same as my input in IN()

    Josh Ashwood (12/16/2012)

    Indeed, I must confess that I have committed the following sins according to Celko :-

    - Written more than three cursors in my lifetime

    Check

    - Used UPDATE...FROM more than once

    Check

    -...

    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 16, 2012 at 6:49 am

    #1568943

  • RE: Partitioning

    mah_j (12/16/2012)

    You mean besides that, I should check other options like indexing ,memory management,.....?

    I mean that if you want to performance tune your query, then performance tune your query. Don't...

    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 16, 2012 at 6:06 am

    #1568940

  • RE: Partitioning

    mah_j (12/16/2012)

    I created partition over [TransDate] and all the indexes ON DB_PartitionScheme ([TransDate]),but the logical reads of this table and cpu time increase in test db.

    Not surprising.

    I don't know 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

    December 16, 2012 at 3:24 am

    #1568934

  • RE: database log file size 900 GB

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    I have changed the DB to FULL recovery mode temporarily untill this log space is released back to the disk

    Waste of time.

    In simple recovery model, 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 16, 2012 at 3:22 am

    #1568933

  • RE: Deadlock due to intra-query parallelism

    Abdul Rahman (12/14/2012)

    But after interpreting the output and discussing with the developers, they want to start with adding with(Nolock) to all the queries, detected by -T1222.

    Won't help. Look at 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 15, 2012 at 12:59 am

    #1568882

Viewing 15 posts - 15,211 through 15,225 (of 49,552 total)