Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Turbo for SQL Server Expand / Collapse
Author
Message
Posted Monday, May 23, 2005 2:35 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 8:32 AM
Points: 769, Visits: 256
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kKellenberger/turboforsqlserver.asp

Aunt Kathi
Microsoft
(Former SQL Server MVP)
Post #184629
Posted Wednesday, June 1, 2005 7:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:15 PM
Points: 31,210, Visits: 15,654
As an FYI, Turbo is powering the search at SQLServerCentral.com.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #186552
Posted Wednesday, June 1, 2005 9:36 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, February 14, 2006 9:14 AM
Points: 476, Visits: 1

I don't want to say that sql Turbo is a bad product, we are very happy with the speed, but found some issues with it:

- Memory management issues, as with everything using sp_OA... it runs in the "executable code" memory zone and not the "Memory pool". That forced us to buy more memory because Executable code memory zone has a fixed size (that could be set through a startup parameter) and increasing it reduced the buffer available for the "standard" queries with a negative impact on performances...

- Security issues (I like to remove sp_OA... from all my production servers)

- Troubles mixing standard sql indexes and Sql Turbo indexes...

- This forced us to created a Sql Turbo index on a bit column, resulting in "strange" behaviour.

Best Regards

Douglas

 

p.s. sorry for the bad English it's not my mother tongue




Post #186630
Posted Wednesday, February 13, 2008 1:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 26, 2014 11:35 AM
Points: 7, Visits: 33
Has anyone any idea what's happened to SQL Turbo? It appears that Quest (who were distributing it) have wiped all mention of it from their website.

Frustrating, as we're using SQL Turbo on a server, and I was looking at the options for running SQL Turbo on a dedicated server, as we've found that the rebuilding of the indexes is sucking performance from the database server. It appears you need a separate version (SQL Turbo Server) for this, but it's disappeared from sight.

Any other suggestions?
Post #454888
Posted Wednesday, February 13, 2008 8:14 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 8:32 AM
Points: 769, Visits: 256
Have you tried contacting the company?

Aunt Kathi
Microsoft
(Former SQL Server MVP)
Post #455100
Posted Wednesday, February 13, 2008 8:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 26, 2014 11:35 AM
Points: 7, Visits: 33
Yes, since my post I've been doing some more digfging, and have been in contact with Quest, who bought Imceda.

It transpires that they have "sunsetted" the product, and no longer sell it.

However they have passed my query on to techie so maybe I'll get some assistance.
Post #455110
Posted Wednesday, May 14, 2008 9:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 24, 2009 8:05 AM
Points: 4, Visits: 16
As Quest have pulled the plug on SQL Turbo are you likely to reconsider a new index service provider?

I really liked Turbo and was waiting for a 64 bit release, which will now never come.
Post #500631
Posted Wednesday, May 14, 2008 9:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 26, 2014 11:35 AM
Points: 7, Visits: 33
Well for the moment it's doing its job, so I'll continue using it. Maybe the "enhanced" features on SQL2008 or whatever will make it redundant? Who can tell.
Post #500648
Posted Wednesday, May 14, 2008 9:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 24, 2009 8:05 AM
Points: 4, Visits: 16
I hope sql2008 iFTS has some good features too.

When using Turbo it can return total number of matches found extremely quickly even searching millions of rows. I struggle to see how SQL using fts will be able to do this without having to return back all the rows in the query and then counting them etc. I hope Microsoft will prove me wrong but i'm not holding up much hope.

I did find on the web that Microsoft have purchased a Scandinavian Enterprise class search tool so may be they will bring this in line in a few years.



Post #500661
Posted Wednesday, May 14, 2008 10:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 26, 2014 11:35 AM
Points: 7, Visits: 33
Yes, the "page at a time" features of SQLTurbo are great, aren't they.
Post #500677
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse