Optimize SQL queries with these 6 tips
Hello everyone. When we carry out work on optimization of a database environment in general, we usually review the database parameters, waits, indexes, etc. This type of question is important, …
Why you shouldn’t index your temporary tables.
Good morning friends !! In today’s post we will see why we should not index our temporary tables. When you have a process that uses temp tables and you want …
How to know if I have permissions in SQL Server
Hello everyone, today we are going to tell you how to know if I have permissions in SQL Server. For this we will use the function that the system gives …
Rebalance DataFiles in SQL Server
Hi friends! In today’s post we are going to see how to rebalance large datafiles or several smaller ones of equal size. This task optimizes the disks, allowing the information …
How to monitor GAP in AlwaysOn?
Good morning everyone! Today we will see how to monitor GAP in AlwaysOn to be able to react quickly and minimize the impact of recovering to the hardening point. This …
Autonumerics: get the latest embedded in Oracle, MySQL, and SQL Server
Hi friends!!! In today’s post we are going to work with Autonumerics in Oracle, MySQL and SQL Server . We will see how to obtain the last value of the …