meta user
network profile
| bio | website | basetable.wordpress.com |
|---|---|---|
| location | Edinburgh, United Kingdom | |
| age | 24 | |
| visits | member for | 1 year, 9 months |
| seen | May 16 at 13:43 | |
| stats | profile views | 26 |
Education is learning what you didn't even know you didn't know. - Daniel J Boorstin
On my day job I maintain a large database application for a growing Edinburgh-based travel search company. Every day I learn more about development and administration in the trenches, including how to cope with legacy worst practices and how to benefit from SQL Server best practices.
Studying part-time at Dundee University for an MSc in Business Intelligence.
|
May 20 |
awarded | Popular Question |
|
May 16 |
awarded | Caucus |
|
May 9 |
revised |
How to decode a query on a composite unary-encoded attribute? fix expression (missing &) |
|
May 9 |
comment |
How to decode a query on a composite unary-encoded attribute? @ypercube There could be a proportional relationship between the encoded number and the stated dosage. The paper doesn't make it clear whether the database stores fractional doses (say, 29.5); all it says is that there are 200 distinct values. |
|
May 9 |
comment |
How to decode a query on a composite unary-encoded attribute? @ypercube That explains why the three expressions are ORed together. But 325 base 6 is 125 in base 10, no? 5 * (6 ^ 0) + 2 * (6 ^ 1) + 3 * (6 ^ 2) = 5 + 12 + 108 = 125 So I don't see a direct relationship to a dosage value of 30. |
|
May 8 |
revised |
How to decode a query on a composite unary-encoded attribute? Clarify a statement about the encoding. |
|
May 7 |
awarded | Quorum |
|
May 7 |
revised |
How to decode a query on a composite unary-encoded attribute? Clean up after proof read. |
|
May 7 |
comment |
How to decode a query on a composite unary-encoded attribute? I was unsure about how much understanding of the paper to assume. Of course, if I had full understanding, I wouldn't ask the question! If you have read the paper and my question is unclear, I will try to make it clearer. |
|
May 7 |
asked | How to decode a query on a composite unary-encoded attribute? |
|
Mar 6 |
comment |
Type conversion in expression may affect “CardinalityEstimate” in query plan choice? I would like to share a link to the query plan for analysis in case someone wants to see it. Does dba.stackexchange.com have a service for hosting query plans? |
|
Mar 6 |
asked | Type conversion in expression may affect “CardinalityEstimate” in query plan choice? |
|
Feb 22 |
awarded | Citizen Patrol |
|
Feb 21 |
accepted | How can FLOOR(3) equal 2? |
|
Feb 21 |
comment |
How can FLOOR(3) equal 2? Thanks for the explanation. The confusion was caused by SSMS rounding the values! Is there any way to control whether SSMS rounds numbers like that? |
|
Feb 21 |
asked | How can FLOOR(3) equal 2? |
|
Feb 15 |
comment |
are there significant differences with 500+ million row tables in Oracle? +1 for the reference. He's updated the slides for 2012. |
|
Feb 15 |
comment |
Difference between SQL batch, statement and RPC? "An RPC call (which is either a batch or a stored procedure call)". So everything is RPC in the end? Can you clarify that? |
|
Feb 14 |
comment |
Why are non-digits LIKE [0-9]? @BlueRaja-DannyPflughoeft I think it's because in a case-insensitive collation they are considered equal, so either order is correct. The database engine chooses one order or the other on a per-comparison basis. When I inspect the result of SELECT CodePoint, Symbol FROM #CodePage ORDER BY Symbol;, I see that A sorts before a, but b sorts before B. |
|
Feb 14 |
comment |
Why are non-digits LIKE [0-9]? @ypercube Fractions: Yes, they are. Exponents: No, insofar as it makes no sense to me to write an exponent in isolation. What does ² by itself mean? Is ² equal to 2? Is it merely a question of notation? As far as collation is concerned, I think it would be equally valid to, say, sort all the digits in sequence, then sort all the exponents in sequence, and so on. |
