SQL Server 2008 and 2008 R2 Diagnostic Information Queries
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These...
2010-09-18
3,914 reads
Blog Posts
ACID
What’s ACID in databases? I was asked this in an interview a long time ago and I couldn’t remember the...
2010-09-17
2,199 reads
CakeWrecks
Recently I had a student point me to CakeWrecks, a blog about good cakes gone bad.The post from today has...
2010-09-17
552 reads
Do You Have Influence? Part 2
I started writing on influence last week and promised some comments on how to build influence and credibility. There are...
2010-09-17
1,357 reads
I Don't Want to Share!
I know we were taught to share in kindergarten, but there are some things that should not be shared. In...
2010-09-17
571 reads
MDX Aggregate Named Set Than Others
In this quick post I wanted to provide some code that's been useful to me recently. This MDX statement creates...
2010-09-17
2,471 reads
SELECT: If ON preceeds JOIN, then how….
I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night. ...
2010-09-17
489 reads
SQL Saturday #52 in Denver
Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held...
2010-09-17
637 reads
SQLSaturday #52 – Colorado Here I Come!
Well, I’ve been waiting to book hotel and rental car for SQLSaturday #52 – Colorado because I wasn’t sure if my...
2010-09-17
355 reads
StreamInsight sample from my 24HOP session
As announced in my StreamInsight session at 24HOP you can download the session material
from here.
Within the next weeks I will...
2010-09-17
536 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