Automatically reformat SQL Keywords to UPPER CASE

Is there a way to get SQL 2000 Query Analyzer or Visual Studio 2003 to
automatically re-format SQL keywords to upper case as you type?
I can do this in Ultra-Edit by editing an external file that contains all of
the keywords.
Thanks.Not uppercase specifically, you probably know this , but you can customise
keywords through the tools|options|fonts
For uppercase , check this:
http://www.aquafold.com/docs-qw-sqlformatter.html
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"SOG1" <SOG1@.discussions.microsoft.com> wrote in message
news:E3AB7C4C-7F22-4C42-9ABB-40D80AF5E820@.microsoft.com...
> Is there a way to get SQL 2000 Query Analyzer or Visual Studio 2003 to
> automatically re-format SQL keywords to upper case as you type?
> I can do this in Ultra-Edit by editing an external file that contains all
of
> the keywords.
> Thanks.|||I recently bought a license for PromptSQL, a tool that does just that along
with Intellisense, and works with several tools including Query Analyzer and
SQL Server Management Studio. A couple of ws ago, Red Gate Software bough
t
the product, renamed to SQL Prompt, and is currently in beta for release 3.
I'm not sure what you can get right now, but you can try www.promptsql.com,
or Red Gates site, www.red-gate.com to see.
HTH
Vern
"SOG1" wrote:

> Is there a way to get SQL 2000 Query Analyzer or Visual Studio 2003 to
> automatically re-format SQL keywords to upper case as you type?
> I can do this in Ultra-Edit by editing an external file that contains all
of
> the keywords.
> Thanks.

Automatic index (Statistics) vs Manually created indexes

Hi,
I noticed SQL Server, version 2000 in my case, automatically created indexes
(WA_Sys_... indexes) based on its query optimization functionality.
My question is; would my database performance increase if I created indexes
manually instead of depending on the (correct) created automatic indexes?
Erik
Hi
WA_ are not indexes, but statstics.
A real index is much better than statistics. A statistic is there to help
the query optimiser decide how to process a query, and not used for data
access.
http://www.sql-server-performance.com
Regards
Mike
"Erik Tamminga" wrote:

> Hi,
> I noticed SQL Server, version 2000 in my case, automatically created indexes
> (WA_Sys_... indexes) based on its query optimization functionality.
> My question is; would my database performance increase if I created indexes
> manually instead of depending on the (correct) created automatic indexes?
> Erik
>
>

Automatic index (Statistics) vs Manually created indexes

Hi,
I noticed SQL Server, version 2000 in my case, automatically created indexes
(WA_Sys_... indexes) based on its query optimization functionality.
My question is; would my database performance increase if I created indexes
manually instead of depending on the (correct) created automatic indexes?
ErikHi
WA_ are not indexes, but statstics.
A real index is much better than statistics. A statistic is there to help
the query optimiser decide how to process a query, and not used for data
access.
http://www.sql-server-performance.com
Regards
Mike
"Erik Tamminga" wrote:
> Hi,
> I noticed SQL Server, version 2000 in my case, automatically created indexes
> (WA_Sys_... indexes) based on its query optimization functionality.
> My question is; would my database performance increase if I created indexes
> manually instead of depending on the (correct) created automatic indexes?
> Erik
>
>

Automatic index (Statistics) vs Manually created indexes

Hi,
I noticed SQL Server, version 2000 in my case, automatically created indexes
(WA_Sys_... indexes) based on its query optimization functionality.
My question is; would my database performance increase if I created indexes
manually instead of depending on the (correct) created automatic indexes?
ErikHi
WA_ are not indexes, but statstics.
A real index is much better than statistics. A statistic is there to help
the query optimiser decide how to process a query, and not used for data
access.
http://www.sql-server-performance.com
Regards
Mike
"Erik Tamminga" wrote:

> Hi,
> I noticed SQL Server, version 2000 in my case, automatically created index
es
> (WA_Sys_... indexes) based on its query optimization functionality.
> My question is; would my database performance increase if I created indexe
s
> manually instead of depending on the (correct) created automatic indexes?
> Erik
>
>