Question : We had recently a problem on our SQL Server 2014 HADR environment, where one of the servers ran […]
Author: admin
Data Domain Boost viewing backups
Question : Does anyone have any insight on how to view backups in Data Domain? Preferably with T-SQL. Thanks in […]
One table for all persons
Question : i have one table for all person (with fields ex. name, last name) because each person can has […]
Database for building a realtime analytics system
Question : I want to build a system similar to Google Analytics (only used for internal use, less traffic and […]
Threads_cached 0 while thread_cache_size > 0
Question : I’m trying to little bit understand with some MySQL (in my case – MariaDB) performance. One point I […]
Why is performance non-linear if I do many UPDATEs in a single transaction
Question : An older question covers some reasons why the performance of multiple INSERTS within a single transaction is non-linear […]
Mysql innoDB write operations are extremely slow
Question : I’m having serious performance problems with MySQL and the InnoDB engine. Even the simplest table makes writing operations […]
mysql_query expected [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Oracle not using index when > used in where clause
Question : We have a relatively classic scenario where the date clause of the query generated by the application uses […]
Determine databases specified Login has access to on SQL Azure
Question : I need to obtain a list of all the databases a specific user has access to. To this […]