SQLSaturdays
Can you believe that I have never attended a SQLSaturday (http://www.sqlsaturday.com)? Well, that is changing very soon. You will see me at...
2010-09-08
836 reads
Blog Posts
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to...
2010-09-08
1,732 reads
Tuning Tip: Identifying Overlapping Statistics
Statistics are used by SQL Server's query optimizer to help determine the most efficient execution plan for a query. When...
2010-09-08
2,039 reads
At The End of the IO Road With C#
Previously I’ve written about doing fun IO stuff in C#. I found out that some of my old tricks still...
2010-09-07
1,879 reads
Auto Close – SQL Server
I ran into an issue recently where I had a third party supplied database set to auto close. I couldn't...
2010-09-07
2,995 reads
Book Review: Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the United States
Another choice brought about by wandering the local library, Rehnquist: A Personal Portrait of the Distinguished Chief Justice of the...
2010-09-07
591 reads
Links From Twitter
Normally, I try to stick to posting technical info or community stuff on the blog, but there were a couple...
2010-09-07
569 reads
More Notes on Live Meeting Presentations
Yesterday I did another presentation via Live Meeting, some thoughts from that effort:
Perf VC team did a great job making...
2010-09-07
431 reads
Please don’t Tweet this, but…
This is reprinted from my editorial in Database Weekly.
During some recent conversations, I’ve noticed an increasing tendency for people to...
2010-09-07
552 reads
Reminder: Introduction to Statistics Presentation Today at Noon
I’ll be doing a presentation titled Introduction to Statistics in SQL Server today (Sep 7, 2010) at noon for the...
2010-09-07
224 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