hariprasadseo5
Follow / 31 Jan 2018 at 2:23pm / Toad for SQL Server
Latest post by on 13 Feb 2018 at 5:31pm

Toad format sql statement in one row

Expand content
Hi, How can I change the formatter in toad or maybe sql developer to format my sql statements automatically in one row statement. Here one Example: This is my start which I wanna to format. BEGIN...

Hi,

How can I change the formatter in toad or maybe sql developer to format my sql statements automatically in one row statement.

Here one Example: This is my start which I wanna to format.

BEGIN
    db_package.drop_table ('test');
END;

CREATE TABLE mytable
(
    Column                     VARCHAR2 (1 CHAR)
);
...

This is my goal formatted statement.

BEGIN    db_package.drop_table ('test');END;
CREATE TABLE mytable(    Column                     VARCHAR2 (1 CHAR));
...

So I want to format the statements so that I get every statement in one row.

Thank You

Hari

1677 1 / Create an account to join the discussion.
jamunozs
Follow / 29 Jan 2018 at 3:10pm / Toad for SQL Server

Optimizer toad for sql server

Expand content
Buenos días recién instale una nueva versión de toad la 6.8 y me encontré con algunos inconvenientes 1 tuve que instalar por separado el optimizador 2 al usarlo desde el ambiente...

Buenos días recién instale una nueva versión de toad la 6.8 y me encontré con algunos inconvenientes 1 tuve que instalar por separado el optimizador 2 al usarlo desde el ambiente de toad me marca este error sql optimizer is not installed a pesar de que esta instalado y de que si lo ejecuto independientemente funciona

Ojala que puedan ayudarme

Saludos 

1008 0 / Create an account to join the discussion.
eddiesutton
Follow / 8 Jul 2017 at 8:05pm / Toad for SQL Server
Latest post by on 9 Jul 2017 at 7:54pm

SQL Server 2008 R2

Expand content
I am using SQL Server 2008 R2. Everything was running fine until it recently stopped running for no real apparent reason. The error message occurs: Sql Server Detected A Logical Consistency-Based I/O...

I am using SQL Server 2008 R2.

Everything was running fine until it recently stopped running for no real apparent reason. The error message occurs: Sql Server Detected A Logical Consistency-Based I/O Error: Incorrect Checksum. (Microsoft SQL Server, Error:824) Please how do i correct this error.

Regards.

2466 1 / Create an account to join the discussion.
colink
Follow / 22 Apr 2017 at 3:27pm / Toad for SQL Server
Latest post by on 24 Apr 2017 at 3:16pm

Connection Settings for MySQL on AWS EC2

Expand content
Forgive me if this is easily found somewhere else. I cannot find a Forum search, only a global site search that does not help me. I am assuming I need to use SSL settings to connect to my AWS EC2 MySQL...

Forgive me if this is easily found somewhere else. I cannot find a Forum search, only a global site search that does not help me.

I am assuming I need to use SSL settings to connect to my AWS EC2 MySQL DB

Toad requires:

Connection type = SSL
Host = I asssume this is the Public dns eg ec2-52-42-00-000.us-west-2.compute.amazonaws.com
User =
Database =
Password =
Port = 3306?
Private Key = PEM or PPK ?
CA Cert = what / where do I find
Cert = what / where do I find

Is SSL the correct protocol?

Do I need to add my IP somewhere on the EC2 Dashboard?

Thanks ColinK

2673 2 / Create an account to join the discussion.
Danny Torres
Follow / 1 Nov 2016 at 1:59pm / Toad for SQL Server

We are now on Twitter!!! Contact a Technical Support expert today...

Expand content
Do you have a quick support question and short of time? Contact us Via Twitter @ QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

Do you have a quick support question and short of time? Contact us Via Twitter  @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest

1785 0 / Create an account to join the discussion.
Mark Freeman
Follow / 19 Nov 2015 at 10:43pm / Toad for SQL Server
Latest post by on 23 Nov 2015 at 4:01pm

How can I get SQL Optimizer to use snapshot isolation

Expand content
Because of dramatic differences between my test and production environments (amount of RAM and number of cores), I want to optimize a SELECT statement by connecting to my production server. But to avoid...

Because of dramatic differences between my test and production environments (amount of RAM and number of cores), I want to optimize a SELECT statement by connecting to my production server. But to avoid causing blocking, I want SQL Optimizer to do all its work in snapshot isolation. I have the database set to allow it, but that is not the default.

SQL Optimizer won't let me precede the SELECT statement with "SET TRANSACTION ISOLATION LEVEL SNAPSHOT;".  How can I configure SQL Optimizer to use snapshot isolation when executing my very long running SELECT the many dozens of times that it will need to test the optimization permutations?

6100 2 / Create an account to join the discussion.
nbarnard
Follow / 6 Oct 2015 at 3:26pm / Toad for SQL Server
Latest post by on 7 Oct 2015 at 10:32pm

Database, Date Collected, Time collected are grayed out on Optimize...

Expand content
Hello, I am trying to optimize indexes on an instance. All of the options for the selected server are grayed out. This is version 9.5. I am trying to pull from the SpotlightStatisticsRepository. I...

Hello,

I am trying to optimize indexes on an instance. All of the options for the selected server are grayed out. This is version 9.5. I am trying to pull from the SpotlightStatisticsRepository. I am an admin on both servers. The instance is actually a virtual instance for a cluster. However, I change to other servers that are not and the say results occur.  An error shows that says "There isn't date collected in current select criteria." All the other options are grayed out though.  Any thoughts?

Unanswered 6358 2 / Create an account to join the discussion.
bpcatt1
Follow / 8 Jun 2015 at 8:48pm / Toad for SQL Server
Latest post by on 15 Jun 2015 at 1:10am

SQL Optimizer cannot connect to any server??

Expand content
Hello all, I have tried to connect to four different servers now with no joy from SQL Optimizer for SQL Server 10.0.1 Trial Edition (I am attempting to evaluate the software, but it isn't looking...

Hello all, 

I have tried to connect to four different servers now with no joy from SQL Optimizer for SQL Server 10.0.1 Trial Edition (I am attempting to evaluate the software, but it isn't looking good at this point).  I can connect to the servers via SSMS and Toad.  SQL Optimizer display an error window with no text whenever I try to log in using my Windows credentials and Windows authentication as well as both sets of administrator credentials via SQL authentication.  

Has anyone ever experienced this issue before and have  solution?  I searched the forums here and on Dell's website to no avail.

9822 4 / Create an account to join the discussion.
Mark Freeman
Follow / 2 Apr 2015 at 6:00pm / Toad for SQL Server
Latest post by on 3 Apr 2015 at 4:58am

Cursor and Parameter Settings tab in the Optimize SQL window (SQL...

Expand content
I have copied a SELECT statement from a stored procedure into the Optimize SQL window. I now want to set the values for the parameters (bind variables in Oracle lingo). I can't find the tab that is...

I have copied a SELECT statement from a stored procedure into the Optimize SQL window. I now want to set the values for the parameters (bind variables in Oracle lingo). I can't find the tab that is described in the Help. Of course, no screen image is included in the help. Another area of the help says to just click on the auto optimize icon, implying that it will then prompt for the values, but that doesn't happen. The status goes to "Checking bind variables" and after an hour, it is still in the same status.

How can I enter values for the parameters needed by my SELECT statement?

13478 1 / Create an account to join the discussion.
EDavies
Follow / 20 Mar 2015 at 11:55am / Toad for SQL Server
Latest post by on 20 Mar 2015 at 5:32pm

Loop around a temp table and insert into main table

Expand content
I have a temp table with 4 columns, serial number,date , number of defects,inspector. From that row I would like to insert into the main table x row where X is the number of defects. e.g Temp Table...

I have a temp table with 4 columns, serial number,date , number of defects,inspector. From that row I would like to insert into the main table x row where X is the number of defects.

 

e.g Temp Table

Serial Number, Date, Number of defects, Inspector

AAA, 20/03/2015,4, ED

AAB, 20/03/2015,3,JOE

e.g MainTable

Serial Number, Date, Inspector

AAA, 20/03/2015, ED

AAA, 20/03/2015, ED

AAA, 20/03/2015, ED

AAA, 20/03/2015, ED

AAB, 20/03/2015,3,JOE

AAB, 20/03/2015,3,JOE

AAB, 20/03/2015,3,JOE

Any ideas??

Unanswered 14131 1 / Create an account to join the discussion.
tbrown10
Follow / 17 Jun 2014 at 9:29pm / Toad for SQL Server
Latest post by on 18 Jun 2014 at 10:19am

Optimze SQL link always greyed out in Spotlight For SQL Server

Expand content
When Using spotlight for SQL Server I go to the SQL activity page and no matter which session I click on the Optimize SQL Link/Button is always greyed out so I can not click on it. Any ideas?

When Using spotlight for SQL Server I go to the SQL activity page and no matter which session I click on the Optimize SQL Link/Button is always greyed out so I can not click on it.  Any ideas?

Unanswered 15230 1 / Create an account to join the discussion.
ian.rankin
Follow / 14 May 2014 at 9:58am / Toad for SQL Server
Latest post by on 15 May 2014 at 8:58am

Orphaned Virtual Indexes

Expand content
Hi, Has any one heard of and know a fix for SQL Optimizer leaving behind a phantom index definition in the database. I have been using the tool to tune for a few months now (against copy production databases...

Hi, Has any one heard of and know a fix for SQL Optimizer leaving behind a phantom index definition in the database. I have been using the tool to tune for a few months now (against copy production databases). We have found that on occasion when the tuning activity has suggested that a new index be created (as far as I understand a 'virtual' index is created) on leaving the tool there is still a 'ghost' of that index in the database. As far as we can determine it consists of a record in the dba_objects view, but cannot be seen in the dba_views view ! I have not yet been able to get this to occure on our development databases. Any ideas though much appreciated.

15701 3 / Create an account to join the discussion.
Kelvin Lai
Follow / 2 Nov 2012 at 9:46am / Toad for SQL Server
Latest post by on 10 Dec 2013 at 10:54am

Quest SQL Optimzier for SQL Server Version 8.5.0 has been released...

Expand content
Hi Everyone, SQL Optimizer for SQL Server version 8.5.0 is now available. In this release, we add a brand new module, Optimize Indexes. It analyzes a SQL workload or any group of SQL statements and determines...

Hi Everyone,


SQL Optimizer for SQL Server version 8.5.0 is now available.


In this release, we add a brand new module, Optimize Indexes. It analyzes a SQL workload or any group of SQL statements and determines the best index set for the workload or group of statements.  Some of the user interface also enhanced and has a better support for SQL Server 2012.


- Previous versions have supported optimizing only one SQL statement at a time. You can now input multiple SQL statements for optimization.
- Optimizer now able to automatically detects bind variable data type and it's value as well as undefined tempoaray tables referenced in a SQL statement. 
- When generating indexes for a SQL, the engine now considers all the tables referenced inside a view.

We are looking forward to hearing your feedback. Please feel free to download our trial version and have a try.

Thanks,
Kelvin

15886 1 / Create an account to join the discussion.
Kelvin Lai
Follow / 17 Jun 2013 at 3:46am / Toad for SQL Server
Latest post by on 10 Dec 2013 at 8:16am

Quest SQL Optimzier for SQL Server Version 9.0.0 Released

Expand content
Hi Everyone, SQL Optimizer for SQL Server version 9.0.0 is now available. In this release, we add a brand new module, Find SQL. It helps you locate the most resource-intensive SQL in your server by...

Hi Everyone,

SQL Optimizer for SQL Server version 9.0.0 is now available.

In this release, we add a brand new module, Find SQL. It helps you locate the most resource-intensive SQL in your server by extracting from SQL Server Plan Cache. It evaluates existing SQL performance by different statistics (such as CPU Time and Elapsed Time) from different areas (such as Top N SQL statements, Top N SQL Batches and Top N Database Objects). Different queries extraction sources will be added in the future releases. So please stay tuned Smile

Microsoft has introduced the Contained Database (CDB) feature in SQL Server 2012. To support this new feature, we have enhanced our connection manager to support the Contained Database login. The Optimization engine has also been upgraded so that SQL Optimizer recognizes and handles the new CATALOG_DEFAULT collation.

We are looking forward to hearing your feedback. Please feel free to download our trial version and let us know you think about this new release.

Thanks,

Kelvin

17305 1 / Create an account to join the discussion.
budi.yulianto
Follow / 12 Jul 2013 at 7:10pm / Toad for SQL Server
Latest post by on 22 Jul 2013 at 10:31am

Quest SQL Optimzier for SQL Server Ver.9.0 issue

Expand content
After I installed Quest SQL Optimzier for SQL Server Ver.9.0 issue, I get this message whenever I open SSMS - "TypeLoadException: Could not load type 'Microsoft.SqlServer.Management.SqlStudio...

After I installed Quest SQL Optimzier for SQL Server Ver.9.0 issue, I get this message whenever I open SSMS  - "TypeLoadException: Could not load type 'Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService'...".

Has anyone had the same issue like this?

Could you share with me how to fix it?

Thanks!

Answered 18517 8 / Create an account to join the discussion.
dave.blohm
Follow / 12 Jun 2013 at 4:59pm / Toad for SQL Server
Latest post by on 12 Jun 2013 at 5:18pm

Probably the most basic question of all...

Expand content
Since a conversation with a DBA friend of mine, I've been beating myself up trying to find where I get my hands on Query Optimizer for SQL Server. Where does one obtain the software? Thanks in advance...

Since a conversation with a DBA friend of mine, I've been beating myself up trying to find where I get my hands on Query Optimizer for SQL Server. Where does one obtain the software?

Thanks in advance.

Answered 15795 1 / Create an account to join the discussion.
Levin Peng
Follow / 24 May 2012 at 10:47am / Toad for SQL Server
Latest post by on 16 Nov 2012 at 9:45am

New Rules for Quest® SQL Optimizer for SQL Server 8.0

Expand content
http://toadworld.com/Blogs/tabid/67/EntryId/900/New-Rules-for-Quest%c2%ae-SQL-Optimizer-for-SQL-Server-8-0.aspx
17922 2 / Create an account to join the discussion.
john_093
Follow / 19 Dec 2011 at 4:45pm / Toad for SQL Server
Latest post by on 14 Sep 2012 at 4:43am

Default Schema not available

Expand content
Whenever I try to optimize a statement, I get the error: Default Schema not available. What causes this and how do I resolve it?
Whenever I try to optimize a statement, I get the error: Default Schema not available. 

What causes this and how do I resolve it?
26813 3 / Create an account to join the discussion.
kdooley_984
Follow / 31 Aug 2012 at 9:10pm / Toad for SQL Server
Latest post by on 3 Sep 2012 at 6:06am

Using Temp Table Variables

Expand content
Hi I am trying to optimize some procs that use temp table variables. It is very easy I see to use regular temp tables but I cannot get it to work with temp table variables.

Hi I am trying to optimize some procs that use temp table variables.  It is very easy I see to use regular temp tables but I cannot get it to work with temp table variables.

15752 1 / Create an account to join the discussion.
clee_671
Follow / 23 Sep 2011 at 3:38pm / Toad for SQL Server
Latest post by on 30 Sep 2011 at 5:19am

Tune SP with Apply statement

Expand content
I'm trying to tune a stored procedure that has outer apply and cross apply in it and I am getting the invalid SQL statement message. When I take the apply statements out it works fine. Can the optimizer...

I'm trying to tune a stored procedure that has outer apply and cross apply in it and I am getting the invalid SQL statement message.  When I take the apply statements out it works fine.  Can the optimizer do apply statements?

17452 1 / Create an account to join the discussion.