Forum Replies Created

Viewing 15 posts - 601 through 615 (of 757 total)

  • RE: SQL Demo App

    Henrico Bekker (3/16/2012)

    Where would I even start?

    Have you downloaded and installed SQL2012 RTM/RC0 yet? with it, SQL Data Tools (development studio) will install as well if chosen.

    There are templates for...

    March 16, 2012 at 12:53 am

    #1460335

  • RE: SQL Demo App

    Henrico Bekker (3/16/2012)

    We saw the same demo up here in JHB.

    try searching for 2012 samples, MS, codeplex etc..

    here are a few:

    http://sqlcat.com/sqlcat/b/msdnmirror/archive/2011/12/22/sql-server-2012-alwayson-high-availability-and-disaster-recovery-design-patterns.aspx

    http://msftdbprodsamples.codeplex.com/releases/view/55330

    Try creating your own application?

    Thanks

    I would like to create my...

    March 16, 2012 at 12:31 am

    #1460332

  • RE: Index Fragmentation

    GilaMonster (3/14/2012)

    derekr 43208 (3/14/2012)

    GilaMonster (3/14/2012)

    Fragmentation will never cause SQL to not find a value where it's supposed to be (according to the index tree). If a value is not where...

    March 15, 2012 at 7:26 am

    #1459825

  • RE: Index Fragmentation

    In what sense?

    If an Index is fragmented, does that mean the the actual table data is out of order or does it just mean that the Index data pages are...

    March 15, 2012 at 7:19 am

    #1459819

  • RE: Index Fragmentation

    Am I right in that when an Index is fragmented, its pages are out of order?

    This means that more I/O operations are required to fetch whatever it needs?

    What happens to...

    March 15, 2012 at 12:19 am

    #1459648

  • RE: Index Fragmentation

    The performance degradation from fragmentation has nothing whatsoever to do with the ability of SQL to find a value within an index. It is solely about the efficiency of large...

    March 14, 2012 at 11:37 am

    #1459399

  • RE: Index Fragmentation

    Lynn Pettis (3/14/2012)

    derekr 43208 (3/14/2012)

    GilaMonster (3/14/2012)

    Fragmentation will never cause SQL to not find a value where it's supposed to be (according to the index tree). If a value is not...

    March 14, 2012 at 11:21 am

    #1459386

  • RE: Index Fragmentation

    Lynn Pettis (3/14/2012)

    derekr 43208 (3/14/2012)

    GilaMonster (3/14/2012)

    Fragmentation will never cause SQL to not find a value where it's supposed to be (according to the index tree). If a value is not...

    March 14, 2012 at 11:13 am

    #1459379

  • RE: Index Fragmentation

    GilaMonster (3/14/2012)

    Fragmentation will never cause SQL to not find a value where it's supposed to be (according to the index tree). If a value is not where it's supposed to...

    March 14, 2012 at 10:53 am

    #1459359

  • RE: Index Fragmentation

    Hi

    A question regarding fragmentation

    If SQL looks for a value and doesn't find it where it's supposed to be because of fragmentation. Does SQL then have to go through all index...

    March 14, 2012 at 8:26 am

    #1459228

  • RE: Disaster Recovery: Rebuild system databases on SQL Server 2008 cluster

    Leon Orlov-255445 (3/12/2012)

    I would not recommend this option unless you absolutely have to bring your SQL Server online within 1 hour to meet the SLA and simply reattach all your...

    March 13, 2012 at 5:12 am

    #1458392

  • RE: Update Statistics - Views

    GilaMonster (2/28/2012)

    Check what Books Online says, there's a chance that the blog post is just wrong.

    I checked 2008 BOL and there is no reference to not being able to specify...

    February 28, 2012 at 5:34 am

    #1452526

  • RE: Update Statistics - Views

    GilaMonster (2/28/2012)

    Check what Books Online says, there's a chance that the blog post is just wrong.

    Thanks

    I've created an Update Statistics Maintenance plan on a SQL2005 Sp3 box. I specified all...

    February 28, 2012 at 5:33 am

    #1452525

  • RE: Update Statistics - Views

    GilaMonster (2/27/2012)

    Is the article you read taking about views (which are just saved select statements and have neither data, indexes nor statistics) or indexed views?

    Hi

    See link below

    http://saveadba.blogspot.com/2012/02/cannot-update-statistics-fullscan-and.html

    I have created an...

    February 27, 2012 at 10:51 pm

    #1452372

  • RE: AlwaysOn Database Mirroring

    The older style database mirroring (as in 2005 and 2008) will still be there as-is, unchanged.

    I thought that a change is 2012 was that the mirror(secondary) database would allow for...

    February 7, 2012 at 7:41 am

    #1443778

Viewing 15 posts - 601 through 615 (of 757 total)