Transaction Logging & Recovery (101)
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
450 reads
Logging & Recovery Notes from SQL Server Logging, Recovery, and the Transaction Log (pluralsight) Paul Randal
Going to share some key points...
2016-01-05
450 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
209 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
186 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
213 reads
Documenting Your Database with Diagrams
Don’t get too excited. I know you love documentation, and just can’t wait to spend some...
2015-12-09
371 reads
Documenting Your Database with Diagrams
Don’t get too excited. I know you love documentation, and just can’t wait to spend some...
2015-12-09
1,145 reads
Best Tools for Taking Notes In Development
Developers have a lot to juggle. Do a few of these things sound familiar:
Juggle...
2015-10-14
643 reads
------------ UPDATE: 2016-04-08 10:12 ------------
Been working through some issues with Clarify app on my personal computer, something I messed up. @trevordevore...
2015-10-14
272 reads
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...
2015-09-23
382 reads
Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...
2015-09-23
918 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