270 reputation
312
bio website twitter.com/AakashMehendale
location London, United Kingdom
age
visits member for 1 years, 10 months
seen 9 hours ago

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
Feb
28
comment SQL Server - Recursive “find all FK connections for ID through the entire DB” query
"But it's going to be tricky to make this thing truly recursive." - don't. Make it iterative. Keep a table variable containing all the tables you've found so far; have a WHILE loop adding tables to it that are connected to the ones already in it; stop when an iteration doesn't add any tables. Of course, if you want, you can probably do the above in a recursive CTE.
Feb
5
revised Method to keep track of large number of sets with high cardinality
typos .
Feb
5
suggested suggested edit on Method to keep track of large number of sets with high cardinality
Feb
4
comment Schema design - best practices?
This appears to be talking about database design in the general sense, and not at all about SQL Server Schemas.
Jan
28
comment Storing nationality options
"there is Scottish nationality" - are you sure? I'll give you ethnicity, but there are no Scottish passports... (as of January 2014; this might change following a Scottish vote for independence of course!)
Jan
20
comment MS Access + SQL Server for 1160 users - Is it worth it? (Please Help!)
+1, although given their $1500 budget I think disappointment is in store whatever path is taken...
Nov
27
awarded  Commentator
Nov
27
comment Consecutive Rows to fetch from SQL server table
Does "Days interval will be dynamic" mean that sometimes you will want those records where an Employee has been continuously absent for 3, 4, ..., 23, ... days ? Also, could you state explicitly what your Status column means? Also also, could you show us what you've tried?
Oct
18
awarded  Informed
Jul
3
accepted Is there a limit to how many credentials SSMS can remember?
Jun
14
awarded  Yearling
Jun
10
comment Is there a limit to how many credentials SSMS can remember?
Thanks for the link. My SqlStudio.bin is currently just over 100 kilobytes.