SQL Clone
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
TheChrisMan
TheChrisMan
Old Hand
Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)

Group: General Forum Members
Points: 331 Visits: 337
If they have a tool that can search my entire 65,000+ table PeopleSoft database in mere seconds I want to see that.

Seriously, how can their product be faster than a well written TSQL query? Have you used it yourself and if so, can you describe how you compared the two methods?
Scott Arendt
Scott Arendt
SSCarpal Tunnel
SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)SSCarpal Tunnel (4.7K reputation)

Group: General Forum Members
Points: 4691 Visits: 1724
Of all the free search tools that have been provided to me today, SQL Search is by far the best.

I do want to thank Redgate for the freebies that they provide, both tools and books. Since the budget for such things that is given to me annually is, well, limited, these freebies help stretch my budget. :-D

Scott
Simon Galbraith
Simon Galbraith
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 44
Andy,
Yes we are considering how to make the most of this approach.
It might be a really great way to prototype and explore interesting ideas. Our next step is to give all of our technical staff a week to work on whatever they like at the end of March. They are already discussing ideas and forming teams - it's giving us all a buzz.
Simon



~Alex
~Alex
SSC-Addicted
SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)

Group: General Forum Members
Points: 435 Visits: 225
Obviously a database with 65,000+ tables is going to take longer than a few seconds... I don't work typically work with databases that large. Most of my work is integrating e-commerce websites & accounting software integrations, in which case both applications typically have 50-100 tables and a similar number of stored procedures and views.

For these small to medium-sized applications, I'm willing to sacrifice the negligible loss in performance for the rich UI & ability to quickly see relevant information for each item in the results. Everyone works different & given the way I work, this tool is of great value to me. I find that it boosts my productivity and since I bill hourly, that directly translates into more $! :-)

Ultimately, this is a productivity tool designed to plugin to the another productivity tool; SQL Server Management Studio. If I had to use scripts for all of the things I do in Management Studio, I would probably have another profession...

Out of curiosity, what would impress you in a SQL application that couldn't be done by simply running scripts? Correct me if I'm wrong, but everything in SQL is actually a script running in the background....
TheChrisMan
TheChrisMan
Old Hand
Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)Old Hand (331 reputation)

Group: General Forum Members
Points: 331 Visits: 337
Personally, I use scripting as often as possible, for several reasons. One is that it gives me total control over the process and two, I do it so I know what is going on "under the hood".

Dashboards impress me. Give me tools that can reveal a lot of interconnected information about performance. That's the kind of tool that I can do with scripts but is harder to implement.

A simple search tool doesn't do it for me. If a tool has a single function I can usually do it quicker with a script.
~Alex
~Alex
SSC-Addicted
SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)SSC-Addicted (435 reputation)

Group: General Forum Members
Points: 435 Visits: 225
chrism-787002 (2/3/2010)
... Dashboards impress me. Give me tools that can reveal a lot of interconnected information about performance. That's the kind of tool that I can do with scripts but is harder to implement. ...

I think SQL Server 2010 (or maybe it was 2008 R2) is going to support something like that, but with the ability to monitor multiple servers simultaneously.

I would imagine that you could build a pretty cool report/dashboard with SSRS to give you what you're looking for. Something to monitor an entire network on a single dashboard with the ability to drilldown into stats for each server. That would be pretty cool! Cool Especially if it could send alerts & respond proactively based upon customizable rules. Similar to a maintenance plan, only with a simpler interface to manage multiple SQL Servers across the network. That would probably need to be done with a dedicated tool though.
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