SQL Intellisense..

[stoymigo]

Hello
I would like to know whether you use intellisense for ms sql, basically I have trouble remembering whether a table ends in s or not, like requisition/requisitions and sometimes I don't remember the column names.
I deal with lots of tables/columns and sometimes new ones hence why I can't learn all table names.

The intellisense on sql 2008 is not that bad but I'm looking for something more responsive, just want to find out if there's anything you use that helps. Thanks

 

[Cool E]

using it

works like fine

 

[stoymigo]

I'll have to use it with sql 2000 mainly.
Which is why i don't get to use the intellisense in 2008

 

[poffle]

nope i just use the standard intellisense. mine is pretty damn responsive, no need for anything else really

 

[twicode]

If you'r using sql 2000 that has no intellisense you could use redgate's sql prompt.

 

[guest2013-1]

I'll have to use it with sql 2000 mainly.
Which is why i don't get to use the intellisense in 2008

You can't remember what your tables are called and/or if it ends in an s?

Time to normalize your tables dude (and use that memory for things OTHER than porn scenes you liked)

 

[semaphore]

You can't remember what your tables are called and/or if it ends in an s?

Time to normalize your tables dude (and use that memory for things OTHER than porn scenes you liked)

Instead of being arrogant why not read what he said? He deals with a lot of tables and columns, further more perhaps he has not say over naming convention standards?? Just a thought hey.

@Op - http://www.red-gate.com/products/sql-development/sql-prompt/

what twicode said.

 

[ToxicBunny]

Use it occasionally, when it works...

But I also do find it somewhat annoying at times when it autocompletes to things I don't want it to...

 

[FarligOpptreden]

I absolutely detest it. It makes the query window too slow. Besides, if you want quick access to a list of all objects in the database, just press Alt+F1. If you want to know the schema of a specific table, type it out, highlight it and press Alt+F1 again...

 

[InTheCube]

You can't remember what your tables are called and/or if it ends in an s?

Time to normalize your tables dude (and use that memory for things OTHER than porn scenes you liked)

You make so many assumptions, it's actually quite funny. Guess you've never worked on any enterprise or corporate systems, or inherited an existing project where changing a table name has huge consequences.

 

[stoymigo]

You can't remember what your tables are called and/or if it ends in an s?
Time to normalize your tables dude (and use that memory for things OTHER than porn scenes you liked)

Tables have lots of columns, 50-100 and I can't remember them all but
if I knew it partially then that's where the intellisense could help.
I already use ALT+F1, I guess I'll have to try the trial of the commercial products and see how that goes, if it's too slow then for sure it's time to memorize tables I often interact with.

 

[stoymigo]

I tried the tool today, and it's quite good.
If you type in the table name / column name it searches column names partially so it really helps if you don't
know the full name of a table/column.

That's only after using it for two hours so I haven't learned the shortcuts yet.
It's very fast, and works if your sever is sql 2000 although I'm interacting with it through using ssmstudio 2005.

I think it costs 200$, which I'm not convinced to pay for yet.

 

[SBSP]

My Intellisense sometimes takes a while to update, I dont rely that much tho.

this is what i normally do depending on what the task is, I make use of Copy and Paste transpose in excel where possible then back to Notepad from the "spec Integration File", and i open up a new tab in the SQL Enterprise Manger and select * from Which ever table or tables im working with and then use it as a reference. if your query is only reading from 3 or so tables then its not to bad.

 

[stoymigo]

My Intellisense sometimes takes a while to update, I dont rely that much tho.

this is what i normally do depending on what the task is, I make use of Copy and Paste transpose in excel where possible then back to Notepad from the "spec Integration File", and i open up a new tab in the SQL Enterprise Manger and select * from Which ever table or tables im working with and then use it as a reference. if your query is only reading from 3 or so tables then its not to bad.

So far it's more of a nice to have thing than a productivity booster.