Part 1: How to solve the transactional issues of isolation levels
Transaction Isolation levels are described in terms of which concurrency side-effects, such as dirty reads or phantom reads, are allowed.
2013-05-01
9,927 reads
at yazdani
Re-compilation and Its effects on Performance
How recompilation does significantly affect on the execution time of SQL query and plummet or degrade the performance?
2012-06-07
10,806 reads
Blogs
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Forums
Grant user read-write permission to a single database
Hello! How do I grant a user to read-write to a single database and...
Creating paginated report where each page is a month in the range selected
With in the paginated report I am trying to display on each new page...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers