Webinar: Using SQL Storage Compress by Steve Jones and Brad McGehee
Steve Jones and Brad McGehee lead you through real-world examples of working with SQL Storage Compress
2013-05-15
316 reads
Articles
Forwarding Pointers in Heaps
When no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances where you have heaps.
2013-05-15
3,128 reads
2013-05-15
3,345 reads
Converting Large Object Data Types
Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.
2013-05-14
4,859 reads
Case Study: Designing Scaled-Out Architecture
On Thursday May 16th 12PM Central time, Robert Davis will discuss public facing websites on a global scale when looking at Data Architecture.
2013-05-14
3,400 reads
How to Synchronize Two SSAS Servers
Unfortunately SQL Server Analysis Services (SSAS) does not support differential backups and creating full backups for the servers might take too much time. In this tip we are going to show how to synchronize two SSAS servers in order to have a failover server in case something goes wrong with one of the servers.
2013-05-14
3,409 reads
2013-05-14
2,764 reads
Loginless In Seattle
Identify orphaned Database Users and differentiate them from "Loginless" Database Users.
2013-05-13
3,145 reads
2013-05-13
5,019 reads
The Ten Commandments of SQL Server Monitoring
It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring.
2013-05-13
8,102 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
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