<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://msmvps.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Ctrl+1 in SSMS for sp_who, plus more</title><link>http://msmvps.com/blogs/robfarley/archive/2008/08/08/ctrl-1-in-ssms-for-sp-who-plus-more.aspx</link><description>I did this by accident, but turns out it&amp;#39;s a really useful feature. I was just trying to zoom in on something using Zoomit , that really useful thing that I use whenever I&amp;#39;m presenting these days. But I didn&amp;#39;t have Zoomit running, and so SQL</description><dc:language>en</dc:language><generator>CommunityServer 2008.5 SP2 (Build: 40407.4157)</generator><item><title>re: Ctrl+1 in SSMS for sp_who, plus more</title><link>http://msmvps.com/blogs/robfarley/archive/2008/08/08/ctrl-1-in-ssms-for-sp-who-plus-more.aspx#1656446</link><pubDate>Thu, 11 Dec 2008 02:51:30 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1656446</guid><dc:creator>Rob Farley</dc:creator><description>&lt;p&gt;Ah, love it. Particularly the SELECT TOP 10 * one.&lt;/p&gt;
&lt;p&gt;An add-in would be great. Let me know if you get something sorted.&lt;/p&gt;
&lt;p&gt;Rob&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1656446" width="1" height="1"&gt;</description></item><item><title>re: Ctrl+1 in SSMS for sp_who, plus more</title><link>http://msmvps.com/blogs/robfarley/archive/2008/08/08/ctrl-1-in-ssms-for-sp-who-plus-more.aspx#1656391</link><pubDate>Wed, 10 Dec 2008 17:00:12 GMT</pubDate><guid isPermaLink="false">d67277c4-116b-43f1-b688-e9ef184ea916:1656391</guid><dc:creator>Fabiano Neves Amorim</dc:creator><description>&lt;p&gt;Hi Rob, &lt;/p&gt;
&lt;p&gt;Yeah, in my environment &amp;nbsp;I use a lot of shortcuts&lt;/p&gt;
&lt;p&gt;Here is, &lt;/p&gt;
&lt;p&gt;Ctrl-3 = sp_helpindex&lt;/p&gt;
&lt;p&gt;Ctrl-4 = sp_spaceused&lt;/p&gt;
&lt;p&gt;Ctrl-5 = select top 10 * from &amp;nbsp;--- That is very cool&lt;/p&gt;
&lt;p&gt;Ctrl-6 = DBCC FREEPROCCACHE&lt;/p&gt;
&lt;p&gt;And the wished, &lt;/p&gt;
&lt;p&gt;Ctrl-7 = select * from DictionaryTable where name = ‘?’&lt;/p&gt;
&lt;p&gt;In this case I use, &lt;/p&gt;
&lt;p&gt;select * from DictionaryTable where name = &lt;/p&gt;
&lt;p&gt;Than when I need use this, I put myself the ‘’ in selected &amp;nbsp;text.&lt;/p&gt;
&lt;p&gt;‘tabtest’ then run crtl-7&lt;/p&gt;
&lt;p&gt;I was thinking in develop one Add-In to SSMS to fix this… what do you think?&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://msmvps.com/aggbug.aspx?PostID=1656391" width="1" height="1"&gt;</description></item></channel></rss>