I was recently asked about the concept of Boolean hell and thought it would be a good post to discuss. Most database professionals should be familiar with the […]
How to identify conversion issues using TRY_CAST ()
A common issue with the ELT process is that you find out errors after they have been loaded. This is usually not any issue unless the database specifically […]
Using Snippets in SSMS
A little know and used feature by database developers is Snippets. Database developers understandably do not use this feature because we have long been accustomed to using prebuilt […]
Tales from the crypt: – Passing multiple int values into a variable
I was browsing through the forums and found this question being asked. While the reason for the error is fairly obvious I felt it needed further investigation so […]
administration / Database / Errors / TSQL
Finding candidate keys/Primary keys from data that needs to be imported
This is a continuation from the previous post where we went and inserted data from multiple CSV files into SQL server tables using linked server connection. Often the […]
SQL 2019:- Truncation Error message and where it fails
I was wondering if I should even bother checking this feature out since it was pretty obvious what it does and how useful it is. I can’t even […]
SQL 2019:- Table Variable deferred compilation – PART 2
In the last post we ended with two questions remaining unanswered. Shouldn’t a more accurate row count have resulted in the correct amount of memory being granted and […]
SQL 2019:- Table Variable deferred compilation
One of the features being released in SQL 2019 that has got some attention is table variable deferred compilation. As its name suggests it applies to Table Variables […]
Working with Filetable to upload documents into SQL Server
A simple script on how to setup and work with file tables in MS SQL Server. This basically does the bare minimum to setup and create filetables in […]
SQL 2019:- APPROX_COUNT_DISTINCT
A function that might prove useful when querying very large datasets, it provides a count of distinct values for any column in the database except text,ntext , image […]