2009-10-13
3,014 reads
2009-10-13
3,014 reads
Part two of his series on table schema changes, this article examines those changes that affect the actual data. Read this great article from Alok Dwivedi.
2009-08-05
4,978 reads
What happens behind the scenes when you alter a table schema? New author Alok Dwivedi dives deep into SQL Server to show us how things are affected.
2009-08-03
7,777 reads
2009-04-07
3,325 reads
2009-02-24
4,117 reads
2008-11-11
2,951 reads
2008-11-05
3,629 reads
2008-09-17
3,092 reads
2008-08-27
3,120 reads
The transaction log is a fairly complex construct in SQL Server and present in every database installation. New author James Rea brings us a great introduction to how the log works and how to maintain it.
2009-11-06 (first published: 2008-07-02)
39,578 reads
By Steve Jones
If you attended my talk at SQL Saturday Los Angeles 2022, then you can...
By Steve Jones
One of the things I did often in my first career job was create...
Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive...
Hi all! I'm trying to understand how does this work. I've read a thread...
I have a need to update some data and also create a record of...
Hi. Looking for someone to help with a query I'm tring to run. I...