I must say, I'm surprised this answer apparently went totally unnoticed yesterday. I was expecting at least a comment from someone say "eh, CHECKSUM??!! That's CRAAAAAAPPPPP"
I am investigating using the READPAST hint to reduce resource locking in our application's financial subsystem. It seemed like a good way to go because financial transaction records are only ever added, never updated or deleted. The only rows that would ever be skipped are brand new rows inserted...
I was thinking the answer would be along the lines of the query optimizer doesn't know what the indexed view might looking at without a lot of extra work, making the readpast hint unusable.
but what do I know about that kind of thing... not a lot.
We recently had this discussion at my workplace.
First, I want to commend you for doing the "right thing" by using HASHBYTES() over CHECKSUM() to detect changes. Microsoft specifically cautions against using CHECKSUM(@input) for this purpose as its collision rate is very high compared to that o...
Always frightens me when people post questions on here with stuff that looks like banking code, and they're migrating to MySQL. Shudder. dba.stackexchange.com/questions/182681/…
@Philᵀᴹ I remember one time I saw a question posted in SO by a coworker. How did I know?, because he was using our tables in his code, with a schema for his user, real table names and posted real data as a sample....
Anyone ever set RCSI as their default isolation level across an org without testing every app? I understand the implications, just gauging risk / reward. We’ve had many performance issues that would be solved by using RCSI, and I haven’t heard of or seen any issues with the 10-20 servers we’ve se...
@Lamak I found the full source code to an ex-employers very expensive billing & rating software, all on GitHub. I contacted them & it took ages for them to get GitHub to take it down. Ended up being a DMCA github.com/github/dmca/blob/master/2017/2017-05-15-Amdocs.md
@PaulWhite well, i'm glad i'm not the only one who drinks alone here
@Philᵀᴹ we've found a lot of our code and training material on various code hosting sites. usually contacting the user who posted it gets things taken down pretty quickly.
@PaulWhite I must apologize - I was under the impression you were tea-total. And now I think about it, I think I may have made that incorrect assumption before.
Not at all. You don't really think some random on the internet cares one way or the other whether you have a picture or an identicon. It's a thing because it has comedy chat value.
@PaulWhite This is particularly true when ypercube™ answers your questions... I always picture this floating tesseract entering the room and giving me an answer... "oh, thanks mr. tesseract"
The READPAST hint is semantic-affecting. Reusing the example table and indexed view from my article Another Reason to Use NOEXPAND hints in Enterprise Edition:
CREATE TABLE dbo.T
(
col1 integer NOT NULL
);
GO
INSERT dbo.T WITH (TABLOCKX)
(col1)
SELECT
SV.number
FROM master.dbo.spt_v...
A live action role-playing game (LARP) is a form of role-playing game where the participants physically act out their characters' actions. The players pursue goals within a fictional setting represented by the real world while interacting with each other in character. The outcome of player actions may be mediated by game rules or determined by consensus among players. Event arrangers called gamemasters decide the setting and rules to be used and facilitate play.
The first LARPs were run in the late 1970s, inspired by tabletop role-playing games and genre fiction. The activity spread internationally...
You will never fully cook away alcohol, only reduce the amount. See Alcohol retention in food preparation, or for the quick table, see wikipedia.
They covered this on an episode of America's Test Kitchen, and concluded that surface area matters -- a wider vessel would cook off more alcohol; it ...
What tools are available to room owners?
Room owners are users that have some elevated permissions in a chatroom. Typically, they will be the first line of defense when it comes to inappropriate content or behavior in a room. Users will look to the room owners to guide the room. The room owners...