Reputation
3,017
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
12 30
Newest
 Custodian
Impact
~116k people reached

23h
reviewed Close Oracle 12c upgrade - from Oracle 11g
23h
comment Is adding the join columns to a table a good practice to improve performance?
What is your recommendation then?
1d
reviewed Reviewed Difference between exp and expdp
1d
revised Difference between exp and expdp
formatting, spelling, grammar
1d
reviewed Reviewed Error: File '' couldn't be removed (error 2: No such file or directory)
1d
revised Error: File '' couldn't be removed (error 2: No such file or directory)
formatting
1d
reviewed Close How to install SQL Server Agent in existing SSMS
1d
comment What collation to use for Ukraine?
I hadn't read the latest version of your answer at the time of my second comment. Whatever might have looked as if I still disagreed with you was merely just a further clarification of my point in response to @Primoz. Sorry if my comment gave you the wrong impression. I've read your answer now and it makes sense to me. Thanks for taking the trouble of clarifying your point.
1d
reviewed Reviewed Calculating the percentage change from the previous row
1d
revised Calculating the percentage change from the previous row
fixed the formula
1d
reviewed Close fast execution analitycs database with thousand rows to displaying in php
1d
comment fast execution analitycs database with thousand rows to displaying in php
Are you talking about a PHP for loop that you are using to collect data for presentation or are you talking about a MySQL for loop that you are using to prepare the data for returning to your front end (PHP)? If it's the former, yours is not a database problem then, but rather a presentation problem.
1d
reviewed Reviewed What are the built-in default configuration values of redis.conf?
1d
comment What are the built-in default configuration values of redis.conf?
According to the description on the page you've linked, that command won't help you to find out the defaults: If an option was not already present, but it is set to its default value, it is not added by the rewrite process. – so you will probably still not know the default after invoking that command.
1d
comment What collation to use for Ukraine?
@Primoz: There have been disputes (possibly still going on) among Ukrainians about the "correct" position of Ь/ь in the alphabet. So actually your question is very reasonable and may not really have an easy answer. However, sticking to the fact that there is a specific Ukrainian collation that is related to the Ukrainian locale (and there are no other collations that apply to that locale, based on the chart here) seems a perfectly safe approach to me.
1d
reviewed Reviewed Strange behaviour of a query with order by and rownum on Oracle's Exadata server
1d
comment Strange behaviour of a query with order by and rownum on Oracle's Exadata server
Your link stopped working and I replaced it. The new link does look like the new location for the same page but I'm not sure. Please take a look.
1d
revised Strange behaviour of a query with order by and rownum on Oracle's Exadata server
replaced a no longer working link
2d
reviewed Reviewed Cannot open SQL Server profiler file
2d
comment Cannot open SQL Server profiler file
This is not about importing a trace file really, this is about accessing it in Transact-SQL (particularly, using the sys.fn_trace_gettable function).