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 ««123»»

SSMS Results Expand / Collapse
Author
Message
Posted Friday, April 18, 2014 6:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:53 AM
Points: 1,297, Visits: 1,658
Gobikannan (4/18/2014)
...If the settings are imported from SQL Server 2018 settings...


Well, that's what you get for time-travelling.
Post #1562999
Posted Friday, April 18, 2014 7:28 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:28 AM
Points: 1,828, Visits: 1,363
Thanks for the easy one to end on a Friday Steve.



Everything is awesome!
Post #1563019
Posted Friday, April 18, 2014 7:34 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:20 AM
Points: 1,767, Visits: 2,141
--------------
That was easy!

(1 row(s) affected)


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1563027
Posted Friday, April 18, 2014 9:40 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:21 PM
Points: 5,975, Visits: 12,883
I was hoping as it was easter this would be worth 7 points

---------------------------------------------------------------------

Post #1563081
Posted Friday, April 18, 2014 10:43 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 4:09 PM
Points: 21,252, Visits: 14,960
Koen Verbeeck (4/18/2014)
Too easy
Have a nice Easter weekend, and don't eat too much chocolate!


+ a few T bills




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1563113
Posted Friday, April 18, 2014 4:14 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 7:42 PM
Points: 8,567, Visits: 9,071
Very clear and easy question.

The page referenced in the explanation is another example of BOL getting it wrong - it says the default keyboard scheme is the VS 2010 set; I have a default install of SSMS version 11.0.3128.0, and it offers two keyboard shortcut sets: the default, and the VS 2010 set which is different for some hot keys, but not in any way that would affect today's question. So for example the default for results to file is CTRL+Shift+F, not CTRL+Shift+T as claimed on that page. On the other hand, CTRL+Shift+C (one of the VS 2010 shotcuts which isn't in the other set displayed on that BOL page) works in the default set. So I don't think the default is either of the sets described on that BOL page. Or have I slept through an update that I should have picked up?

The referenced page is the 2012 version - I would have expected that URL to point to the 2014 version by now - adding (v=sql110) to the url delivers the same (2012 version) page. Normally URLs unqualified by version are the latest release, which is now SQLS 2014 but currently you have to add (v=sql120) to get the 2014 version of this page. I wonder how long it will be before all URLs not specifying a version point to the latest versions.


Tom
Post #1563199
Posted Friday, April 18, 2014 10:42 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 3,972, Visits: 2,983
This was an easy one and a nice way to end the week. Everyone have a happy Easter.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1563212
Posted Saturday, April 19, 2014 4:07 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:38 AM
Points: 1,139, Visits: 520
Carlo Romagnano (4/18/2014)
In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than 2MB you should save results in a file.rpt

For large results (like 300,000+ rows) I prefer file.txt for later usage, so you can open an Excel sheet & import it from Text.
Post #1563230
Posted Saturday, April 19, 2014 4:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:38 AM
Points: 1,139, Visits: 520
george sibbald (4/18/2014)
I was hoping as it was easter this would be worth 7 points

Yes, it should be
Post #1563231
Posted Saturday, April 19, 2014 4:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:38 AM
Points: 1,139, Visits: 520
Easy one!
Post #1563232
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse