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 12»»

Turn off Predictive Typing Expand / Collapse
Author
Message
Posted Friday, November 12, 2010 3:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 7:34 AM
Points: 185, Visits: 4,332
Hi,

There does anyone know how to turn of the Predictive Typing feature in SQL Server 2008 and 2008 R2 when typing in a query analyser window

This has to be the worst feature i have ever seen, it now takes longer to type a piece of SQL as i keep having to correct what it assumed i wanted to type.

Thanks in advance for any help

Cheers,

Brunzire




Post #1019780
Posted Friday, November 12, 2010 3:11 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:05 AM
Points: 1,904, Visits: 2,842
It's called IntelliSense.
Check you SSMS Options.

"Worst feauture" ?


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1019781
Posted Friday, November 12, 2010 3:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 7:34 AM
Points: 185, Visits: 4,332
Thanks for the response i found an icon on the toolbar that allows me to turn it off.

Yes it is 'the worst' feature as some of us who use computers for a living have taught themselves to touch type. This combined with a sensible database naming convention means we do not need to be prompted with key words or column names when writing queries



Post #1019784
Posted Friday, November 12, 2010 3:33 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:05 AM
Points: 1,904, Visits: 2,842
Well, every one is entitled to their opinions, but I have to disagree.
IntelliSense is a great feature and cuts dev time in half over a long period for us who also type alot, and who have also been using computers daily for a long time....and dont want to type out schemaname.verylongtablenamewithunderscores.columname....

see?


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1019786
Posted Friday, November 12, 2010 4:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 13, 2013 4:35 AM
Points: 386, Visits: 211
For those of us who are in the habit of using s and i for column names it's a bit of a pain.



Cursors never.
DTS - only when needed and never to control.
Post #1019810
Posted Friday, November 12, 2010 4:58 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 42,771, Visits: 35,870
Personally I find the SSMS built in intellisense terrible. I spend more time fixing what it thought I meant than I would have spent just writing the query. A certain 3rd party vendor's intellisense however works very well, partially because there are pages of options that let me configure exactly how I want it to behave


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1019823
Posted Friday, November 12, 2010 5:01 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:05 AM
Points: 1,904, Visits: 2,842
GilaMonster (11/12/2010)
Personally I find the SSMS built in intellisense terrible. I spend more time fixing what it thought I meant than I would have spent just writing the query. A certain 3rd party vendor's intellisense however works very well, partially because there are pages of options that let me configure exactly how I want it to behave


I do agree on that certain 3rd party tool being better, I also use and prefer it to MS.
But at the end of the day, IntelliSense is better than NO IntelliSense...for me..


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1019825
Posted Friday, November 12, 2010 7:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 13, 2013 4:35 AM
Points: 386, Visits: 211
Usually goes something like

select s<space>
<delete the word>
s<space>
<delete the word>
s<space>
<delete the word>
s<right arrow>

The for anything within 15 mins I'll correct it on the first attempt. After a 15 min gap brain gets reset.



Cursors never.
DTS - only when needed and never to control.
Post #1019899
Posted Friday, November 12, 2010 7:15 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 42,771, Visits: 35,870
nigelrivett (11/12/2010)
Usually goes something like

select s<space>
<delete the word>
s<space>
<delete the word>
s<space>
<delete the word>
s<right arrow>


Exactly. I can write queries faster without the built-in intellisense. With the aforementioned 3rd party version, I have <space> disabled as a completion character so that unwanted completions don't happen.

I'd like the MS version more if there were any configuration options.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1019907
Posted Monday, November 12, 2012 10:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 9:17 PM
Points: 3, Visits: 15
Is there an option for sorting. When writing queries, often we will see tables with extended names being returned initially:-
ie "tbl_customer_reports" is returned before "tbl_customer" is viewable in the list.



Post #1383947
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse