Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for Alexei
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Edit | Post #278988 | Initial revision | — | about 4 years ago |
| Answer | — |
A: What is the point of tagging a question with both a parent and a child tag? I can provide an answer based on Stack Overflow experience. SO offered watches by tags. By using a general tag along with a more specific tag, users interested in [sql] will also get the question in their feed. While I could find this feature on Codidact, it makes sense to implement it in the futu... (more) |
— | about 4 years ago |
| Comment | Post #278982 |
Not sure, but shrink gets the database to 4GB and reindexing gets it to about ~5GB. (more) |
— | about 4 years ago |
| Edit | Post #278983 |
Post edited: removed meta related tags |
— | about 4 years ago |
| Edit | Post #278982 | Initial revision | — | about 4 years ago |
| Answer | — |
A: How can I can I reduce the size of a SQL Server database after being restored and massive embedded files stripped? One way to solve this is to shrink the database and reindex all tables to fix the indexes fragmentation: DBCC SHRINKDATABASE (TheDatabase); GO -- reindexing all tables to optimize performance after the DB shrink declare @TableSchema varchar(255) DECLARE @TableName varchar(255) D... (more) |
— | about 4 years ago |
| Edit | Post #278981 |
Post edited: added the question |
— | about 4 years ago |
| Edit | Post #278981 | Initial revision | — | about 4 years ago |
| Question | — |
How can I can I reduce the size of a SQL Server database after being restored and massive embedded files stripped? My project has the following set up for the production and preproduction ("clone") environment. - Production is not accessible at all for the development team, only the preproduction database. - Preproduction database is restored each day, but a post-restore script is run to strip away sensitive ... (more) |
— | about 4 years ago |
| Comment | Post #278952 |
@Moshi That's a good idea. I will raise an issue @ GitHub repo. Thanks. (more) |
— | about 4 years ago |
| Edit | Post #278959 |
Post edited: fixed code alignment |
— | about 4 years ago |
| Edit | Post #278959 | Initial revision | — | about 4 years ago |
| Answer | — |
A: How to create a delayed loading indicator when working with ngrx/store? This heavily relies on this question which deals with another matter. In order to delay the loader, there must be a clear difference between the start of loaded from the caller's perspective and when the loader is actually displayed (i.e. `isLoading = true`). The following code does the trick: ... (more) |
— | about 4 years ago |
| Edit | Post #278958 |
Post edited: added missing code |
— | about 4 years ago |
| Edit | Post #278958 | Initial revision | — | about 4 years ago |
| Question | — |
How to create a delayed loading indicator when working with ngrx/store? I am working on an Angular application using ngrx and I have a loader state + reducer that is used to display a loader. However, very short AJAX calls cause a flicker and I need to delay showing the loaded to avoid being shown for very fast responses (e.g. < 300ms). My state is very simple: ... (more) |
— | about 4 years ago |
| Comment | Post #278952 |
@Lundin Automatic removal would be really nice, but current caching makes things really confusing as shown in my example. (more) |
— | about 4 years ago |
| Edit | Post #278952 | Initial revision | — | about 4 years ago |
| Question | — |
Is there a way to add expiration for questions tags? Comments from this question reveal that there is some aggressive caching related to question tags (what tags are used for a question). Unfortunately, after changing tags for several questions I have realized that glitches are quite often. Example for [formula] tag: - search indicates 6 usages ... (more) |
— | about 4 years ago |
| Comment | Post #278785 |
On-topic now includes a quick introduction for those in a hurry (thanks to [this suggestion](https://software.codidact.com/questions/278648#answer-278666)). Having "a separate Meta post for every rule, and link to these canonical posts from the FAQ" is indeed possible, but leads to even more stuff to... (more) |
— | about 4 years ago |
| Comment | Post #278788 |
I understand what "questions asked not to learn, but to off-load work", but it might sound too vague for newbies. From my experience with SO, I know there is a large number of posts that show no effort or do not include any attempts. It is such a serious issue that I favor explicitly mentioning our e... (more) |
— | about 4 years ago |
| Comment | Post #278789 |
I have fixed it. Thanks. (more) |
— | about 4 years ago |
| Edit | Post #278625 | Post edited | — | about 4 years ago |
| Comment | Post #278650 |
This suggestion has been included. Thanks. (more) |
— | about 4 years ago |
| Edit | Post #278625 | Post edited | — | about 4 years ago |
| Comment | Post #278653 |
I have also updated the help to include a code review guideline and a designated item in the on-topic section pointing to it. (more) |
— | about 4 years ago |
| Edit | Post #278625 | Post edited | — | about 4 years ago |
| Comment | Post #278667 |
I have applied this suggestion, but also added an example to off-topic item "questions about computers or software that are not connected to software development/engineering" (asking for recommendations). Thanks. (more) |
— | about 4 years ago |
| Edit | Post #278625 | Post edited | — | about 4 years ago |
| Comment | Post #278666 |
Nice suggestion. I have added it as an introduction paragraph in the On-topic section as it kind of summarizes all the other points. Thanks. (more) |
— | about 4 years ago |
| Edit | Post #278625 | Post edited | — | about 4 years ago |
| Comment | Post #278651 |
I have applied your suggestion (in a simplified form, as "database design" is repeated). Thanks. (more) |
— | about 4 years ago |
| Edit | Post #278625 | Post edited | — | about 4 years ago |
| Comment | Post #278787 |
I have rephrased that item from the help section to correspond to your suggestion. Thanks. (more) |
— | about 4 years ago |
| Edit | Post #278625 | Post edited | — | about 4 years ago |
| Comment | Post #278786 |
I have updated the section to reflect your suggestion ("keep it simple"). Thanks. (more) |
— | about 4 years ago |
| Edit | Post #278625 | Post edited | — | about 4 years ago |
| Edit | Post #278922 | Initial revision | — | about 4 years ago |
| Answer | — |
A: What is our policy on tags? Thanks for raising this question. My answers to your questions: What type of tags will we allow? (Should specific tags like [UrlRewrite] be allowed?) I am not sure what is the best way to deal with this and I am waiting for community feedback. How many tags will we allow? (Should we delete a... (more) |
— | about 4 years ago |
| Comment | Post #278817 |
I agree with these points and I have used Stack Overflow as a model because they have the advantage of time and size. They have millions of questions asked over years and by now tags must be in a stable state. (more) |
— | about 4 years ago |
| Edit | Post #278324 |
Post edited: replaced tags with more meaningful ones |
— | about 4 years ago |
| Edit | Post #277932 |
Post edited: replaced tags with more meaningful ones |
— | about 4 years ago |
| Edit | Post #278322 |
Post edited: replaced tags with more meaningful ones |
— | about 4 years ago |
| Edit | Post #278360 |
Post edited: replaced tags with more meaningful ones |
— | about 4 years ago |
| Edit | Post #278366 |
Post edited: replaced tags with more meaningful ones |
— | about 4 years ago |
| Edit | Post #278523 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278525 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278531 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278567 |
Post edited: |
— | about 4 years ago |
| Edit | Post #278569 |
Post edited: added relevant tag |
— | about 4 years ago |