On Conciseness...
I had the privilege of writing a guest post on Mike Walsh's blog, entitled:
Conciseness
It's simply about being concise in our...
2009-12-09
779 reads
I had the privilege of writing a guest post on Mike Walsh's blog, entitled:
Conciseness
It's simply about being concise in our...
2009-12-09
779 reads
This was the first meeting where I really lead most of the meeting. Andy Warren (@sqlandy) did the networking at...
2009-12-09
365 reads
Had a message waiting on my phone this morning that there was a system upgrade available. Interesting, think it’s the...
2009-12-09
232 reads
I wrote an editorial last summer asking people what type of protection they had for their home setup. I got...
2009-12-09
706 reads
There seem to be many different methods being suggested to calculate an age in SQLServer. Some are quite complex but...
2009-12-08
1,131 reads
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on...
2009-12-08
1,239 reads
We've had the ASK SQLServerCentral site up for a couple months now and while I see traffic continuing over there,...
2009-12-08
593 reads
Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...
2009-12-08
450 reads
I note these for Database Weekly, but I haven’t blogged about them. A mistake on my part.
The December patches from...
2009-12-08
500 reads
In the last RAID article we covered the basics. This is a little deeper dive into the underlying mechanics of...
2009-12-08
1,523 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers