Question : I just installed SQL Server and SQL Server Management Studio but it doesn’t show anything in servers list […]
MySQL / MariaDB granular row size
Question : Is it possible in MySQL / MariaDB to calculate row size like in PostgreSQL ? I’m looking to […]
MySQL Server Status CPU/Load Formula
Question : Are there any variables and formula that can help me calculate CPU/Load value of MySQL ? Answer : […]
How to get the date part from a date with timestamp column in SQL Server?
Question : I want to get the date in DDMMYYY format from a field that stores date in YYYY-MM-DD Timestamp […]
Cleanup Error Messages in SQL Server ERRORLOG
Question : The SQL Server’s ERRORLOG file has a lot of messages like the following in AG in publisher (primary) […]
How to clone a user in SQL Server 2008 R2?
Question : Is there a way to clone users’ security and permissions in Microsoft SQL Server, preferably using the SQL […]
SQL Server Decimal(9, 0) vs INT
Question : One of our customers uses for some columns the datatype DECIMAL(18,0) in his SQL Server 2008R2 database. Because […]
Why is MySQL not using the index with the higher cardinality?
Question : I have an index called source with cardinality of 1122 and a second index called state with cardinality […]
Question : Answer :
Cursor Based Pagination for Timestamp field with non-unique values
Question : We are trying to create a query for the following table : CREATE TABLE `Action` ( `id` int(10) […]