Home Forums SQL Server 2008 SQL Server 2008 - General Searching Database tables for a specific value within a database field RE: Searching Database tables for a specific value within a database field

  • April 16, 2013 at 8:00 am

    #1606819

    Sean Lange (4/16/2013)

    Lowell (4/16/2013)

    Sean Lange (4/16/2013)

    jimoa312 (4/16/2013)

    ... DO NOT RUN THIS IN PRODUCTION!!!!!!!

    ...Run this ONLY ON A DEV/TEST server!!!!

    One last thing...did I mention that you should not run this in production???

    Happy hunting!!!

    you should probably mention he shouldn't run this on production 🙂

    😛

    One time somewhat recently when I posted this I suggested they don't run it in production. Then a day or so later I got a PM from the OP asking what to do because this thing was running and running and their production server was unable to process anything. Figured I would be a little over the top this time.

    Not over the top at all! This is one of those "learn from the experience of others" items they need to really be aware of.

    Something like this needs to be mentioned a little more than once; You PM from another poster proves it; any MillionBillowRow tables will eat up all the CPU and diskspace in temp just to provide the results.

    I've run this myself and seen it take hours when getting data to change the company web site from mycompany.net to mycompany.com.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!