Instant File Initialization Speeds SQL Server
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
2010-07-21
3,376 reads
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
2010-07-21
3,376 reads
I keep seeing lots of debate about Android v the iPhone 4. I have friends talking about how cool Windows...
2010-07-21
1,172 reads
Microsoft has released SQL Server 2008 SP1 Cumulative Update 9 (CU9). The KB Article for the CU is located here....
2010-07-21
898 reads
A bit of a silly title, but an interesting story. A few weeks back I posted a note about attending...
2010-07-21
605 reads
Tomorrow at 11:00 AM EST I will be giving a talk on SQL Server 2008 R2 for the DBA. Here...
2010-07-21
508 reads
Welcome once more to the Miskatonic branch of SQL University. Please try to concentrate. I realize the whipoorwills singing outside...
2010-07-21
676 reads
One thing I learned years ago in C programming was the elegance of using operators and simplifying expressions. This sometimes...
2010-07-21
736 reads
I’ll be speaking for the SQL PASSDatabase Administration Virtual Chapter next week. It’ll be on July 28 at 12 PM...
2010-07-21
609 reads
The SQL Server DMV Starter Pack is a free eBook (84 pages) that describes 28 different ways that DMVs can...
2010-07-20
4,904 reads
Hi! I’m SA! I’ll be your mentor during your stay at Innitrode! Actually, I’m everyone’s mentor here…anytime someone needs some...
2010-07-20
573 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...
WA:08218154393 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah...
WA:08218154393 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
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