SQL Server 2008 Data Compression Example
I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.
First, I identified...
2008-10-31
4,291 reads
Blog Posts
Follow Up to Blog Review Post
A month or so ago I posted Blog Review - Yours & Mine to see what I might get for feedback about...
2008-10-30
1,499 reads
New Books on SQL Server 2008
Since the release of SQL Server 2008, a slew of new books have been released, or are about to be...
2008-10-30
1,725 reads
The October 2008 Energy Update - So Much Passion
Do we have an energy crisis or not? Is global warming real? Are we being affected by burning fossil fuels?
I...
2008-10-30
1,457 reads
The Wise Old Man Part 2
In my previous post The Wise Old Man Part 1 I wrote about a great session I attended during SQL...
2008-10-30
1,586 reads
The Wise Old Man Part 1
During one of the sessions that I attended during SQL Saturday in Orlando I had the privilege of listening to...
2008-10-29
1,690 reads
Thoughts on .Net Reflector Being Acquired by Red Gate
This is an unpaid/unsolicited comment about a product now owned by Red Gate Software. Purely my opinions, and I'll try...
2008-10-29
1,602 reads
A Break
Only a small one, but I appreciate every one I get. Not often that I get to leave the site...
2008-10-28
1,472 reads
Effecting Change
Over the years Andy Warren, Brian Knight, and I have talked about PASS quite a bit. It hasn't always been...
2008-10-28
1,433 reads
Free/Cheap/Good HTML Editor, Is There Such a Thing?
For the past few years I've been using Frontpage 2003 for basic HTML work, usually to write content for SQLServerCentral....
2008-10-28
1,351 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