@JoeObbish agreed. That is such an interesting question and, of course, a very interesting answer. @PaulWhite - I hate to be so reductionist; and most likely I'm misunderstanding your answer, but, is the issue simply the fact there is a join on a computed column?
It's interesting to me that one would want to join on a computed column. Not something that must come up all that often, I imagine.
@AaronBertrand The code has a cursor for @tmp2 that updates the table with some conditions but the cursor itself has no ORDER BY. That might be a reason for indeterminate results, correct?
It's already the case that links deemed 'reputable' don't have nofollow (though the exact details are deliberately vague, and even the links in this heavily upvoted post by our top user on dba.se don't qualify).
My suggestion is that links to sites already deemed reputable by another means — vot...
sys_op_map_nonnull() is documented in 12c (sort of): http://docs.oracle.com/database/121/DWHSG/basicmv.htm#DWHSG8216
Original link from: @xtner http://orasql.org/2014/02/10/sys_op_map_nonnull-is-in-the-documentation-now/
@ypercubeᵀᴹ that could lead to rows in the table being updated in an unpredictable order, but not differently (it will still make the same update to all of the rows, unless there is a TOP or some break condition).
@AaronBertrand The cursor seems to want to put into @tmpCurrentMC a ROW_NUMBER() OVER (PARTITION BY OrderNo). But iff the cursor is not processed with ORDER BY OrderNo, ..., then it may get all 1s.
@ypercubeᵀᴹ Yeah I should have read the code closer. But it's so ugly. That these are table variables and cursors in the first place scared me away from the question.
@ypercubeᵀᴹ I prefer SELECT * from (SELECT top 1 pitabread, meat, onions, vegetables, cabbage, sauce, chilli, tomatoes from menu where ONIONS = 1 and CHILLI = 1 and MEAT = 1 and SAUCE = 1 and TOMATOES = 1) as DÜRUM
Just realized the big advantage of having Windows Accounts as SQL Logins: You don't have to link SIDs with sp_change_users_login when migrating databases from one server to another.
The people I work with think its a good thing to use WITH ENCRYPTION to prevent devs seeing a proc that does EXECUTE AS xxx. Security through obfuscation rears it's ugly head.
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...
>Don’t be too reluctant to use kick-mute – if you wait with kicking until everyone hates the person, they’re gonna have a hard time coming back and it may take too long to get a moderator involved. Kick at the first sign of trouble, and be ready to forgive and forget if they correct.
@PaulWhite oh, no doubt. But when I said 2012 was new, what I really meant is we're slowly migrating to the new platform. We still have plenty of 2000 instances, and a bunch of 2005/2008/2008R2 instances.
right. i get it. it just never "felt" right to me, for some reason. i know there's not logic in "feeling" a RDBMS version ... it was just a sense i had.
@MaxVernon we just sunset our last 2000 and 2005 instances last year so you're not too far behind us
I was hoping STRING_AGG would make it into 2016 SP1, especially with all the other things added or opened up there. After all, it barely missed the 2016 RTM cut.
If you are the perpetrator of serial up/down voting that's been reversed, if you revisit the item you voted on, does it still show as having been voted?
@JoeObbish lol, I did think it might, without actually checking. However, I figured if you're going to "sentence case" more than 2 billion rows, you might have bigger problems.
Does any one know about this error as I try to make a drop down list using the ssrs
An error occurred during locat report processing.
An error has occurred during report processing.
The processing of FilterExpression for the tablix ‘Tablix2’ cannot be performed. Cannot compare data of types System.String and System.Char Please check the data type returned by the FilterExpression
> The float and real data types are known as approximate data types. The behavior of float and real follows the IEEE 754 specification on approximate numeric data types. Approximate numeric data types do not store the exact values specified for many numbers; they store an extremely close approximation of the value. For many applications, the tiny difference between the specified value and the stored approximation is not noticeable. At times, though, the difference becomes noticeable. Because of the approximate nature of the float and real data types, do not use these data types when exact n…
This is a question of address canonicalization and parsing. Essentially what you're talking about is handled through a gazetteer (geographical rule set). There are two ways to do this right,
address_standardizer from the PostGIS project and certainly better if you're only using United States ad...
@TomV oh hail no. i'm not smart, prolific, or helpful enough
@AndriyM oh yeah. lexmark is mvp too. i've honestly kinda stepped away from all of that community thing. i like the folks i like and i like doing what i like to do. i'm not particularly involved in the who's who. not that it's bad if someone is ... i've just got too many spinning plates at this point.
When @Lamak was named an MVP @billinkc replied with something along the lines of "they'll allow anybody in nowadays". I mistakenly thought @swasheck was an MVP and tried to back out my mistake by making a somewhat lame joke. @swasheck got it in the sense that It was a double burn (on him and on Kamal) but that didn't make the joke any better
When I first started here, I saw a query that is about 75 lines of code that returns a two-row dataset, with one column. StartDate. The resultset is the same every time it runs, and it runs many many times per day, with a total shite plan.
@JoeObbish i have colloquial evidence that suggests you need to know how to code, otherwise you can expose your instance to some pretty nasty memory leaks that are not under SQL Server memory management
and even if you were super-hyper-crazily-fastidiously vigilant with your standard, static workload, i'd not suggest turning off auto-update stats. i do advocate for proactive stats management.
This is a question of address canonicalization and parsing. Essentially what you're talking about is handled through a gazetteer (geographical rule set). There are two ways to do this right,
address_standardizer from the PostGIS project and certainly better if you're only using United States ad...
