Ran a query that gives me the most expensive queries.
As I try to capture the SQL Column I am finding out that the results is chopped off.
SQL Server Management Studio
Access the Options Menu and transversed to Query Results \ SQL Server \ Results to Grid
And, determine the max Non XML data is 65535 Characters.
What is Column Length?
Changed the query to emit the column length…
- Our most expensive query is 147,020 characters
- Some other queries are 16,736 and another is 11,133
Googled for a fix and as always found one via Stackoverflow.
Copy Current Cell
Journeyed to SSMS Boost web site here
Downloaded version Specific
Download & Install
Downloaded and Installed SSMS Boost
Retrieve User/machine Has Token
Retrieved User/Machine Token through running SSMS and accessing menu items SSMSBoost / About License.
Request Community License
Requested Community License by going here.
Here is the Free License Request Form that comes up.
Received license over email
Ran the query again.
Select Grid Cell
Selected the Grid Cell and right clicked on our selection.
Chose “Copy current cell 1:1” from the dropdown menu.
We were able to capture our cell’s content.
Was able to paste into Notepad++.
In Notepad++, accessed the menu item View \ Summary.
Here is what our summary window looks like:
We have about over 43 thousand characters.
Dedicated to SSMSBoost’s directory Andrei Rantsevich.
From the Query’s contents:
(@p__linq__0 datetime2(7),@p__linq__1 datetime2(7),@p__linq__2 bit,@p__linq__3 uniqueidentifier,@p__linq__6 bit,@p__linq__4 uniqueidentifier,@p__linq__5 bit)SELECT
[Project40].[Id] AS [Id],
[Project40].[C1] AS [C1],
[Project40].[Id2] AS [Id1],
[Project40].[Id5] AS [Id2],
[Project40].[Id1] AS [Id3]
we can see that the query is not handwritten, but generated via Microsoft .Net Linq.