Forum Replies Created

Viewing 15 posts - 20,131 through 20,145 (of 49,552 total)

  • RE: Left Join Vs Where Clause

    Divine Flame (2/23/2012)

    sqlzealot-81 (2/23/2012)

    Divine Flame (2/23/2012)

    I don't understand your question. You already have the solution as version 2. True, you should put all the filter criteria in WHERE clause. There...

    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

    February 23, 2012 at 3:05 am

    #1450724

  • RE: Left Join Vs Where Clause

    sqlzealot-81 (2/23/2012)

    But for Left, it makes lots of difference the filter is with join or where...

    Yes, completely changes the meaning of the query. So the question is, which gives 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

    February 23, 2012 at 2:58 am

    #1450718

  • RE: Can u import and export SQL server 2005 databases with SQL server 2012?

    Yes, SQL 2012 can attach a SQL 2005 database, but as soon as you do that the database is upgraded to a 2012 database and you won't be able 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

    February 23, 2012 at 2:52 am

    #1450716

  • RE: while Restore a Database how to avoid object.......:(

    If your database was divided into multiple filegroups and all the objects you don't want to restore were in one filegroup (not the primary filegroup), then you can restore all...

    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

    February 23, 2012 at 2:47 am

    #1450713

  • RE: Need Help on Shrinking Database....

    1 - that's a very bad idea

    2 - that won't work in SQL 2005.

    Please read through this - Managing Transaction Logs[/url]

    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

    February 23, 2012 at 2:35 am

    #1450708

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/22/2012)

    GilaMonster (2/22/2012)

    ... the usergroup is not a registered entity and all of the leads would have to pay tax on any donations we receive because...

    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

    February 23, 2012 at 2:35 am

    #1450707

  • RE: Query Very Slow - Access 2010 upsize to SQL Server 2008 RTM

    Mile Higher Than Sea Level (2/22/2012)

    The tables had multiple indexes that performed great in Access. Removed them one at a time because sometimes an index on a tiny table 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

    February 23, 2012 at 2:30 am

    #1450706

  • RE: Query Very Slow - Access 2010 upsize to SQL Server 2008 RTM

    Lack of indexes

    Non-sargable predicates

    Stale or missing statistics

    Slow disk IO subsystem and/or lack of memory

    that's just the first few that come to mind

    If by Access linked to SQL you means linked...

    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

    February 22, 2012 at 3:37 pm

    #1450595

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    p.s. Index reorganise does not update statistics.

    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

    February 22, 2012 at 3:02 pm

    #1450576

  • RE: Database backups best practice

    Please note: 4 year 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

    February 22, 2012 at 2:03 pm

    #1450558

  • RE: DBCC TRACE FLAG best practices

    I wouldn't use either on a SQL 2008 server. On SQL 2008 for deadlocks either check the system health session (extended events) or use traceflag 1222

    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

    February 22, 2012 at 1:37 pm

    #1450542

  • RE: BACKUP verify in TSQL

    BACKUP DATABASE ..... WITH CHECKSUM

    RESTORE VERIFYONLY FROM DISK = ....

    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

    February 22, 2012 at 1:36 pm

    #1450540

  • RE: Are the posted questions getting worse?

    Awesome...

    I do love the CERN research director's comment about the potential faster-than-light neutrinos ""I have difficulty to believe it, because nothing in Italy arrives ahead of time."

    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

    February 22, 2012 at 1:27 pm

    #1450539

  • RE: Reindexing issue on SQL Server 2005 Standard Edition

    ALTER INDEX... REORGANISE instead of rebuild, or persuade for an Enterprise Edition upgrade (for online index build/rebuild)

    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

    February 22, 2012 at 12:50 pm

    #1450524

  • RE: Encrypt database backup set

    You've tested and found an unacceptable performance degradation from using TDE?

    http://msdn.microsoft.com/en-us/library/cc278098%28v=sql.100%29.aspx

    The performance impact of TDE is minor. Because the encryption occurs at the database level, the database can leverage indexes...

    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

    February 22, 2012 at 11:54 am

    #1450498

Viewing 15 posts - 20,131 through 20,145 (of 49,552 total)