Forum Replies Created

Viewing 15 posts - 5,371 through 5,385 (of 6,041 total)

  • RE: How to retrieve tables , sp's, views , functions related to a particular field?????

    RedGate has a free SSMS plugin called "SQL Search" that will do exactly what you want. I just tried it on one my databases; given the name of a column,...

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

  • RE: Match c++ / ado thead in app to sql spid

    jason craig-411431 (11/9/2011)


    Is there a dmv to query or some other method that I can use to tie my app's thread ids back to their corresponding spid?

    I can narrow down...

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

  • RE: Watching the Watchers

    http://godplaysdice.blogspot.com/2009/12/uniquely-identifying-people-by-birth.html

    ..Now Netflix is starting a second contest, and rumor has it that the data will include the zip code, birthdate, and gender of each individual. According to this paper ......

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

  • RE: Watching the Watchers

    People think about digital information differently than they do paper information. Thirty years ago, if a supermarket chain allowed a telemarketing company or government agency to troll through their cash...

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

  • RE: search and replace a string in all user tables’ data in all databases

    I'm trying to think of a situation where I would want to replace a string value across X varchar columns in X tables and X databases. This would imply that...

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

  • RE: License By Core

    IceDread (11/9/2011)

    ...As a side note I also prefer how Oracle handles null over sql server...

    Well, unlike SQL Server, Sybase, DB2, etc.; Oracle's implementation of NULL equality doesn't conform to ANSI...

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

  • RE: unexplained Performance difference in queries between UAT/Live database

    Claudie36 (11/8/2011)


    MY 2nd user experiencing response problems came back to me and it looks like it's the one table causing problems. My 2nd user also has a 'group by' on...

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

  • RE: License By Core

    IceDread (11/8/2011)


    The only advantage ms sql server has over oracle is it's price. Some would perhaps make an argument for the user interface as well. If ms sql server were...

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

  • RE: Going Green in Software Development

    We've talked about CPU and power usage at the server and network infrastructure level, but the bulk majority of utilization is at the client level. Stuff like Flash, Java, Silverlight,...

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

  • RE: Going Green in Software Development

    JJ B (11/7/2011)


    If you are interested in monitoring your electric usage, you may want to check out the following, The Energy Detective (TED) which I installed in my house. ...

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

  • RE: Going Green in Software Development

    P Jones (11/7/2011)


    Another great argument against the use of cursors - thanks!

    Indeed, rowset cursors are destroying the planet and a threat to mankind. It's time we stopped beating around the...

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

  • RE: Laptop Boy Scouts

    One technique the police could use to catch these guys is to get hold of a bunch of cheap non-functional laptops, install them with a GPS tracking device, and then...

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

  • RE: Identifying who took a database offline

    Don Bricker - Illinois (10/31/2011)


    We have a SQL Server 2008 instance in which someone took a database offline couple of weeks ago. I have identified the SPID from the Log...

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

  • RE: Stored procedure performance

    dm_tapas (11/1/2011)


    The below stored procedure is taking around 1 hours to execute. but it should not take this much time.

    Can some body tune this and tell me...

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

  • RE: Where are the good Senior Level DBA's?

    randy.worrell (11/1/2011)


    JamesMorrison (11/1/2011)


    Why are people complaining about the GUI for SQL Server? At least we have a GUI that actually works.

    Oracle DBAs are still complaining (for my entire 11 year...

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

Viewing 15 posts - 5,371 through 5,385 (of 6,041 total)