Viewing 15 posts - 2,101 through 2,115 (of 7,614 total)
That means that the task being run will be cancelled if it is involved in a deadlock. It doesn't mean that a deadlock will occur. -10 is the lowest priority...
December 1, 2020 at 4:37 pm
I provide the table structure, that's it. They are in SSMS session, so they can use whatever SSMS tools there are to view that structure.
Ah... therein...
November 30, 2020 at 12:08 am
The "trick" part of the query is determining the middle score. Many developers don't figure that one out.
In my own way I tried to help (sort of), since you can...
November 29, 2020 at 9:58 pm
I provide the table structure, that's it. They are in SSMS session, so they can use whatever SSMS tools there are to view that structure.
Ah... therein lies the...
November 29, 2020 at 9:46 pm
>> would hate having to be the DBA going to a place that Celko had designed / created. What a nightmare of missing leading zeros or added leading zeros...
November 29, 2020 at 9:26 pm
Here's another q I like to use:
"Bad data is getting into a prod table from an app. Developers have full data modification authority to that data and currently fix it...
November 29, 2020 at 9:09 pm
But, by definition, an identifier is on a nominal scale and nominal scales are never numeric.
That's really a mistake on your part to think so in...
November 29, 2020 at 6:24 pm
This is the main test q I use to test query-writing skill. It's not as trivial / obvious as it sounds at first.
A table contains 1, 2 or...
November 29, 2020 at 6:13 pm
As a drastic example of what I've talking about, say you asked an applicant to list all the columns from the table. Say the table has key_col, data_col1, data_col2. No...
November 29, 2020 at 5:56 pm
Scott - I agree with Jeff in the sense that this test is somewhat unrealistic because you have CTE's and sub queries at your disposal. However, if this is...
November 29, 2020 at 5:50 pm
Except that single outer apply will be executed for each row in the Meter table - and the data must be sorted each time based on the filters from...
November 28, 2020 at 1:31 am
Pretty good overall, reasonably close.
But:
the middle score will not necessarily be the avg score (sum/count is same as avg);
if there are fewer than 3 scores, leave extra scores NULL. For...
November 28, 2020 at 1:28 am
Just curious - but how are these solutions better than using multiple joins? If this is a performance related issue - fix the use of the upper functions on...
November 27, 2020 at 7:20 pm
Here's the table structure:
student_scores ( student_id int NOT NULL, assignment_number int NOT NULL, score int NOT NULL )
November 27, 2020 at 7:16 pm
Viewing 15 posts - 2,101 through 2,115 (of 7,614 total)