Forum Replies Created

Viewing 7 posts - 106 through 113 (of 113 total)

  • RE: Cannot defrag indexes

    No of course shrinking the data files ends in fragmented indexes.

    Pooyan

  • RE: Shrinking DB not working

    I know that .shrinking the data file uses a lot of log space.

    Pooyan

  • RE: Shrinking DB not working

    Do you have enough space in your log file? does the drive your log file is located have enough space for log file growth? shrinking logs a lot of things

    Pooyan

  • RE: Exam 70-451

    I just past the exam today with 900 from 1000 which I didn't think I would be able.

    It was 55 test and we had 130 minutes to take the test.There...

    Pooyan

  • RE: OLEDB waittype With Linked server

    There was a Network related problem.It's ok right now.thank u all especially you jim

    pouyan

    Pooyan

  • RE: OLEDB waittype With Linked server

    I updated the statistics on all related tables but nothing changed. The main query is like this: select feild1,field2,... from T1 inner join T2 on T1.key=T2.key inner join T3 on...

    Pooyan

  • RE: OLEDB waittype With Linked server

    I forgot to tell this query was working fine until 2 days ago but all of the sudden it takes 20 second to be executed.

    Two tables are being join together...

    Pooyan

Viewing 7 posts - 106 through 113 (of 113 total)