Forum Replies Created

Viewing 15 posts - 46 through 60 (of 92 total)

  • RE: CPU spike issue

    I always it's sqlserver.exe.  My cpu constanstly reaches 100% and caused slowness for my website.

     

    Minh Vu

  • RE: Insert data problem

    I really like to know to do the looping.  Can you give me an example?

  • RE: Insert data problem

    I don't have any relations on the tables, no insert triggers eithere. My server is good enough.  The think is I insert data from a link server.

    insert into [122.23.23.2].ed.dbo.product_inventory

    select *...

  • RE: Insert data problem

    My goal is to add an identity field so that I instruct my query to insert 1000 record at a time, but I don't know how. Please rescue me.

    Thanks,

    Minh Vu

  • RE: Shrink Db problem

    text data

  • RE: Shrink Db problem

    I did shrink the db by using dbcc, but the problem was my db did not got shrunk at all.

    Minh

  • RE: Syntax for Openquery

    Yes, you need to link the server before you can use open query.

    Minh

  • RE: Syntax for Openquery

    Yes, you can. I just figured out. I needed to put my ip in bracket:

    [172.2.24.5].  It worked for me.

    Thanks,

    Minh

  • RE: How to remove no owner table?

    Hi Sushila,

    I got

    username    table_name

    dbo

  • RE: Giving pain to DBA

    Another option is detach and attach your db, delete the ldf file, then attach your db.  This will automatically create a new log file.

    Hope that help.

     

    Minh

  • RE: xp_cmshell

    I tried that too, but it is not correct syntax.  I meant something like this.  set @cmd = 'copy F:\data_dump\emer\inventory.txt  @filename'

    But like I said, I couldn't put parameter in quotes.

     

    Minh...

  • RE: Split string into column

    Fantastic!

    I really appeciate your help!

    Minh Vu

  • RE: Rebuild indexes for all tables in all user dbs

    Thank you all.

    Minh Vu

  • RE: Clean up junk data

    Thank you so much for all of the input. The only problem I had is sp_msforeachdb. 

    When I run sp_msforeachdb myprocedure, the result occurred with the current db that I...

  • RE: Indexes Are Dropped for unknown reason

    I tried, but if the indexes dropped, the queries run a lot longer that can take 100% of CPU.  Therefore, when I turn on a trace, it even lows down...

Viewing 15 posts - 46 through 60 (of 92 total)