Simplify Your DBCC CHECKDB Output
"Defend Your Data"
If you’re a SQL Server Database Administrator and you don’t know what CHECKDB is then you need to...
2010-07-14
525 reads
"Defend Your Data"
If you’re a SQL Server Database Administrator and you don’t know what CHECKDB is then you need to...
2010-07-14
525 reads
Today, I received the official word that I will be presenting two sessions in the SQLServerCentral.com track at the SQL...
2010-07-14
888 reads
November will be a busy time of the year for many SQL Server DBAs as they head off to the...
2010-07-14
675 reads
One of the things I've been wanting for awhile is the ability to embed videos here on the blogs. It's...
2010-07-14
447 reads
Here’s another one that I’ve run into when linking to a SQL Server table that has a bit column. Maybe...
2010-07-13
332 reads
Advanced Troubleshooting Week at SQL University, Lesson 1
Welcome to Advanced Troubleshooting Week at SQL University. Once again, I’m your guest...
2010-07-13
5,426 reads
Join SQL Server MVP, Andy Leonard, tomorrow on the SQL Lunch to learn some snappy tips and tricks on Transact-SQL...
2010-07-13
627 reads
Observe and Report
This month we get to frolic in our memories of school days. Thanks to HeadMaster Robert Davis (Blog...
2010-07-13
792 reads
Pretty exciting stuff gang! I have an approved session and an alternate for the PASS Summit in November. The SQL...
2010-07-13
340 reads
Have you ever written a query that just seems to take forever? You have looked it over time and time...
2010-07-13
976 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