Top 6 Myths of Transaction Logs
Top 6 Myths of Transaction Logs I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I...
2010-03-10
4,518 reads
Blog Posts
Upgraded to Model
That's right, folks, I'm now a model. Or at least, a model DB. Tom LaRock released his most recent rankings and...
2010-03-10
566 reads
An Introduction to Data Compression in SQL Server 2008
This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008.
There is one thing every...
2010-03-09
1,276 reads
Blog Anniversary
Two years old. In March of 2008 I received a whopping 96 visits. I’m up to 1900 so far this...
2010-03-09
531 reads
Buying a Second Seat on the Plane
Saw this article about more elbow room, the premise being that is it is often cheaper to buy a second...
2010-03-09
347 reads
Easy Ways to Detect I/O Pressure in SQL Server 2008
It is pretty common for large, busy SQL Server instances to run into I/O bottlenecks. Even smaller, less busy systems...
2010-03-09
4,519 reads
Happy Belated International Woman's Day - C'est Votre Jour Les Femmes !
Yesterday was International Woman’s Day – Let’s take the time to honour a few great women at the top!
Firstly, to Her...
2010-03-09
1,017 reads
How to Easily Log SQL Server 2008 Instance Level Metrics
If you want to record the results of some useful, instance level DMV queries somewhere where you can easily query...
2010-03-09
1,149 reads
IO IO IO
Once again it is that time. It is TSQL Tuesday. This time it is being hosted by Mike Walsh. Mike...
2010-03-09
1,353 reads
My Adventures with the SQL 2005 Security Cache
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...
2010-03-09
494 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers