Forum Replies Created

Viewing 15 posts - 12,226 through 12,240 (of 49,552 total)

  • RE: Shrink database file with EMPTYFILE option

    saran.dharsh (7/30/2013)

    NO.. Because will never allow this operation, it leads to data loss.

    Err.. what? Shrinking a database doesn't lose data.

    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

    July 30, 2013 at 4:28 am

    #1636900

  • RE: Shrink database file with EMPTYFILE option

    writearjun53 (7/29/2013)

    I want to know that can we shrink database file with EMPTYFILE option while currently accepting data or we just need to do some other thing to shrink database...

    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

    July 30, 2013 at 4:27 am

    #1636899

  • RE: PRIMARY KEY VS UNIQUE KEY*

    http://msdn.microsoft.com/en-us/library/cc280372%28v=sql.100%29.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

    July 30, 2013 at 4:22 am

    #1636896

  • RE: Adding RAM to SQL 2005 SE, but 2000 Compatibility

    If the app's pulling enough data to make Management Studio run out of memory, I'm not particularly surprised that it's timing out. That'll be a lot of data.

    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

    July 29, 2013 at 10:05 am

    #1636702

  • RE: Adding RAM to SQL 2005 SE, but 2000 Compatibility

    Oh, and don't run Management Studio on the server and run queries that return huge resultsets....

    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

    July 29, 2013 at 9:18 am

    #1636688

  • RE: Adding RAM to SQL 2005 SE, but 2000 Compatibility

    That's a client error. not a server error. Sql server isn't written in .Net and yet that's a .net error.

    You'll get that if you're pulling a huge resultset into Management...

    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

    July 29, 2013 at 8:51 am

    #1636675

  • RE: Adding RAM to SQL 2005 SE, but 2000 Compatibility

    All that compatibility level does is change the way that the query processor executes some specific SQL statements, ones that changed behaviour between 2000 and 2005 (and whether or not...

    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

    July 29, 2013 at 8:03 am

    #1636652

  • RE: why should we use schemabinding with views?

    L' Eomot Inversé (7/29/2013)

    I think this is about the first time I've disagreed with Gail about anything. She's better at most SQL Server things than me, but here...

    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

    July 29, 2013 at 6:43 am

    #1636610

  • RE: why should we use schemabinding with views?

    You don't need it, unless you're planning on creating an index on that view (creating an indexed view)

    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

    July 29, 2013 at 4:32 am

    #1636581

  • RE: creating a copy of a database for testing on

    Copy daily backup from production, restore. Will be faster than the copy database wizard and far less impact on production since you'll be leverageing the daily backups already 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

    July 28, 2013 at 8:47 am

    #1636467

  • RE: moving log files

    Carlosql (7/27/2013)

    My plan is:

    1. Stop the replication jobs

    2. change to Single-user mode

    3. move the log files

    4. restart the sql server.

    5.change to muti-user mode

    If you do that to the system databases,...

    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

    July 28, 2013 at 3:51 am

    #1636443

  • RE: Upgrading certification from mcts sql2008 to sql mcsa 2012

    PearlJammer1 (7/27/2013)

    As there are no books available for the upgrade,would i need to read all 3 of these books (461,462,463, quering sql2012, administering 2012, and datawarehouse 2012 respectively ) ?

    Yes.

    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

    July 27, 2013 at 6:50 am

    #1636396

  • RE: SELECT StatMan

    The Statman query is what's run internally for statistics updates.

    What exactly is the problem here?

    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

    July 26, 2013 at 1:27 pm

    #1636304

  • RE: SELECT StatMan

    HildaJ (7/26/2013)

    I have a job running statistics, that's generating it?

    Either that or the automatic stats updates, or both.

    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

    July 26, 2013 at 12:56 pm

    #1636293

  • RE: SELECT StatMan

    It's a statistics update, probably auto-stats.

    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

    July 26, 2013 at 12:30 pm

    #1636278

Viewing 15 posts - 12,226 through 12,240 (of 49,552 total)