Tips for using query hints in SQL Server 2019 If your query is very slow, try the following before using query hints: – rebuild indexes used in the query (or defragment them using DBCC INDEXDEFRAG), – update statistics on the relevant tables, – consider creating new indexes for this query, – rewrite your query to provide better execution plan. Use...
Other News
Easily Enable Azure AD Authentication In Angular And ASP.NET Core Web API App
(Sarathlal Saseendran) Azure Active Directory is the Identity and Access Management (IAM) solution offered by Microsoft.
Ask the Experts: Database Performance Roundtable by Quest
(Pinal Dave) SQL Server Performance tuning is all about endless learning for every single person. I have been working on this field for so many years and till today, I learn every single day.
New Feature in Percona XtraDB Cluster 8.0 – Streaming Replication
(Vadim Tkachenko) Percona XtraDB Cluster 8.0 comes with an upgraded Galera 4.0 library, which provides a new feature – streaming replication. Let’s review what it is and when it might be helpful.
VS Code Go Language Extension Goes from Microsoft to Google
(David Ramel) Citing the need for “more maintenance and support,” Microsoft and Google have announced that further development of the Microsoft-led Go programming language extension for Visual Studio Code has been taken over by Google.
Messaging with Azure Service Bus – Part 9 – Premium Features
(Mark Heath) In this edition of my series on Azure Service Bus, I want to highlight a few of the “premium” features that Service Bus offers. Many of these aren’t necessary if you are just learning and experimenting with Service Bus, but if you are using it for mission critical production systems, th
Returning Promises From Async / Await Functions In JavaScript
(Ben Nadel) Over the weekend, when I was using SessionStorage to cache form-data in Angular 9.1.9, I had a service object that included a number of async / await functions.
Honey, I shrunk the database!
(Martien van den Akker) For my current assignment I need to get 3 SOA/B2B environments running. I’m going to try-out the multi-hop functionality, where the middle B2B environment should work as a dispatcher.
Rename Table During DataPump Import
(mdinh) At source perform export for tables=SCOTT.SALES, SCOTT.ORDERS
Nesting with Java interfaces
(Jeff Friesen) If you’ve read my Java 101 tutorial introducing static classes and inner classes, you should be familiar with the basics of working with nested classes in Java code.