Transact SQL – STRING_AGG – Error – “Incorrect syntax near ‘within'”

Background Working on a script, but noticed an error when I tried to sort the data using the String_Agg within group clause. Code Let us reproduce using a sample data set. SQL Sample -01 SQL Output Sample -02 Outline If one reviews our output, one will notice that the cities are listed based on the … Continue reading Transact SQL – STRING_AGG – Error – “Incorrect syntax near ‘within'”

Measuring IOPs on MS Windows – Day 01

Background Wanted to cover a couple of options for measuring Storage IOPs on a MS Windows machine. Outline SysGauge - System Monitors MS Windows Performance Monitor Disk IO Logical Disk SQL Server ( v2014+ ) Choices SysGuage Download SysGuage from here. Install it on targeted machine. Run it while sufficient load is running. Images MS … Continue reading Measuring IOPs on MS Windows – Day 01

XQuery/Transact SQL – Case Sensitivity

Background When issuing XPath queries, XQuery in SQL, one has to keep in mind that though the database itself could be defined as case-insensitive, XML is case-sensitive.   Create & Populate Data Create Table SQL Populate Table with data SQL Data   Queries Normal Queries Fetch all data Fetch data whose part name is Teeth … Continue reading XQuery/Transact SQL – Case Sensitivity

SQL Server – v2017 – Error – “VS Shell installation has failed with exit code 1638”.

Background Back installing SQL Server v2017 Developer Edition. Earlier Post Our preceding attempt is here: SQL Server – v2017 – Install – "Oracle JRE 7 Update 51 (64-bit) is required for Polybase" Link   Error Got another error. Error Image Error Text Trouble Shooting Current Status of Install Install_VCRuntime140_CPU32_Action The error pasted above came up … Continue reading SQL Server – v2017 – Error – “VS Shell installation has failed with exit code 1638”.

SQL Server – v2017 – Install – “Oracle JRE 7 Update 51 (64-bit) is required for Polybase”

Background Installing SQL Server v2017 and ran into an error that I have seen before. Error Error Image Error Textual Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase Tackled Before History Already tackled before here: SQL Server (v2016) – Installation – Blocked – "Oracle JRE 7 Update 51 (64-bit) or higher … Continue reading SQL Server – v2017 – Install – “Oracle JRE 7 Update 51 (64-bit) is required for Polybase”

Transact SQL – STRING_AGG

Background In our post on MySQL - Information_schema.statistics we spoke glowingly of the GROUP_CONCAT Function. I really could not find a way around using it in MySQL. I ran into some difficulties using it and as with problems one just googles for workarounds. BTW, the MySQL post is here. SQL Server Introduction It seems that … Continue reading Transact SQL – STRING_AGG

SQL Server – Operator – Top – Top Expression (0)

Background Earlier today I found myself pressing to make sure I had done right by a query.   Query Plan Query Plan – 01 Here is the original query Plan Image Explanation I know that I don’t really want a Hash Match Took care of the Hash Match by reducing the query from two tables … Continue reading SQL Server – Operator – Top – Top Expression (0)