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
7,463 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
8,574 reads
Blogs
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Permissions required for row counts to show up on Object Explorer Details
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Forums
First DW design - advice appreciated
All, Up to this point I've only worked with relational databases. I'm trying to...
Backup Strategy For distributed availability groups
What is the recommendations for backups in distributed availability groups? I have AG setup...
What happens when I drop a huge table with LOBs? will the space be reused?
Thanks in advance for your help. I have a 5TB database with mutliple filegroups. ...
Ask SSC