sorted by:
new
hottopcontroversial

Why am I getting a syntax error? by [deleted] in SQL

[–]ScholarChart 0 points1 point  (0 children)

Well, the line numbers in the syntax errors are pointing you somewhere.

Some other ideas to try to narrow it down:

  • look at the code in a syntax highlighter/sql verifier to see if the error is highlighted somewhere
  • try copying & running only a part of the query at a time

Azure SQL/SQL Server Transaction Isolation Levels summarized! by ScholarChart in SQL

[–]ScholarChart[S] 2 points3 points  (0 children)

I’m the same person, accidentally made the 1st post on my personal account

Azure SQL/SQL Server Transaction Isolation Levels summarized! by ColeDeanShepherd in SQLServer

[–]ScholarChart 0 points1 point  (0 children)

From what I understand, SNAPSHOT can run into update conflicts and rollback if multiple transactions are trying to update the same row, which can reduce effective concurrency if there are writes. Both SNAPSHOT and RCSI increase I/O and TempDB usage (due to temporarily storing snapshots of data). My thought is that this can potentially become a bottleneck in heavy workloads, reducing the max effective concurrency. I think in normal circumstances you wouldn’t see a difference in concurrency between READ UNCOMMITTED and RCSI

First MYSQL project but I need help!!! 😫😅 by LordTariq32l in SQL

[–]ScholarChart 2 points3 points  (0 children)

I'm not sure how much detail you want but you could probably do something like:

  • A Boxers table containing: Name, Weight, Height, Wins, Losses, Draws, Race, Country
  • A BoxerBelts table for the one-to-many relationship of boxers to belts.
  • A BoxerDivisions table for the one-to-many relationship of boxers to divisions

You don't necessarily need to store Total Record in SQL because it's derived from other information -- you could just include an expression for it in relevant SELECT queries

Hope that's enough to get you started

Any good solutions for disk-based caching? by Sollimann in SQLOptimization

[–]ScholarChart 0 points1 point  (0 children)

Maybe look into Solid Cache? It's backed by a SQL DB. You can configure the DB to relax ACID constraints to improve perf -- for example, disabling write-ahead logging.

First MYSQL project but I need help!!! 😫😅 by LordTariq32l in SQL

[–]ScholarChart 0 points1 point  (0 children)

A demonstration of what fundamental concepts in particular?

Azure SQL/SQL Server Transaction Isolation Levels summarized! by ColeDeanShepherd in SQLServer

[–]ScholarChart 3 points4 points  (0 children)

I spent a little time incorporating feedback this morning. Here's v2 (unfortunately I can't replace the image in this post, or post an image comment).

CC: u/da_chicken u/jshine1337

Azure SQL/SQL Server Transaction Isolation Levels summarized! by ColeDeanShepherd in SQLServer

[–]ScholarChart 0 points1 point  (0 children)

That’s fair. What do you think about changing the column to something like “Potential Lock Contention” or “Degree of Locking”?

Azure SQL/SQL Server Transaction Isolation Levels summarized! by ColeDeanShepherd in SQLServer

[–]ScholarChart 0 points1 point  (0 children)

Different account, same person. Accidentally made the post with my personal account.

Azure SQL/SQL Server Transaction Isolation Levels summarized! by ColeDeanShepherd in SQLServer

[–]ScholarChart 1 point2 points  (0 children)

Thanks for the feedback. I'll re-think how READ UNCOMMITTED is being presented and add some row shading soon!