Transact SQL – using xp_sscanf to parse input ( Parse Bible Verse )

  Background Let us use xp_sscanf to parse Bible Verse. Introduction Bible people will say my hope rests on John 3:16 An inquiry mind might want to look up John 3:16. In his or her mind, he will break those words down. In computer jargon, one will tokenize it. Tokens Here are the tokens :- … Continue reading Transact SQL – using xp_sscanf to parse input ( Parse Bible Verse )

SQL Server – Query Plan – Warning – “Columns with no statistics”

Background Wanted to quickly cover how to address a SQL Server Query Plan warning. Warning Textual The Warning reads "Columns with no Statistics [dbo].[tblTimer].stepid" Image Query SQL Text TroubleShooting SQL Syntax Sample Output Grid Textual _WA_Sys_00000003_019E3B86 ( instanceId ) idx_sectionID_instanceID_stepID ( sectionId, instanceId, stepid ) PK__tblTimer__02925FBF ( id )   Remediation SQL Text Review Once … Continue reading SQL Server – Query Plan – Warning – “Columns with no statistics”

Transact SQL :- Temporary Table & Conditional Creation

Background Transact SQL offers the best programming space of all the top tier relational database. But, there are areas one can stumble over, as well. Temporary Table Simple Let us create a simple temporary table Different Structure Objective Depending on certain conditions, our table structure might need to be different. Column 2 If @type is … Continue reading Transact SQL :- Temporary Table & Conditional Creation