Today we are going to see a very simple but brain teaser puzzle. This puzzle is about Deleting Qualified Rows From Multiple Tables.
SQL SERVER – Using Memory-optimized Tables and Native Stored Procedures – Video Course
SQL Server Performance Tuning video course on Pluralsight on the topic – Using Memory optimized Tables and Native Stored Procedures.
What is Faster, SUM or COUNT? – Interview Question of the Week #231
Question: What is Faster, SUM or COUNT? Answer: Both are the same. I was asked this question during my Comprehensive Database Performance Health Check.
Free Video – SQL Server Performance Tuning Made Easy – Conference Session Recording
In today’s blog post we are going to watch a free video about how you can easily spot poor SQL Server performance in your system.
Coffee Mug – Indexes and SELECT Queries
Sometimes I feel like I have become a kid again. This morning I received a coffee mug with printed quotes of Indexes and SELECT Queries.
How to List All Memory Optimized Tables in SQL Server? – Interview Question of the Week #227
Question: How to List All Memory Optimized Tables in SQL Server? We will see two different scripts here: One for Database and Second for Tables.
SQL SERVER – An Index Reduces Performance of SELECT Queries
Can an Index reduce the performance of SELECT Queries? Let me make this question a bit more complete and meaningful to you.