Microsoft’s SQL Server query optimizer uses a cost-based approach by deciding on the “good enough” way — not necessarily the best way to retrieve results. This is because considering all possibilities for retrieving the data might be inefficient.
Read moreThis week is Computer Science Education Week and Code.org has launched a series of tutorials showing that ANYONE can code. Go ahead and give it a try.
Read moreYou can do more work faster by using keyboard shortcuts. To help, here are a dozen more keyboard shortcuts that will help make your SQL work faster and more efficient.
Read moreFirewalls help protect the surface area of the SQL Server and prevent unauthorized access to resources. Listed below are some common SQL Server ports to configure for Windows Firewall.
Read moreMany experts agree that memory is the most important resource with regard to SQL Server performance. There are hundreds of performance counters, and therefore, it can be complex to figure out just what to monitor. Here are some suggestions in understanding whether memory pressure might be the performance problem with your SQL Server. You can use Performance Monitor to collect this data. You can also obtain the SQL Server specific counters using the Dynamic Management View (DMV) that is built into SQL Server. The DMV is an excellent and lightweight option for performance monitoring. You can use this syntax.
Read more