Viewing 15 posts - 2,101 through 2,115 (of 39,771 total)
An index might help.
I think your situation is similar to Pinal's, as in there are two processes that are colliding. If your update is really each updating one row, you...
March 1, 2021 at 6:31 pm
This might help: https://blog.sqlauthority.com/2015/02/02/sql-server-how-can-deadlock-happen-on-same-table/
March 1, 2021 at 6:02 pm
I've done a few Project Euler items. It's a good test for learning Python.
I think you are also looking only along the upper left to lower right diagonal. The problem...
March 1, 2021 at 5:59 pm
Sorry, hit enter. It would be good to understand if you want 1 or 2 fields in the result. The way you write this, I'm not sure. I think you...
March 1, 2021 at 5:38 pm
Some queries benefit from the cardinality estimator change (2014). Some do not. Whether it's most or a few in your situation is hard to determine without analyzing a larger workload....
March 1, 2021 at 3:51 pm
These are good for cross database dependencies, separating out the linkage between objects. This also lets you move the other object to a new db or a new instance and...
March 1, 2021 at 3:16 pm
You are welcome. Glad this worked.
No idea how/why WordPress does this, but I see a similar thing in my blog.
February 26, 2021 at 5:28 pm
I think it's easy to lose track of what an organization owns. We see this all the time at Redgate, where one org has licenses for our tools, but some...
February 26, 2021 at 4:56 pm
Good question. Not sure. I think you can alter your nickname, which gives you options.
February 26, 2021 at 4:43 pm
Upgrading is certainly a issue, but separate. UIs matter, and ensuring they limit confusion is an issue, not particular to this story.
February 25, 2021 at 6:37 pm
We tend to have small teams at Redgate, but we have many of them.
Note that not everyone moves every year. Plenty of people choose to stay with the same team...
February 25, 2021 at 12:38 am
Most people are happy with he/she being used, according to their personal preference. However, there are starting to be people that are uncomfortable with those forms of address and may...
February 24, 2021 at 11:42 pm
Crazy. In the nuclear plant, we were very strict with this. Password on post-it = pink slip.
We also disconnected the SCADA stuff from the external network. Everything controlled inside the...
February 23, 2021 at 6:56 pm
Perhaps, but not always: https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but
February 22, 2021 at 11:02 pm
Creating a new filegroup for everything does not always work. Space constraints are one reason for this.
This isn't to imply the solution is the only one or the one that...
February 22, 2021 at 2:32 pm
Viewing 15 posts - 2,101 through 2,115 (of 39,771 total)