Quick and dirty way to find the size of all tables in a azure database.
Azure / MSSQL / TSQL / Uncategorized
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 […]
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 […]
AI-ML / Azure / MSSQL / Uncategorized
Configuring Polybase in MS SQL Server 2016
A bit late in the day but I figured I would add a post on how to configure MS SQL Server Polybase. Polybase is a feature of MS […]
Can we use in-memory oltp instead of columnstore index for DW queries
Recently when having a chat with a client I was asked if it will be a good idea to replace a view with a static in memory table […]