Any way to turn OFF tooltips in SSMS?

Generally, I like tooltips but when I'm reviewing the nightly jobs (Sql Server Agent > Jobs > View History) I find that they obsure the very status line I want to read! After a couple of months of this it's getting annoying. Is there a keyboard shortcut, or other approach, that can be used to temporarily (permanently?) disable ToolTips?

TIA,

Barkingdog

Right-click in the grey area next to your icons, point to Customize and then de-select the "Show Screen Tips on Toolbars".

If this answers your question, make sure to mark it "answered" so others can find it quickly.

Buck Woody

|||

>> right-click in the grey area next to your icons....

I couldn't get it to work for me when I was looing at the results of the nightly job runs. Can you please clarify which icons you were referring to and where exactly in SSMS I can find them?

TIA,

barkingdog.

|||Sure -Open SSMS and look for any grey area next to the icons in the icon bar at the top. Right-click in that grey area, and then select "Customize" from the menu that appears. You'll see the option to select towards the bottom of the panel that shows up.

Any way to turn OFF tooltips in SSMS?

Generally, I like tooltips but when I'm reviewing the nightly jobs (Sql Server Agent > Jobs > View History) I find that they obsure the very status line I want to read! After a couple of months of this it's getting annoying. Is there a keyboard shortcut, or other approach, that can be used to temporarily (permanently?) disable ToolTips?

TIA,

Barkingdog

Right-click in the grey area next to your icons, point to Customize and then de-select the "Show Screen Tips on Toolbars".

If this answers your question, make sure to mark it "answered" so others can find it quickly.

Buck Woody

|||

>> right-click in the grey area next to your icons....

I couldn't get it to work for me when I was looing at the results of the nightly job runs. Can you please clarify which icons you were referring to and where exactly in SSMS I can find them?

TIA,

barkingdog.

|||Sure -Open SSMS and look for any grey area next to the icons in the icon bar at the top. Right-click in that grey area, and then select "Customize" from the menu that appears. You'll see the option to select towards the bottom of the panel that shows up.sql

Any way to easily add this computed column (divide by zero problem)

I have this query that I would rather not turn into a stored proc.
because the client really has no budget. I was hoping there would be a
way to add this statement inline to the following sql with some kind of
IF statement without writing it all out. The problem is either total
cost or conversions will have some zeros in the table.

SUM([total cost]/[cost per conversion])

Any help would be appreciated - Happy New Year

SELECT [Search Term], SUM([total cost]/[cost per conversion]) as calcw,
SUM([impressions]) AS impress, SUM([Total Cost]) AS totalcost,
SUM([Total Clicks]) AS totalclicks, SUM(Conversions) AS totalconv,
SUM([Cost Per Conversion]) AS costconv FROM csv where [start date]
>='01/01/04' and [end date] <='12/31/04' GROUP BY [Search Term] ORDER
BY [Search Term] ASCDo you just want to ignore the row in the sum if either value is zero? If
so:

SUM([total cost]/NULLIF([cost per conversion],0))

--
David Portas
SQL Server MVP
--|||I would rather the row be included as just returned as zero

Thanks!|||Also I tried that statement and it works well except I think the
calculation comes out incorrect - It needs to be something like the
SUM of total cost divived by the SUM of Conversions.

Thanks|||COALESCE( SUM([total cost]) / NULLIF(SUM([cost per conversion]),0) ,0)

--
David Portas
SQL Server MVP
--|||Thank you very much David - That seems to have done it!
Thanks again...