What is generational Inequity? Generational Inequity refers to a phenomenon influencing various aspects of life such as politics, commerce, and even the judiciary. To best understand generational inequity, […]
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 […]
Adding a Quintillion
An interesting problem was asked on #Sqlhelp recently about adding very large numbers, in excess of 20 digits in SSAS tabular model. While most of us will find […]
Query to find size of tables in Azure database
Quick and dirty way to find the size of all tables in a azure database. DROP TABLE #list DROP TABLE #data GO CREATE TABLE #data ( name VARCHAR(100) […]
#sqlhelp | should you remove indexes from tables before ETL?
Starting today we are introducing a new type of blog content which covers questions from #sqlhelp. We pick random questions from the feed and try to cover them […]
How secure is the Aadhaar/UIDAI database?
The recent discussion on how social media and Big Data is being misused to profile and categorize users is very serious. However most people don’t seem to grasp […]
How Random is the RAND() function? SQL, Chance and the universe.
I use the Random function quite a bit to generate dummy data. So recently I was interested to find out actually how random it is. Randomness implies that […]
Tracking DML Operations in SQL tables
Recently I was asked if there was a better way than triggers to perform audits on a table. Essentially the client has a number of tables and each […]
Multiplexing queries and performance issues
Problem Recently I was approached with an issue which requires multiplexing queries in order to reduce the number of indexes created in azure search. Depending on the service […]
Speeding up database restores
This is a simple thing every DBA needs to do when they are done with installing SQL server. However it didn’t seem to be as popular as it […]