Question : Experts, I have two databases, one is SSISDB, other is user database. Both of them are a part […]
DbaFix
Get all possible parent ids only if has parent bigger than 0
Question : Right now If I call get_parent_id(4) I will get all id parents. This means 3,2,1. Is not hard […]
How to get SQL insert and/or update to not lock entire table on MS SQL Server
Question : Very much a newbie on DB work, so appreciate your patience with a basic question. I’m running SQL […]
Is there a way to see completed process list in mysql (SHOW FULL PROCESSLIST)
Question : I am new to Mysql server, I use the below query to see what are all processes or […]
Rank in more tournaments and boards
Question : Source data is of sample tournamet board player score 1 1 2 990 1 1 4 980 1 […]
Does SQL Server use pointers instead of storing duplicate rows?
Question : I’m using the built in sp_spaceused stored procedure before and after performing a operation in our software to […]
How do I set up privileges for different schemas?
Question : How do I set up 2 schemas with a total of 5 users? Schemas: hp hpc Users: dba […]
how to model an entity with two possibilities (sql)
Question : I have an payment entity that can take a form of bank transaction or cash. So, to achieve […]
Different Result When Insert Data Contain Quote on Localhost and Online MySQL Hosting
Question : I installed xampp on localhost and insert data contain quote using this php code $content = htmlentities($_POST[‘content’]); $content_esc […]
Is it a bad practice to always create a transaction?
Question : Is it a bad practice to always create a transaction? For example, it is a good practice to […]