The FILL FACTOR impact on the indexes fragmentation
This is a short post that is considering the indexes fill factor impact on the fragmentation. Analysis of indexes is a continuous process on the company’s databases that you,...
2015-04-01
8 reads
Blog Posts
The FILL FACTOR impact on the indexes fragmentation
This is a short post that is considering the indexes fill factor impact on the fragmentation. Analysis of indexes is a continuous process on the company’s databases that you,...
2015-04-01
13 reads
An Easter SQL
Since Easter is nearly upon us, I got to thinking once again about how challenging it is to calculate the...
2015-03-31
3,692 reads
Apress April Fools 40% Discount Promo & Healthy SQL
April 1, 2015 – I am delighted to take part in the April
Fool’s Promotion by Publisher Apress, who are
featuring some of...
2015-03-31
1,575 reads
Exam Prep 70-463: Logging in SSIS 2012
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...
2015-03-31 (first published: 2015-03-09)
7,168 reads
2015-03-31
1,516 reads
Microservices and Databases
I ran across a post on microservices recently and was intrigued. I always like the idea of loosely coupled, independent...
2015-03-31
2,777 reads
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to...
2015-03-31 (first published: 2015-03-21)
6,907 reads
PASS Board Update: March 2015
Hello all,
It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books...
2015-03-31
1,093 reads
Creating a large data warehouse in Azure
Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server...
2015-03-30 (first published: 2015-03-19)
7,701 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers