TSQL2sday #008 – Gettin’ Schooled
This months TSQL2sday is being hosted by Robert Davies of MCM and Microsoft fame, you can find his post here....
2010-07-13
800 reads
This months TSQL2sday is being hosted by Robert Davies of MCM and Microsoft fame, you can find his post here....
2010-07-13
800 reads
I have a great job. Actually it’s a fantastic job for me. I have flexible hours, I can work almost...
2010-07-13
372 reads
T-SQL is a very forgiving language. As long as you have the basic syntax of the statement correct, SQL Server...
2010-07-13
427 reads
I don't think I'm alone when I find myself having to convert several columns in my Data Flow from Unicode...
2010-07-12
1,006 reads
Degree Seeker Week at SQL University, Extra Credit
Welcome back to Degree Seeker Week at SQL University. If you have returned...
2010-07-12
1,749 reads
This is something we had to do again recently and its improved our performance and query speeds on one particular system....
2010-07-12
944 reads
This post is a tad overdue as the public announcement was a few weeks back but it’s been a topsy-turvy...
2010-07-12
446 reads
I get a lot of emails from people who read my blog, books, articles, and from people who have attended...
2010-07-12
504 reads
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-12
381 reads
As a child did you have a place that was your ‘thing’, something that just the mention of it would...
2010-07-12
509 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