300 reputation
312
bio website twitter.com/AakashMehendale
location London, United Kingdom
age
visits member for 2 years, 2 months
seen 3 hours ago

Jul
30
comment Inserting INTO XML Column shows nothing at all
When I run your DDL followed by your DML followed by SELECT * FROM TableName, I see what I expect to see. Could you provide a Minimal Complete Verifiable Example please?
Jul
25
comment sql server Group by with calculated values
"total sql code is as small as possible" - why does the size of the code matter?!
Jul
25
suggested suggested edit on View with left joins are very slow
Jul
23
comment Database revision needed for sports events database
Plural vs Singular Table Name has been asked, if anyone is seeking a more appropriate place for such thoughts...
Jul
4
answered Matching 3 columns in row - if one column is null then exclude it from comparison
May
30
comment query to update status column with 1 to 0 and 0 to 1.?
I would flag for migration to SO, except for the Golden Rule of Migration
May
22
comment SQL Question: Selecting different language versions based on availability
Which DBMS and version?
May
15
comment db_owner unable to drop database - Error 615, SQL Server
I got this exact message attempting to DROP a database that was offline while not sa-equivalent, if that's any help
May
13
comment What is meant by DDBB?
Where did you hear this term? What was the context?
May
8
comment Get streak count and streak type from win-loss-tie data
Well, if I'm asked for comments I would say: 1) why 'fantasy' in so many names 2) why bigint for so many columns where int would probably do 3) why all the _s?! 4) I prefer table names to be singular but acknowledge not everyone agrees with me // but those aside what you've shown us here looks coherent, yes
May
8
comment Get streak count and streak type from win-loss-tie data
Incidentally, all such schemas I've ever seen use a tristate (eg 1 2 3 meaning Home Win / Tie / Away Win) column for the match result, rather than your winning_team_id with value id / NULL / id. One less constraint for the DB to have to check.
May
8
comment Database design for handling 1 billion rows and counting
Tangentially, if you're using "pr." as an abbreviation for "per", then 1) it isn't standard, so takes a moment to understand, and 2) it doesn't actually save any characters :)
Apr
16
comment Translating a query from MS Access to SQL Server
@StevePettifer you can make it perhaps more intuituve by supplying the optional FROM: DELETE FROM category etc
Apr
8
comment What is the correct way of filtering a property by multiple features?
This appears to be the highest-voted answer here about relational division, which is the name of this problem
Apr
3
comment What is the correct way of filtering a property by multiple features?
Are you sure this will select "all properties that have both Feature A and Feature B." ?
Apr
2
awarded  Popular Question
Mar
19
revised A clarification of MERGE best practices
english .
Mar
19
suggested suggested edit on A clarification of MERGE best practices
Mar
18
comment Databses design, parallel many-to-many relationships. Two tables, or extra fields?
It makes the SQL more complex only when you are asking the question "what are all the connections between person P and Expense E" - how often are you asking that question? It seems to me that questions relating solely to paying, or solely to incurring, will be much more common, and for those questions separate tables make more sense.
Mar
14
awarded  Civic Duty