SQL Server 2008 and 2008R2 Diagnostic Information Queries for June 2010
This version has updated build lists for SQL Server 2008 and 2008 R2. It also has several new queries, and...
2010-06-02
1,561 reads
This version has updated build lists for SQL Server 2008 and 2008 R2. It also has several new queries, and...
2010-06-02
1,561 reads
I guess I will join the trend, and list the session abstracts that I submitted for PASS Summit 2010. There...
2010-06-02
905 reads
I was never a big fan of temp tables, mostly because there were serious contention issues in SQL Server v6.5....
2010-06-02
1,011 reads
I have non-official info about the Microsoft event, and the only event, TechUpdate Prishtina, in Kosova. The event will be...
2010-06-02
506 reads
2010-06-02
636 reads
This month’s question had 21 responses, although a few were duplicates. The question was:
What is your favorite DBA joke?
If you...
2010-06-02
413 reads
Another recent editorial I wrote for SQLServerCentral talks about whether you would be happy doing your hobby for living. For...
2010-06-02
697 reads
For years, ever since I was first required to be on call, I’ve made it a habit to check my...
2010-06-01
627 reads
Hi guys, apologies for the delay with Day 13 – I’ve been sunning myself in the Canaries !
Every day for the...
2010-06-01
400 reads
Last week, Microsoft released a slightly improved version of Robotics Developer Studio that supports Visual Studio 2010, and adds the...
2010-06-01
1,468 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