Forum Replies Created

Viewing 15 posts - 13,996 through 14,010 (of 49,552 total)

  • RE: #Files and FILEGROUPS

    PiMané (3/7/2013)

    GilaMonster (3/7/2013)

    Really? Have you tried that?

    Not with indexes... just some more "sensible" data (accounts, orders, ...) and "fixed" data (like countries, regions, currencies, ...).

    You might want to try 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

    March 7, 2013 at 11:09 am

    #1594605

  • RE: Memory Error - Failed to reserve contiguous memory

    Please note: 11 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

    March 7, 2013 at 10:26 am

    #1594578

  • RE: #Files and FILEGROUPS

    PiMané (3/7/2013)

    If there are IO issues should the new ndf file be on the same RAID or a different, probably new one (since the IO is on the RAID adding...

    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

    March 7, 2013 at 10:21 am

    #1594573

  • RE: backup and restore of filegroups

    http://msdn.microsoft.com/en-us/library/ms189906.aspx

    http://msdn.microsoft.com/en-us/library/ms190388.aspx

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

    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

    March 7, 2013 at 9:58 am

    #1594549

  • RE: #Files and FILEGROUPS

    The one file/ x cores is for TempDB, not for user databases.

    Unless you have reason to split a user database for recoverability or IO issues, you probably don't want...

    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

    March 7, 2013 at 9:46 am

    #1594536

  • RE: ORDER BY = Bubble Sort ? Quick Sort ? Insertion Sort ?

    Grant Fritchey (3/7/2013)

    GilaMonster (3/7/2013)

    Unless the data's small enough it can manage entirely within the memory grant. Not much chance of that except with trivial data.

    Not arguing, just clarifying, won't it...

    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

    March 7, 2013 at 9:45 am

    #1594532

  • RE: Differential backup question

    SQL Show (3/7/2013)

    anthony.green (2/14/2013)

    Highly risky move, should be backing up to individual files not one big file, as should anything happen to that 1 file you cannot restore to any...

    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

    March 7, 2013 at 9:41 am

    #1594531

  • RE: backup and restore of filegroups

    From Books Online:

    Under the simple recovery model, file backups are basically restricted to read-only secondary filegroups.

    You can take filegroup backups of a database in simple recovery, but they'll 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

    March 7, 2013 at 9:40 am

    #1594530

  • RE: ISOLATION LEVEL READ UNCOMMITTED

    Read uncommitted, the isolation level that should be called 'Potentially inconsistent data'

    See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

    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

    March 7, 2013 at 9:37 am

    #1594527

  • RE: ORDER BY = Bubble Sort ? Quick Sort ? Insertion Sort ?

    Grant Fritchey (3/7/2013)

    The query engine will do what it does. That's in the internals. No way to know without a debugger or insider knowledge. It will use tempdb though.

    Unless 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

    March 7, 2013 at 9:27 am

    #1594521

  • RE: IN Vs INNER JOIN

    Stuart Davies (3/7/2013)

    I'm not dissenting with any previous replies, but personally I would check the results before changing any production code.

    Try it on a test system with the real...

    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

    March 7, 2013 at 3:11 am

    #1594360

  • RE: IN Vs INNER JOIN

    Dung Dinh (3/7/2013)

    GilaMonster (3/7/2013)

    Dung Dinh (3/7/2013)

    2 - If both are big, you should use second solution and index the columns on ON clause

    Not true.

    I mean that the second is preferred...

    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

    March 7, 2013 at 2:54 am

    #1594355

  • RE: ORDER BY = Bubble Sort ? Quick Sort ? Insertion Sort ?

    Well the optimiser won't use any algorithm. The optimiser optimises queries, it doesn't run them.

    Why does it matter?

    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

    March 7, 2013 at 2:40 am

    #1594349

  • RE: IN Vs INNER JOIN

    Dung Dinh (3/7/2013)

    2 - If both are big, you should use second solution and index the columns on ON clause

    Not true.

    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

    March 7, 2013 at 2:04 am

    #1594336

  • RE: Database getting into recovery mode

    There are two reasons why a database goes into the recovering state. SQL is restarted or the database is being closed and reopened (offline, autoclose, etc).

    Check the logs, ensure 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

    March 7, 2013 at 2:01 am

    #1594335

Viewing 15 posts - 13,996 through 14,010 (of 49,552 total)