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 […]
Azure / MSSQL / TSQL / Uncategorized
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) […]
Analyze Actual Execution Plan in SSMS
This might be a hidden gem in SSMS that most people aren’t aware of so I figured I would post about it. I recently used this feature to […]
Plan reuse under Simple parameterization
Interesting problem came up today on #sqlhelp. A trivial plan results in multiple prepared Execution plans. To begin with let’s understand parameterization quickly. It is a mechanism that […]
Snapshot isolation level when database is set to read only.
Recently there was a question posted on #sqlhelp about why a database switched to Snapshot isolation level when you make it read only and then reverts back to […]
administration / Errors / TSQL
Cannot use row granularity hint on the table
Got approached with the below error message recently and thought it might be an interesting problem to look into. ProgrammingError((\’42000\’, 651, \'[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot use […]
administration / MSBI / MSSQL / TSQL / Uncategorized
#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 […]
The-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn -FIXED
Interesting little problem came up today when migrating a database from Azure SQL database to local server. The connections sting in the web app had the following property […]
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 […]