SQL Server 2012 Service Pack 1 CU1 is Available
Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 1, which is Build 11.0.3321. I count 44 fixes...
2012-11-20
1,460 reads
Explore file physical structure - Insert Row - part 1
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...
2012-11-20
684 reads
Explore file physical structure - variable length row
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...
2012-11-20
1,011 reads
Lost in Translation – Deprecated System Tables – systypes
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-20
953 reads
Rules of Holes #6: Don't Draw Others Into the Hole with You
In the Fifth Rules of Holes, you were encouraged to seek help from others in order to extricate youself from the Hole. And it should have been clear in...
2012-11-20
8 reads
Rules of Holes #6: Don't Draw Others Into the Hole with You
In the Fifth Rules of Holes, you were encouraged to seek help from others in order to extricate youself from the Hole. And it should have been clear in...
2012-11-20
10 reads
Blogging for Beginners
Last week at the PASS Summit, I had several conversations with several different aspiring bloggers, and found myself saying the...
2012-11-20
991 reads
Rules of Holes #6: Don't Draw Others Into the Hole with You
In the Fifth Rules of Holes, you were encouraged to seek help from others in order to extricate youself from...
2012-11-20
798 reads
Explore file physical structure - fixed length row
1. Create sample db
use master
go
CREATE DATABASE [test] ON PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB...
2012-11-20
1,080 reads
Master Data Services Web Services API Error
In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012...
2012-11-20
1,051 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers