2021-11-29
666 reads
2021-11-29
666 reads
2018-03-08
1,176 reads
Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.
2016-11-17 (first published: 2016-11-04)
1,386 reads
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
5,183 reads
I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.
2013-05-13 (first published: 2013-05-03)
1,059 reads
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
By Brian Kelley
In my YouTube subscriptions feed, a new video for the Azure Cloud Chronicles with...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item Has the PK been used...
Comments posted to this topic are about the item Has the PK been used...
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers