Viewing 15 posts - 1 through 15 (of 82 total)
I prefer pipe-delimited over tab out of habit, but the prevalence of commas inside data fields has made me utterly despise csv. Excel's poor handling of csv files certainly has...
June 22, 2021 at 4:32 pm
I was thinking that a TIE Striker wasn't a thing until I looked again at "Klingon".
May 4, 2020 at 7:33 pm
It has happened once before that identical answers were correct. People who picked the "wrong" correct answer were later credited.
January 30, 2020 at 1:36 pm
I agree, CHOOSE and IIF both seem to be either special cases of CASE or linking to a reference table. Having a reference table is far easier to maintain than...
January 22, 2020 at 2:31 pm
I started in Access too. Its SQL version of queries was a great assistance in learning to write queries in T-SQL, though the formatting is atrocious.
Conversely, learning SQL made me...
November 19, 2019 at 2:34 pm
I do not know if my method is faster or slower, but I would do it with a subquery:
select m.lowest_id
, p.first_name
from dbo.person p join
(select...
November 4, 2019 at 4:43 pm
A tester walks into work wearing an outfit.
A tester walks into work wearing 2 outfits.
A tester walks into work wearing an outfit and a lizard.
October 31, 2019 at 4:36 pm
I think the question is broken, the correct answer is 'Jan 18 2019 8:23PM'
🙂
That's what I got when I ran it, after assuming that the date mismatch was a...
September 27, 2019 at 1:22 pm
Good question but imho the best answer was not on the list of choices. It would be better to use ORIGINAL_LOGIN() instead of USER_NAME().
It seems to me that the...
September 20, 2019 at 4:55 pm
Alternatively, put a WHERE clause on the statement so it won't have unnecessary IO of updating rows that don't need to change.
August 2, 2019 at 12:31 pm
You can also potentially pull the table information from tempdb.information_schema.columns and build the CREATE script from that. More steps, but reasonably quick after you've done it a time or two.
June 24, 2019 at 5:23 pm
Changing monitoring intervals, or suppressing additional alerts, is something that needs to happen as well. Too easy to keep sending the same thing over and over. However, that's a...
June 20, 2019 at 12:26 pm
This article reminds me of the alert fatigue that hospital staff (And fast food staff, it tends to be as much of a cacophony behind the counter these days) are...
June 19, 2019 at 12:32 pm
Minor typo: "occures" should be "occurs".
I had a suspicion on seeing that question that I would find an unpleasant surprise underneath. Good to know to check for the filename before...
May 23, 2019 at 12:33 pm
There IS an even more secure method but is well beyond the requirements of this question.
Create a view with the columns or where criteria that you intend to provide...
May 14, 2019 at 12:35 pm
Viewing 15 posts - 1 through 15 (of 82 total)