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'”
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
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
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”.
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”
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
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)