mustaccio's user avatar
mustaccio's user avatar
mustaccio's user avatar
mustaccio
  • Member for 10 years, 9 months
  • Last seen this week
63 votes

Asked to Not Use Transactions and to Use A Workaround to Simulate One

56 votes

What does the word "SARGable" really mean?

47 votes

Does `COUNT` discard duplicates?

46 votes
Accepted

How do I enforce a write-once then read only database table in SQL?

33 votes
Accepted

What does the position of the ON clause actually mean?

33 votes

What exactly is the 'online' in OLAP and OLTP?

29 votes
Accepted

How to retrieve the query I used to create a view?

24 votes
Accepted

Colleague says to never use an OR statement in SQL, is this true?

22 votes

Poor performance on query with LIMIT when I add an ORDER BY?

22 votes

How to prove the lack of implicit order in a database?

20 votes

Why can't object names start with a number?

19 votes

Example where schema are better than multiple databases

18 votes

What's the difference between "expression <=1." and "expression <= 1"?

18 votes
Accepted

What happens if two process try to REFRESH MATERIALIZED VIEW CONCURRENTLY at the same time?

17 votes
Accepted

Non-deterministic sum of floats

16 votes
Accepted

Does ordering by auto-incrementing PK ensure chronological order?

16 votes

Why is it more difficult to horizontally scale a relational database than a NoSQL database like MongoDB?

15 votes
Accepted

Is this SQL Procedure "injection proof"?

15 votes
Accepted

Strange conditional Syntax in TSQL Query: "<=+" What does it do?

14 votes
Accepted

Why is it not recommended to use RAID 5 for a log file?

12 votes

Emulate REGEXP like behaviour in DB2 SQL

12 votes

How to model a table in a relational database where all attributes are foreign keys to another table?

11 votes
Accepted

DB2 will not INSERT into Created Temp Table that I created

11 votes
Accepted

Insert into multiple tables with one query

11 votes
Accepted

When exactly are IMMEDIATE constraints checked and what exactly is a "statement" in Postgres?

10 votes

How is it possible for Hash Index not to be faster than Btree for equality lookups?

10 votes

Why does SELECTing sum() return null instead of 0 when there are no matching records?

9 votes

What is Selectivity?

9 votes

The logical order of execution plan of the SQL query with more than one join

9 votes

Why do we have undocumented and unsupported functions in SQL Server?

1
2 3 4 5
27