Viewing 15 posts - 3,271 through 3,285 (of 39,726 total)
Uniqueness isn't something you need for the clustered index. The choice of clustering key is usually something that is increasing and not often changing, like an id or date field...
October 9, 2019 at 10:24 pm
You can, however, move the FQDN to a new IP. This doesn't necessarily mean a linkage to the SPN. I can have a CNAME or ALIAS for connectivity and a...
October 9, 2019 at 2:36 pm
I'm confused. You say 1 instance of SQL 2012, but mention VMs. Are there separate VMs for other things or is this related?
I agree with the above, but I also...
October 9, 2019 at 2:35 pm
You can read about them here: https://www.sqlservercentral.com/steps/stairway-to-t-sql-beyond-the-basics-level-2-writing-subqueries
October 9, 2019 at 2:24 pm
I don't think there is any setting for this. AFAIK, if you add column in the middle of the designer, this causes a table rebuild. If you add at the...
October 9, 2019 at 2:23 pm
You can set up a load balancer to handle the networking part. SQL Server doesn't handle IP redirection. If the application is using IP to connect, that's a fundamental problem....
October 9, 2019 at 2:08 pm
Everybody can shift work around if a system is down, and they have. However, there's a cost. The reason we try to build systems that can run with hot patches...
October 9, 2019 at 1:58 pm
Those are good tools, but are you asking about tools to see the plan, or how to understand it quickly?
October 8, 2019 at 6:21 pm
Ah, you're right, Drew. I was thinking this was a code replacement that would leave the WHERE, but that would work. However, it's also a PR to upstream modules, not...
October 8, 2019 at 4:52 pm
I would urge you to product a real result set, which can be with inserts into another table. This will help you be sure you've correctly identified things and make...
October 8, 2019 at 4:17 pm
Be good to see what you mean by grouping. Show some results. FWIW, this is why testing is a good way to get set up for queries: https://www.sqlservercentral.com/articles/using-tsqlt-tests-to-practice-queries
October 8, 2019 at 3:14 pm
That's the view of someone that sees these systems serving a few humans. These days systems serve other systems, humans around the world, and they can be live 24x7 for...
October 8, 2019 at 2:59 pm
I've run into people that were sure you couldn't index unless this was persisted.
October 8, 2019 at 2:55 pm
Fair point, and I'll reword.
October 7, 2019 at 5:55 pm
This does change some parameterization stuff, but I think it prevents simple mode, which I'm not sure would be used here. Not sure, and haven't dug into this as other...
October 7, 2019 at 3:15 pm
Viewing 15 posts - 3,271 through 3,285 (of 39,726 total)