Free tool supporting many styles of code, integrated in SSMS. Users can create and share formatting profiles. Anybody has experience with leveraging this for uniform SQL coding style and thus easy cooperation between different developers?
Hi, In my applications that I've build so far in my training, i've struggle finding a way to change the format of dates shown in my pages. At the moment it's like this: mm/dd/yyyy But what I want is this: dd-mm-yyyy What is the proper way to achieve this?
I have a list with orders but the multi select won’t work in this list in Universal. In all other lists the multi select is working normally. We’re on 2023.3. In the WIN GUI it works. The grid is not in edit mode. Is there a feature I’m not aware of where we can turn off the multiselect in a grid?
Hi, I have a view that calculates the total volume. The results on my machine in vscode and ssms are fine. Also, the local gui is fine, both web and universal. However, in the web this happens; This also happens in the Universal gui. I suspect a local setting, since locally hosted (universal) and local win gui are fine. Not the most important , but it keeps me up at night.. .Perhaps a simple fix that I've overlooked? Thanks ! Alexander
We have a requirement for which we need to ensure that in a set of rows at least one of the rows does not have an end-date. In below example it should not be allowed to add an end-date to test=3. @Robert Jan de Nie Is it possible to use check constraints to prevent this?
I have a problem with performance. The thing is there is a huge insert trigger which does all kinds of things when inserting an order. The insert trigger also inserts in a lot of other tables, causing a lot of insert triggers to go off. The strange thing is. The first time I insert something, the performance is just awful. The 2nd time I insert in the table, the performance is way better. I bet this has something to do with the SQL server caching stuff. An example is inserting an order based on a huge calculation took 13 seconds. The second time i did this it only took 2.8 seconds. We know this big 'trigger party' is a problem, but this is the way it works; the 3 seconds is acceptable, but 13 is not! I'd love to know if there's a way to see what is increasing this performance this much (like a cache) and is there a way to always achieve this? Like force caching stuff? Who can help me with this issue?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
