Forum Replies Created

Viewing 15 posts - 226 through 240 (of 447 total)

  • RE: Annoying NULLs

    I doubt if I can one day master the use of " NULL ". No matter how much I try to understand it, there always something left.

    Well, " NULL...

  • RE: Troubleshooting

    CoetzeeW (4/2/2009)


    Great Article, Since most DBA's responsiblity is supporting\troubleshooting such a complex product like SQL server you have highlighted a good methodology and approach to problem solving, Thanks ! 😉

    Excellent...

  • RE: Tip for determining I/O Heavy Queries

    Good article, Solomon. Will try to implement it on our siebel server. Siebel with SQL server ! ! ! is like a deadly combination. Performance had...

  • RE: TSQL

    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.1 (Build 2600:...

  • RE: Transactions

    h84liang (3/19/2009)


    dear Friends,

    i have testing this question and return all values (1,2,3) if i execute it 😀

    thx

    Dude, read question correctly. It say's execute it in another window and not...

  • RE: Transactions

    Good question. I didn't read it correctly and executed in same window. Which gave me 1,2,3 but after it got wrong, then tried it in another window and...

  • RE: Identity puzzle

    Got 3 points ! ! ! What a fluke. But I still was not able to understand reseed issue.

  • RE: SQL Jobs script

    pobeda (2/19/2009)


    well, I knew that 🙂 i am askin if there is a way to do all of them at once?

    ooops.... I missed " individual " from your question.

  • RE: SQL Jobs script

    Enterprise Manager -> management -> jobs right click select all task and under it generate sql script.

  • RE: Deleting Table taking very long time

    Another way could be set your index to use row lock. SQL Server is by default is set to page lock. By doing this you will have very...

  • RE: Deleting Table taking very long time

    your attached file give error while downloading.

    The following error occurred...

    Sorry the application encountered an unexpected error. Information about this error has been logged. If you continue to receive this message...

  • RE: Activity Monitor in SQL 2005 but not in SQL 2008

    Laura Schmalzbauer (2/19/2009)


    In the Object Explorer, when you connect to a server there is an Activity Monitor under the Manager folder in SQL 2005. However, there isn't this option...

  • RE: Organizational tools that can help you be a better DBA

    Good list for all those who use Firefox but nothing here for a DBA or Developer.

    Thanks though.

  • RE: Help, my database is corrupt. Now what?

    Good article Gail. Very descriptive. It would be in my briefcase.

  • RE: MCTS 70-431 [2005]

    If you already got SQL Server 2000 MCDBA certification then you have to take 70 - 431 and 70 - 447 to upgrade it to MCITP.

    Note here that 70 -...

Viewing 15 posts - 226 through 240 (of 447 total)