Update to TRUNCATE TABLE in SQL 2016 (partition support)
Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.
This...
2016-04-12 (first published: 2016-03-29)
2,769 reads
Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.
This...
2016-04-12 (first published: 2016-03-29)
2,769 reads
I’ve been playing around with partitioning quite a lot recently and wanted to write a quick post about how it...
2016-04-05 (first published: 2016-03-24)
1,714 reads
It’s been a while since I’ve posted as the run up to Xmas last year and this January have been...
2016-01-29
774 reads
I know I only posted one other blog about Pass but I’ve been way too busy over the last couple...
2015-11-01
315 reads
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
496 reads
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
288 reads
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
636 reads
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
356 reads
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes...
2015-07-20
992 reads
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes...
2015-07-20
364 reads
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
Have anyone implemented CDC, and if so, what has been your experience with it?...
I'm getting a error when using the Import and Export wizard to copy tables...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers