Forum Replies Created

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

  • RE: Which exeutable file running behind the database?

    If i was an interviewer and i was given a chance to short list people I would not consider this question. I would not mind, as long as the candidate...

    March 8, 2009 at 5:24 pm

    #955744

  • RE: Database corrupted

    Paul Randal (3/8/2009)

    If you can run a DBCC CHECKDB and log backups successfully then I say that it looks like the db is clean.

    Make sure you do some root cause...

    March 8, 2009 at 10:58 am

    #955678

  • RE: dashboard of key performance monitor counters

    peace2007 (3/8/2009)

    Hi,

    Could anyone explain about dashboard of key performance monitor counters or give me a few reference articles about that? I couldn't find anything useful in the internet.

    check this...

    March 8, 2009 at 9:13 am

    #955668

  • RE: Help required Urgent...!!!

    Its taking nearly 1.5hrs to copy 1.6GB files to the US server drives. Can i do this copy backup files much faster from Chennai (INDIA) to US server. We are...

    March 8, 2009 at 9:09 am

    #955667

  • RE: Database corrupted

    Mani (3/7/2009)

    Thanks for all your help..

    Now I chaged the logbackup path and took the logbackup, everything fine.

    So i did not do anything afterthat.The database and application is running fine.

    thanks

    Mani

    Paul,

    My question...

    March 7, 2009 at 2:53 pm

    #955570

  • RE: Database corrupted

    GilaMonster (3/7/2009)

    Thanks Paul

    Awesome. I look forward to it.

    Awesome Gail two more for you to reach10,000 :w00t: good one, why don't you reply to make it 9999 and then one more...

    March 7, 2009 at 10:24 am

    #955502

  • RE: Database corrupted

    Great Paul,

    I as waiting on your reply too. I follow your blogs regularly about Corruption but did not find anything similar to this.

    So, as what I understand is that the...

    March 7, 2009 at 10:13 am

    #955497

  • RE: Performance Issues

    radek (3/7/2009)

    I can asked how did we find column to indexes?

    I know when you use "where" than is good to create index...for big table.

    And I read about...

    March 7, 2009 at 5:05 am

    #955442

  • RE: Performance Issues

    radek (3/7/2009)

    So I have another question.

    For find indexes column is better use DMV? or Profil?, of course I can create indexes where

    I use "word" where or order by..

    I...

    March 7, 2009 at 3:38 am

    #955434

  • RE: Nonlogged Operations

    California (3/6/2009)

    I have a database running on my SQL 2005 server. anytime a user enters data by select into, the transaction log grow to 100 GB. i was wondering, how...

    March 7, 2009 at 1:50 am

    #955423

  • RE: Performance Issues

    Rudy,

    Great, thanks for replying me.

    How about the DBCC UPDATEUSAGE?

    Just an inquiry please..:)

    March 6, 2009 at 12:17 pm

    #955185

  • RE: Performance Issues

    radek (3/6/2009)

    Maybe I wrote it not right, I know Rule of fragmentation 30%.

    I can ask Which way use DBA,or which way prefer: create maintenance plans, or other way...

    March 6, 2009 at 11:36 am

    #955150

  • RE: Performance Issues

    radek (3/6/2009)

    Hi there,

    which way is better to manage indexes (rebuilt,reorganization)?

    You really cant say which way is better. It depends on the level of fragmentation. The rule of thumb is ...

    March 6, 2009 at 10:44 am

    #955105

  • RE: Which exeutable file running behind the database?

    But, is it acceptable though to ask such a question at a DBA interview? or may be OP attended a system admin interview:P, anyways I would be blown out of...

    March 6, 2009 at 9:06 am

    #954981

  • RE: Which exeutable file running behind the database?

    ashok.nayak1 (2/26/2009)

    when an given an interview,one interviewer asked question like this:---

    Q:-[/b]When u open the Enterprise manager u find out the database...and u clik on that databases u see what...

    March 6, 2009 at 6:21 am

    #954812

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