Forum Replies Created

Viewing 15 posts - 29,716 through 29,730 (of 49,552 total)

  • RE: Sr level interview questions

    Craig Farrell (10/26/2010)

    sasi.tripuraneni (10/26/2010)

    hello,

    Can any one please post Sr level interview questions, its very urgent!

    thanks

    Sasi.

    Question 1: Did you ever go 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 27, 2010 at 2:10 am

    #1242703

  • RE: SQL Server Service Won't Start

    dougjjj (10/26/2010)

    everything had been working fine then one day after a windows update the SQL Service would no longer start.

    What did the windows update install?

    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 26, 2010 at 11:57 pm

    #1242670

  • RE: To Fetch Records from a table quickly which is having 10 Lakhs record

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 26, 2010 at 11:42 pm

    #1242666

  • RE: DBAs and System Administrators

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

    October 26, 2010 at 11:42 pm

    #1242665

  • RE: Indexes

    That's the smallest index on that table and hence the lowest IOs involved in a scan of every single index page. The cluster is likely to be the largest index...

    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 26, 2010 at 11:40 pm

    #1242663

  • RE: Are the posted questions getting worse?

    Anyone ever shrunk a DB that's involved in log shipping? If so, please comment - http://www.sqlservercentral.com/Forums/Topic1010214-146-1.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 26, 2010 at 11:31 pm

    #1242660

  • RE: Are the posted questions getting worse?

    Trey Staker (10/26/2010)

    @Gail, how's that difficult contract going?

    Difficultly.

    Officially going to prod on Friday. Project manager getting lots of praise for delivering project on time. I'm expecting another crapping out...

    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 26, 2010 at 1:32 pm

    #1242525

  • RE: Transaction back up is as big or bigger than the backup

    Does that large log backup correspond to the index rebuild?

    index rebuilds are minimally logged and, if run for every single index in the DB, changes just about every extent...

    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 26, 2010 at 11:01 am

    #1242445

  • RE: need to change where claus

    If you want every single row in the table, take the where clause out completely. It's optional, doesn't have to be there.

    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 26, 2010 at 8:17 am

    #1242310

  • RE: How to kill a process in sql server

    lavien (10/26/2010)

    hix.., i can not know why.

    Well you need to investigate and find out. Can't just sit and hope the problem will go away

    Check the blocking, that would be my...

    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 26, 2010 at 6:57 am

    #1242216

  • RE: SQL Server 2008 (non-R2 version) question

    Brandie Tarvin (10/26/2010)

    And now it's time to start the upgrade discussion at my workplace. I think we might only be getting the regular version. I'd like to get R2 if...

    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 26, 2010 at 6:52 am

    #1242210

  • RE: How to kill a process in sql server

    Doesn't make any sense. What's blocking the backup?

    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 26, 2010 at 4:49 am

    #1242137

  • RE: MCITP 70-452 - any preparation materials?

    blase2 (10/26/2010)

    what are the exam Qs about in global ?

    Exam questions are under NDA (which anyone writing the exam accepts) and cannot be shared

    (ps: I am new in this forum,...

    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 26, 2010 at 4:18 am

    #1242125

  • RE: How to kill a process in sql server

    What's wrong with just taking a backup?

    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 26, 2010 at 4:09 am

    #1242121

  • RE: removal of SYS admin rights

    Ur, sysadmin is a fixed server role and can't be removed. Can you explain in a little more detail what you want to do?

    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 26, 2010 at 3:07 am

    #1242098

Viewing 15 posts - 29,716 through 29,730 (of 49,552 total)