Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Too Good to be True? The Story Behind SQL Search


Too Good to be True? The Story Behind SQL Search

Author
Message
Simon Galbraith
Simon Galbraith
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 44
Comments posted to this topic are about the item Too Good to be True? The Story Behind SQL Search



Ells
Ells
Right there with Babe
Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)

Group: General Forum Members
Points: 788 Visits: 931
Many thanks for the editorial I particularly enjoyed the The official story vs The unofficial story part.

This brought back memories of working for an organisation. They had a revolutionary new product which was one managers project from concept to conclusion. He was very strong technically and could unravell the product from top to bottom just from memory. He was provided with one member of staff to help him run the project.

The reason for the help soon became clear. One was the genius who could do it all in his head but poor organisation skills. The helper was a fantastic organiser. Between the two of them they guided and managed the project fantastically. Neither encroached into the others territory and it ran like a dream. People may have attributed the success to one or other of the two but for me it was the combination of the two together.

Mark.
OCTom
OCTom
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2813 Visits: 4152
Interesting story. What type of personalities would work well in this environment? What would prevent some team member from hanging out at the beach the whole time? I would refuse pizza and would need to have some other nourishment and what about regular exercise? What are the ages of the participants? Was anyone over 50? Or, were these all young folks who can live on pizza and Mountain Dew with little sleep?

It's only a week, though. Maybe I could stomach pizza for that long. Sick
Ells
Ells
Right there with Babe
Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)

Group: General Forum Members
Points: 788 Visits: 931
I think the gains in productivity are short term gains. In addition the comparison gets distorted due to the different quality controls.
I have worked long and short hours. Currently I am definately in the Pizza and all hours area. Doing regular 70 hour weeks which is not productive (not as productive as doing two 35 hour weeks), and not sustainable.

Just doing it while its there for the taking.
Mark.
Andy Warren
Andy Warren
SSCertifiable
SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)SSCertifiable (7.2K reputation)

Group: Moderators
Points: 7231 Visits: 2679
An interesting journey, and good to see that expected lessons hold up. Lots of value in building a prototype, lots of value in having some kind of process to build a solid application. I'm curious if you'll launch future projects in a similiar way?

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
webooth
webooth
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 Visits: 580
Is this Simple-Talk?



Scott Arendt
Scott Arendt
SSCarpal Tunnel
SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)SSCarpal Tunnel (4K reputation)

Group: General Forum Members
Points: 4048 Visits: 1702
I think that the interesting part is that so much could be accomplished in such a short amount of time. Forget about the fact that it is unsustainable for now. This group took on a challenge, worked long hours, and at the end of the week were about to demonstrate a working prototype. That is pretty amazing.

Of course this kind of work week is not sustainable. We have family, friends and hobbies that take up our time.

But the fact is, during crunch time, much can be accomplished.

Scott
TheChrisMan
TheChrisMan
SSC Veteran
SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)SSC Veteran (277 reputation)

Group: General Forum Members
Points: 277 Visits: 337
I'm unimpressed. I wrote a simple TSQL script to search for text strings across all tables in a database and it took a lot less than a week.

This is a large problem with most businesses. They spend time and energy convincing us that we need tools when we already have all the tools at our disposal.
Ells
Ells
Right there with Babe
Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)Right there with Babe (788 reputation)

Group: General Forum Members
Points: 788 Visits: 931
chrism-787002 (2/3/2010)
This is a large problem with most businesses. They spend time and energy convincing us that we need tools when we already have all the tools at our disposal.


I don think the problem is that companys build tools that you may not need. The issue in my eyes is there weere a lot of comapnys buying tools \ software without thinking about if it could be done free or low cost or even how they could justify it financially.

Mark.
~Alex
~Alex
SSC-Enthusiastic
SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)SSC-Enthusiastic (191 reputation)

Group: General Forum Members
Points: 191 Visits: 224
chrism-787002 (2/3/2010)
I'm unimpressed. I wrote a simple TSQL script to search for text strings across all tables in a database and it took a lot less than a week.

This is a large problem with most businesses. They spend time and energy convincing us that we need tools when we already have all the tools at our disposal.

Why bother with SSMS if you can do everything from the command line? Simple, usability! Instead of having to run a script manually whenever you want to search for something, now we have a brilliant tool that allows us to quickly & easily search an entire SQL Server in mere seconds. Plus, the results are MUCH nicer to work with in the interface as opposed to a simple table of results.

All in all, I find the product very useful & WAY faster than editing a script manually to search for objects. I don't know about you, but for me, time is money & this is gold! :-)

Congrats to the product team & thank you to Red Gate for providing this product to the community for free!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search