Partitioning Basics – Part 2 – Splitting/Merging Partitions
This post follows on from the previous post Partitioning Basics – Part 1
Let’s have a look at the partitions setup in...
2014-06-12
1,056 reads
The DBA Who Came In From The Cold
Partitioning Basics – Part 1 – Creating Partitions
Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of...
2014-06-09 (first published: 2014-06-04)
5,088 reads
Error Log Management
Thought I’d write a quick post about managing error logs within SQL Server. Good error log management is essential for...
2014-05-09
2,427 reads
Database Design Guidelines For Developers
One of the developers that I work with asked me to write a “brief” (really brief) guide on database design....
2014-04-07 (first published: 2014-04-03)
25,850 reads
SQL Server 2014 RTM
The new version of SQL Server will be here on Tuesday.
(Someone at Microsoft has a sense of humour in releasing...
2014-03-30
1,513 reads
Index Fragmentation
So you’ve setup a bunch of indexes in your database to tune the queries coming in. They’re all running much...
2014-03-13
2,479 reads
Who are your victims?
Or….deadlock notifications.
In my previous post I talked about having your own database(s) and what information you could be collecting. One...
2014-02-11
595 reads
Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,024 reads
Shutting down multiple servers with Powershell
I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a...
2014-01-09
551 reads
Happy New Year!
Happy New Year!
Hope you all had a good Xmas, ate too much, drank too much and are still telling yourselves...
2014-01-02
326 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers