A Minor Rant About Statistics
If you've ever taken a look at the auto generated statistics that SQL builds (typically on non indexed columns when...
2008-03-19
1,339 reads
If you've ever taken a look at the auto generated statistics that SQL builds (typically on non indexed columns when...
2008-03-19
1,339 reads
Had lunch with a friend in the business yesterday that is involved with vulnerability scans for a large company and...
2008-03-18
1,585 reads
Tjay Belt forwarded me the information about the Utah Code Camp this year. Still early in the process, no schedule...
2008-03-18
1,524 reads
Just a reminder that the event is this Saturday. The tentative schedule has been posted and it looks like I'll...
2008-03-17
1,487 reads
I've been emailing back and forth with IndyTechfest organizer John Magnabosco over the past year as we've traded notes about...
2008-03-16
704 reads
Saw a mention of this in the latest MSDN Magazine, you can download Reflector.SQL2005Browser and install it as an add-in for...
2008-03-13
800 reads
Yesterday I posted Building YOUR Brand that described a formula for becoming rich and famous. Well, perhaps richer than you are...
2008-03-12
560 reads
Between teaching classes, attending community events, and participating in the local user group I get to have a lot of...
2008-03-11
676 reads
Just spoke with Brian this morning to get an event update for SQLSaturday #3:
122 attendees registered so far (event is...
2008-03-11
483 reads
Friday I gave another iteration of our free Sucessful Technical Speaking class, upgraded some since the last version, and this was...
2008-03-10
551 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
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