SQLSaturday #40 is Almost Here – July 31, 2010
I’ll be leaving Friday morning with my family to go to Miramar, Fla, for the 2nd annual SQLSaturday there. I’m...
2010-07-29
528 reads
I’ll be leaving Friday morning with my family to go to Miramar, Fla, for the 2nd annual SQLSaturday there. I’m...
2010-07-29
528 reads
Ok, now that I have your attention this really should be titled the danger of not qualifying all objects, but...
2010-07-29
739 reads
--it is
quite startling to see that this, in TSQL, executes.
Select \
/*
---------------------
0.00
(1
row(s) affected)
so does
this....
*/
Select null /\/\/\/\/\/\/\/\/\/\/\/\
/*
---------------------
NULL
(1
row(s) affected)...
2010-07-29
5,818 reads
In this quick blog, I want to show you one way of how to find out what indexes you have on a table...
2010-07-29
486 reads
Now that we are into the third quarter of 2010 I decided to post an update of my 2nd quarter...
2010-07-28
1,011 reads
Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up...
2010-07-28
388 reads
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule...
2010-07-28
801 reads
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
552 reads
Happened to notice in my weekly LinkedIn update today that Todd McDermid had signed up for the 2010 Summit event...
2010-07-28
792 reads
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as...
2010-07-28
641 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