« first day (4796 days earlier)      last day (63 days later) » 

1:41 PM
Wordle 977 5/6*

⬛⬛⬛⬛⬛
⬛⬛⬛⬛⬛
⬛🟩🟩🟩⬛
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩
 
 
1 hour later…
2:48 PM
Somewhat froggy
 
3:23 PM
@PaulWhite I love how you have a space between the CTE and the body of the INSERT INTO query here. It's almost as if the CTE is its own structure, like a temp table or something. Seems adoptable.
it threw me for a loop for a second
 
3:38 PM
he used some White-space 😎
 
nice one
 
3:58 PM
@HannahVernon That one was a goody. Learned a lot besides it being a very useful solution.
 
4:14 PM
Wordle 977 4/6

⬜⬜⬜⬜⬜
🟩🟨🟩⬜⬜
🟩🟩🟩🟩⬜
🟩🟩🟩🟩🟩
 
@J.D. I like the thoroughness of the TVF at getting rid of "illegal" dos characters
 
4:35 PM
Normally I don't try to solve before 4, but today, I made an exception
Wordle 977 3/6

⬛⬛⬛⬛⬛
⬛⬛🟩🟩🟩
🟩🟩🟩🟩🟩
I have to move my database over from the old computer, but I think that was the only possible word left
Looks like one other possibility
 
 
1 hour later…
5:43 PM
@CadeRoux I thought the aim was to solve in as few steps as possible?
 
 
2 hours later…
8:05 PM
I though the aim was to make it look most ranine
 
Good point
 
8:36 PM
@HannahVernon The strategy I used to employ was to try 3-ish very different words. That way, I get a lot of hints, and then I can usually make pretty accurate guess. It's kinda playing it safe.
But going straight to the point is more fun, IME.
 
8:57 PM
@Yano_of_Queenscastle I sometimes start with CRWTH just because its fun. I'm not convinced it's a good strategy, but it seems to work fairly well.
 
@HannahVernon I have no idea what the word means, but it sounds pretty badass.
 
its Welsh, hence the lack of vowels lol
means a crowd essentially
I was super surprised when it accepted it
I just looked it up, and unbeknownst to me, it also is a kind of violin
also, what is the point of adding two letters to the end of a constraint, such as a primary key being primary_key_pk or clustered_index_cx? Far better than putting it at the front, but it's so easy to lie like that.
CREATE TABLE [dbo].[why_oh_why]
(
    [i] int NOT NULL
        CONSTRAINT [why_oh_why_pk]
        DEFAULT ((0))
);
Which beggars the question, when is a pk not a pk?
When it's a default.
I mean why not just forgo the name of the constraint entirely; it's not like you ever need to really look at the name
ala
CREATE TABLE [dbo].[why_oh_why]
(
    [i] int NOT NULL
        DEFAULT ((0))
);
come to think of it, why the double brackets around the default lol
muscle memory
I suppose one could ask what's the point of adding anything after "why", too.
 
 
2 hours later…
10:56 PM
is there a way to use a query hint in an inline table valued function? I'm assuming it's impossible after looking at the docs.
I don't really need to use one, just more curious than anything
 
11:17 PM
General wisdom against putting object type into its name says it's because
A. it should be obvious from context (and from context you can easily deduce you are dealing with a constraint)
B. the IDE is going to tell you
But does B. apply to MSSQL? SSMS isn't exactly great IDE. (It's management studio, not development studio :/) Or is ADS/VS/VSCode better? Does SQL Prompt save the day, here?
 
for my money, you have to script the object if you're interested in anything about it aside from the name.
 
@HannahVernon I have a lot of databases with same-ish schema and I want the same objects to have same name. Autogenerated names aren't the same. Granted, necessity to deal with contraints globally is mostly theoretical.
 
in SSMS, you can see the type of constraint by its icon
which admittedly is crap
 
@HannahVernon I didn't realized that, thanks for tip.
 
@Yano_of_Queenscastle I worked on several instances a while back that had over 20,000 databases with the same schema, so I feel ya
also, don't do that lol
it's painful
 
11:23 PM
I'll take your word for it, and won't try it at home.
...or at work, for the matter.
 
startup is brutal if the instance is not shutdown cleanly because of all the IO needed to ensure consistency, just for starters, never mind using the object explorer in SSMS
There was a fun question asked on main about it a while back
not sure but some of that may be out of date
 
11:50 PM
Good reading.
 

« first day (4796 days earlier)      last day (63 days later) »