I have a bit of a newbie question, which I feel I should really know having dealt with databases for so long, but...
I know the general advice for indexes is NUSE, but a lot of my tables have a non-unique column that is a not-quite-foreign-key from another table, and will be 90% of the predicat...
"These climbs may seem tame your first few laps but we promise you that by the end of the race you will understand why they have earned names such as "The Soul Crusher" or "Hallucination Hill"."
@SeanGallardy for clients, yes. we have done some azure work, but sql db is painful because you dickshits can't figure out what dmvs to include from day to day
but the optics of someone relaxing a beach wearing sunglasses telling database people that a feature they've used for years is suddenly no longer supported aren't very good, no?
What is the internal algorithm of how the Except operator works under the covers in SQL Server? Does it internally take a hash of each row and compare?
David Lozinksi ran a study, SQL: Fastest way to insert new records where one doesn’t already exist He showed Except statement is the fastest for...
Historically, it has been recommended not to use the default ports for connections to SQL Server, as part of security best practice.
Which was asinine then and still asinine now. Security through arguably obscurity isn't security at all.
Is this advice still relevant
IMHO it was never ...