« first day (3818 days earlier)      last day (36 days later) » 

5:57 AM
Morning
 
Morning
 
6:14 AM
Morning
 
 
1 hour later…
7:27 AM
Morning
 
7:56 AM
1
A: Can I use assignment operator `:=` on a local variable in a SELECT statement?

nbkSession variables are go CREATE TABLE my_test_table(var INT DEFAULT 0); INSERT INTO my_test_table VALUES (3); CREATE PROCEDURE my_sp_test_function() BEGIN DECLARE localVar INT DEFAULT 1; #SET @userVar = 1; ### If we swap this line for the one above the query works. ### SELECT ...

I thought that was Thunderbirds
 
8:18 AM
A chairde - Morning all!
@PaulWhite ? Eh?
 
8:36 AM
Thunderbirds Are Go is a 1966 British science-fiction puppet film based on Thunderbirds, a Supermarionation television series created by Gerry and Sylvia Anderson and produced by their company Century 21 Productions. Written by the Andersons and directed by David Lane, Thunderbirds Are Go concerns spacecraft Zero-X and its human mission to Mars. When Zero-X suffers a malfunction during re-entry, it is up to life-saving organisation International Rescue, supported by its technologically-advanced Thunderbird machines, to activate the trapped crew's escape pod before the spacecraft hits the ground...
 
9:05 AM
 
9:26 AM
nice
 
Yes - it's more obvious looking at the post itself rather than the quoted section above...
 
Oct 11 '19 at 13:41, by Paul White
chat markdown strikes again
great user name
appealing default avatar as well
 
10:16 AM
would you prefer a puking image?
 
No! I love a Pūkeko!
@ypercubeᵀᴹ Are your comments on that N+1 question worth saving?
I do wish SE would make the revision history more obvious.
It's not even easy to find in the help.
 
what comments? ;)
 
sweet as
 
10:53 AM
@PaulWhite ah nice. I didn't know it was a bird!
 
Clearly it needs to work on its international reputation and reach
 
is it native in New Zealand?
 
@ypercubeᵀᴹ It is considered such, yes. Complicated and unclear history like many birds in NZ
 
11:15 AM
nice thanx
I was reading the wikipedia and the name Porphyria troubled me.
I guess their cousins leaving in Australia/New Guinea/Indonesia have more purple colour
or maybe they got the name from their beaks
 
yeah I don't know anything about those at all
 
And in Greek, I always thought Porfyros/Porfyra meant deep red, not purple
Tyrian purple (Ancient Greek: πορφύρα porphúra; Latin: purpura), also known as Phoenician red, Phoenician purple, royal purple, imperial purple, or imperial dye, is a reddish-purple natural dye; the name Tyrian refers to Tyre, Lebanon. It is a secretion produced by several species of predatory sea snails in the family Muricidae, rock snails originally known by the name 'Murex'. In ancient times, extracting this dye involved tens of thousands of snails and substantial labor, and as a result, the dye was highly valued. The main chemical is 6,6′-dibromoindigo. == Background == Biological pigments...
 
11:32 AM
interesting!
 
what emperors were wearing
 
11:49 AM
right
 
 
2 hours later…
2:09 PM
@HannahVernon Statistics build uses read uncommitted
16
A: How does sampling work when updating statistics?

Martin SmithFor WITH SAMPLE 50 PERCENT it works as though for each data page in the table SQL Server flips a coin. If it lands heads then it reads all the rows on the page. If it lands tails then it reads none. Tracing the UPDATE STATISTICS T WITH SAMPLE 50 PERCENT call in Profiler shows the following query...

(first example showing STATMAN syntax I found)
 
 
1 hour later…
3:27 PM
cheers
 
cheers
 
cheers
 
3:49 PM
cheers
 
 
4 hours later…
8:01 PM
Cheers
 
cheers
 

« first day (3818 days earlier)      last day (36 days later) »