Forum Replies Created

Viewing 15 posts - 14,356 through 14,370 (of 49,552 total)

  • RE: Database in Recovery mode from last 7 days.

    hemanth.damecharla (2/8/2013)

    GilaMonster (2/8/2013)

    The only thing you can do for a recovering database is wait. If the schedulers are still hung may require another restart, bear in mind that'll undo 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

    February 8, 2013 at 10:00 am

    #1586057

  • RE: Database in Recovery mode from last 7 days.

    The only thing you can do for a recovering database is wait. If the schedulers are still hung may require another restart, bear in mind that'll undo any recovery work...

    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 8, 2013 at 8:45 am

    #1586002

  • RE: Multiple Files, Single FileGroup am i missing something

    n00bDBA (2/8/2013)

    I thought that unless you create filegroups.. its not possible to choose what data file things are saved to.

    Correct.

    As for why the files are different sizes, they were...

    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 8, 2013 at 7:01 am

    #1585942

  • RE: Sort by/Order By

    wafw1971 (2/8/2013)

    What the questions is about is setting up the SELECT statement within the table to have that information sorted already so when some one does query the data its...

    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 8, 2013 at 6:58 am

    #1585940

  • RE: What is proper way of indexing on a table which contain large amount of data

    Anuj Rathi (2/8/2013)

    record_cat is foreign key for record_subcat1 & record_subcat1 is foreign key for record_subcat2.

    So, as per your explanation, record_subcat2 is most selective column in our index &

    record_subcat2, record_subcat1, record_cat,...

    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 8, 2013 at 6:56 am

    #1585938

  • RE: Sort by/Order By

    This will give you the CalendarMonth as you asked. For ordering, you could just have ordered by the Date column and it would have sorted correctly without this

    CREATE TABLE Time3

    (Date...

    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 8, 2013 at 6:19 am

    #1585918

  • RE: What is proper way of indexing on a table which contain large amount of data

    Selectivity should not be the primary indicator for choosing index columns. Putting the most selective column first would be stupid if nothing filters by it. The decision as to column...

    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 8, 2013 at 6:00 am

    #1585908

  • RE: Sort by/Order By

    wafw1971 (2/8/2013)

    Thanks for that, but I need to know how to add a sort to the SQL Code, not the query. It maybe me not making it clear and I...

    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 8, 2013 at 5:56 am

    #1585906

  • RE: Sort by/Order By

    No, I mean that the query that retrieves from that table needs to have an ORDER BY clause on it.

    How the data is inserted into the table is absolutely...

    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 8, 2013 at 4:09 am

    #1585852

  • RE: Interview Questions

    So what do you have so far and where are you stuck.

    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 8, 2013 at 4:07 am

    #1585851

  • RE: Sort by/Order By

    wafw1971 (2/8/2013)

    all I need to do know is make sure the CalendarMonth when queried is in month order for example Jan, Feb and not Apr, Aug etc.

    For that you need...

    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 8, 2013 at 2:57 am

    #1585819

  • RE: Database recovery after truncate command

    Unless the truncate was run in a transaction that has not yet been committed or there's a recent backup to restore, that data is not coming back.

    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 8, 2013 at 2:53 am

    #1585816

  • RE: What is proper way of indexing on a table which contain large amount of data

    Anuj Rathi (2/8/2013)

    "If you have a WHERE clause that includes expressions connected by two or more AND operators, SQL Server will evaluate them from left to right in the 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

    February 8, 2013 at 2:28 am

    #1585807

  • RE: Transactional Table with size 225 GB, needs index maintenance and partitioning

    Bhuvnesh (2/7/2013)

    1) WHat would be the combination used on clustered index ?

    "policy_id + end_time" OR "start_time + policy_id"

    No way to answer...

    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 8, 2013 at 1:42 am

    #1585788

  • RE: What is proper way of indexing on a table which contain large amount of data

    As Grant said earlier

    Other than that, I'd say recognize the access patterns and then build indexes to support them.

    No, you absolutely do not want to create indexes for every theoretical...

    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 7, 2013 at 2:22 pm

    #1585669

Viewing 15 posts - 14,356 through 14,370 (of 49,552 total)