Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 6,041 total)

  • RE: Today's Random Word!

    Ed Wagner (3/17/2014)


    Eric M Russell (3/17/2014)


    inauguration

    Start

    dissonance

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Today's Random Word!

    inauguration

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Transaction timeout happening on inserting huge data

    Even on a low end server, it shouldn't take 10 minutes to insert 90,000 rows into one table and 5,000 rows into another one. I suspect what's holding it up...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: getting results from all tables in database

    navie (3/13/2014)


    ...

    I need to get result from all the tables and all the columns which has bad data including schemaName, table name and column name in result.

    thanks,

    I work with...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Read and Write speeds not increased with additional disks.

    william.rees.howells (3/13/2014)


    Does anybody know why I see absolutely no performance improvement when I spread my primary file group over 8 separate files on 8 separate disks, as opposed to...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: I need to delete 20 million rows from a table...

    humbleDBA (3/14/2014)


    Eric M Russell (3/13/2014)


    Siberian Khatru (3/12/2014)


    I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: I need to delete 20 million rows from a table...

    Siberian Khatru (3/12/2014)


    I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of the data in it anymore...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Insert Statement for 2 million rows

    Jeff Moden (3/13/2014)


    Eric M Russell (3/13/2014)


    pretea (3/13/2014)


    Hi!

    I have multiple (individual) insert statement to insert around 2 million rows (using sqlcmd because the insert stament is around 8 thou lines).

    It took...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Insert Statement for 2 million rows

    pretea (3/13/2014)


    Hi!

    I have multiple (individual) insert statement to insert around 2 million rows (using sqlcmd because the insert stament is around 8 thou lines).

    It took about an hr to insert...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: #sqlhelp

    I've never actually used Twitter, but it seems to me that if the question can be expressed in 140 characters or less, then the answer could probably by found quicker...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: SSIS Package to retrieve database information across different servers?

    It depends on what automation and instrumentation method you're wanting to inegrate with.

    It will require some programming, but PowerShell is typically used for what you're asking. This is perhaps...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Developers, developers, developers

    While most of this audience aren't in the development space, some may be, and the impacts of the results could certainly affect our careers.

    Odd, I would expect the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Pls let me know how to add image..thanks

    koti.raavi (3/10/2014)


    ...

    At the end of the test, you will be expected to demonstrate your code, and discuss the design, implementation, limitations, and potential future enhancements.

    That's funny. 😛

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Import Outlook folder or PST into SQL?

    It's been a long time ago, but I vaguely recall using LINQ (or OLEDB directly) to query data from Outlook.

    http://thedatafarm.com/data-access/using-linq-to-query-outlook-emails-joined-with-sql-data/

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Most used Index

    Ratheesh.K.Nair (3/10/2014)


    Hi Experts,

    Is there anyway to find the most used indexes in a DB?

    This little DMV ditty should to the trick.

    select

    object_name(s.object_id) as obj_name,

    ...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 4,666 through 4,680 (of 6,041 total)