Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Artashes  Khachatryan's user avatar
Artashes  Khachatryan's user avatar
Artashes  Khachatryan's user avatar
Artashes Khachatryan
  • Member for 9 years
  • Last seen this week
4 votes

SQL Data types and SmallInt/TinyInt vs Regular Integer

4 votes
Accepted

"Unrelated" INSERT and UPDATE blocking each other

3 votes

SQL Windowing Functions: Are the results ordered?

3 votes
Accepted

When is a trigger fired?

2 votes

SQL Server: SET NOCOUNT ON still returning data

2 votes
Accepted

How to get the recently hired employee of each department when two employees of different department have same hiredate?

2 votes
Accepted

Best design for storing group products and products, and including both in orders?

2 votes

Why does the optimizer choose nested loops over merge joins here?

2 votes

Find order that has deliveries in multiple weeks

2 votes
Accepted

Does auto increment on Primary Key prevent concurent inserts?

1 vote

data structure for grouping children without parents

1 vote
Accepted

How to get latest timestamped result from time series in a join table

1 vote

Split a string into multiple rows and get the count for each of them

1 vote

Multiple instance of Update Query is causing very high Lck_M_U wait thus high CPU

1 vote

Speed up 180M+ rows returned by simple SELECT with PostgreSQL

1 vote
Accepted

Get the summary from more than two tables (stock movement report)

1 vote

How to get latest date from fees table and compare it to current date in mysql

1 vote

Join based on date

0 votes

SQL Server's READ COMMITTED SNAPSHOT vs SNAPSHOT

0 votes

Index on JSON field with dynamic keys

0 votes

Access Query - Count distinct values

0 votes

Representing ownership of heirarchical tree structure

0 votes

How can I design a database for different products(with different attribute) as well as we should keep in mind future new products requirement?

0 votes

Get data excluding time intervals in another table

0 votes

Adding columns for group by result values in oracle

0 votes

Use variables within a function with INSERT INTO

0 votes

SQL Server: ensure primary key uniqueness over two tables

0 votes
Accepted

How to find out which records are causing an exception in a select statement?

0 votes

Dynamic auditting trigger without temporary tables

0 votes

Help with calculating a sum of all previous rows in each subsequent row in postgresql