Forum Replies Created

Viewing 15 posts - 22,741 through 22,755 (of 49,552 total)

  • RE: how to retrieve the first record in a table

    mpartridge (10/24/2011)

    GilaMonster (10/24/2011)

    What defines that a row is 'first'?

    SQL doesn't have any internal insert time or anything like that and tables have no order.

    Unless the table is a clustered...

    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

    October 25, 2011 at 3:13 am

    #1398990

  • RE: Better Upgrade option

    Sapen (10/24/2011)

    Thanks for the info Gail. The default log file path was incorrect. Its now upgraded to R2.

    Intereting. Not the same error. Glad the info helped (if it did)

    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

    October 24, 2011 at 2:28 pm

    #1398891

  • RE: Extracting Data from a Database the has Corruption

    invulnarable27 (10/24/2011)

    Thanks for the advice Gail. When I ran a simple SELECT *, it only returned 980 records, stopped due to I:O error, but when repaired actually held ~5200 records....

    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

    October 24, 2011 at 2:27 pm

    #1398890

  • RE: Better Upgrade option

    I think I know this error...

    http://blogs.msdn.com/b/psssql/archive/2008/09/10/upgrade-for-sql-server-2008-can-fail-if-you-have-renamed-the-sa-account.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

    October 24, 2011 at 12:47 pm

    #1398855

  • RE: Backup Plan

    johns10t (10/24/2011)

    Part of my initial problem seemed as though it was caused by the backups, but the other part seemed as though it was due to the log file (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

    October 24, 2011 at 12:39 pm

    #1398851

  • RE: Backup Plan

    johns10t (10/24/2011)

    If I have it set to overwrite existing, and have the expiration set out 30 days, will the backup simply fail because there is no file it is allowed...

    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

    October 24, 2011 at 12:23 pm

    #1398842

  • RE: Backup Plan

    If you want one file per backup, the maintenance plan will do that, though most people recommend not generally using the maint plan.

    This set of options will create one file...

    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

    October 24, 2011 at 12:21 pm

    #1398841

  • RE: Limit Records to Clients

    SQL has no such limitations or errors. If you ask it for a million rows, it'll send you a million rows. Has to be something, some setting, in the front...

    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

    October 24, 2011 at 11:49 am

    #1398831

  • RE: Cannot Create View - Object_Id Sequencing Issue?! Corruption?

    Select * from sys.objects where name = 'CvtyPlan'

    ???

    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

    October 24, 2011 at 11:26 am

    #1398825

  • RE: Introduction to Indexes: Part 2 – The clustered index

    ChrisM@Work (10/24/2011)

    So if a table has 4.5 million rows and the Clustered Index Scan operator properties sheet displays "Actual number of rows 720939" for a query against that table, it's...

    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

    October 24, 2011 at 10:45 am

    #1398808

  • RE: Taking cold backups (and scheduling it) in SQL Server?

    kevinsql7 (10/24/2011)

    How would you schedule something like this?

    Why do you want 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

    October 24, 2011 at 9:54 am

    #1398781

  • RE: How do I decide which column(s), if any, I should place my clustered index on?

    In 2005, the TOP (100) PERCENT ... ORDER BY is completely and totally ignored. The optimiser knows that the top won't limit rows and it will no honour any order...

    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

    October 24, 2011 at 9:15 am

    #1398745

  • RE: could not start the sql server agent service on local computer

    Open up the event log or SQL Agent log and have a look at the messages in there. Should tell you why the start failed.

    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

    October 24, 2011 at 9:00 am

    #1398737

  • RE: how to retrieve the first record in a table

    What defines that a row is 'first'?

    SQL doesn't have any internal insert time or anything like that and tables have no order.

    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

    October 24, 2011 at 8:58 am

    #1398733

  • RE: How do I decide which column(s), if any, I should place my clustered index on?

    jared-709193 (10/24/2011)

    If rows in the table are stored logically in the order of the clustering key, why is it that you are not "guaranteed" an order when none is specified...

    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

    October 24, 2011 at 8:54 am

    #1398726

Viewing 15 posts - 22,741 through 22,755 (of 49,552 total)