Reputation
10,293
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
18 40
Newest
 Nice Answer
Impact
~509k people reached

Jun
17
revised mysql variables are inconsistent
Removed sql-server tag as SQL Server is the Microsoft product and this is a mysql question.
Jun
17
comment Update Cube data
I'm no OLAP expert, but other than general tips that you could find in the documentation and/or a quick web search people won't be able to give you much specific help unless you provide a good chunk more detail than that. Which database system are you using (product+version) what sort of data size? Perhaps at least a brief overview of your current OLTP and OLAP structure? All on the same single server? Or do you have a wider scaled environment?
Jun
15
awarded  Nice Answer
Jun
12
revised Is it better to create another table to possible null values in relational databases?
added 48 characters in body
Jun
12
revised Is it better to create another table to possible null values in relational databases?
Added link to relevant other question
Jun
12
answered Is it better to create another table to possible null values in relational databases?
Jun
4
answered Algorithm used to perform offset/limit over a union all result set
May
29
answered Initials separated by periods (e.g. J.E.F. Smith)
May
29
answered Inefficient queries on partitioned tables
May
23
awarded  Good Answer
May
22
comment SQL actually executed as planned in ORACLE?
@Colin'tHart: I think our two answers are both right from a given point of view. In the short term an plan generated now (as an estimate or when actually running the statements) is likely to be the plan followed when the statements are next run, but over the longer term plans can differ greatly. Query planning is a very complex subject. There are massive books and many research papers written on the subject at various depths if the OP wants to really dig into the area.
May
22
comment SQL actually executed as planned in ORACLE?
@Colin'tHart: could you point to documentation about that? I would be most impressed if it has the intelligence to usefully do when I now have in my head that you mean, and would love to read into the details of how it is achieved.
May
22
revised SQL actually executed as planned in ORACLE?
added 138 characters in body
May
22
revised SQL actually executed as planned in ORACLE?
added 1072 characters in body
May
22
answered SQL actually executed as planned in ORACLE?
Apr
29
awarded  Nice Answer
Apr
27
comment Why sharding does not show any improvement?
@thelastblack: you should edit your question to include the extra detail, comments sometimes get cut off (or otherwise ignored) so someone who might otherwise have useful advice may miss the relevance and skip on by without knowing they can help.
Apr
27
answered Why sharding does not show any improvement?
Apr
21
answered How to get a surrogate key value in order to put a foreign key in and create relationship?
Apr
15
comment Restoring a backup of a database from SQL Server 2014 into SQL Server 2012
@BuahahaXD: No, even with a "back dated" compatibility level setting the database structures will be those of SQL2014. The compatibility modes only affect certain behaviour, not the underlying structure.