Question : I have three tables, one for members with 8 records, one for tasks with 1 record, and one […]
Author: admin
Find rows with specific string inside column text
Question : I’m new in working with SQL Server and I’m trying to select all rows which has a specific […]
SSAS Hierachies duplicates when browsing
Question : The dimensions in the cube are giving us duplicates, there is no error while processing the cube, but […]
Pros and Cons of SQL Server back up strategies and their appropriate usage scenarios
Question : From what I can tell, there are three possible ways of backing up your SQL Server database Full […]
How to create Polygon from Point datatype in MySQL?
Question : I have a table like this: CREATE TABLE `aois` ( `aois_id` int(11) NOT NULL DEFAULT ‘0’, `WS_A` point […]
Beginner table design
Question : I have been coding in C# for a couple of years where I usually try to follow the […]
MySQL asynchronous multi master replication conflict resolution
Question : I have setup Multi Master replication, following this blog thread: http://0wned.it/geek-bits/guides/mysql-multi-master-replication/ And now it synchronizes perfectly, up until […]
MySQL replica is lagging without resource saturation
Question : I am running MySQL 5.6.41 on AWS RDS. I have one multi-AZ master and one multi-AZ read replica. […]
Getting total number of counts for distinct entrys for the same id
Question : I have a table which is like this. CREATE TABLE `ad_analytics` ( `id` int(90) NOT NULL, `ad_id` int(90) […]
Is filtering on int better than filtering on date [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]