A DMV a Day – Day 8
We have two related DMVs for Day 8. The first one is sys.dm_fts_active_catalogs, which is described by BOL as:
Returns information...
2010-04-08
1,250 reads
Blog Posts
A Good Expansion on the Topic of Plagiarism
In a previous post I gave some links which help explain what plagiarism is and how to generally avoid it....
2010-04-08
668 reads
Data-Driven Subscriptions at OPASS
Six months ago, I spoke at a SQLSaturday in Orlando, Florida. I had a great time. Andy Warren (Blog | Twitter),...
2010-04-08
336 reads
Early Planning for SQLSaturday Orlando 2010
I did an hour or so call with Jack Corbett recently to review what we hope to accomplish this year....
2010-04-08
279 reads
Q1 - review
I didn’t post my professional goals for the year on my blog at the start of this year, my blog...
2010-04-08
672 reads
Spring Training 2010
Life was busier than I would have liked this year, but made it to one game, Braves vs Tigers, for...
2010-04-08
279 reads
SQL University Starting Back Up
Jorge Segarra's ( @SQLChicken) excellent community idea, SQL University, is starting back up next week. This is effectively free training on...
2010-04-08
743 reads
What Do I Need to Do After Moving a Database to SQL 2005/2008?
Introduction
I recently moved a database from SQL 2000 to SQL 2005. It was really just a matter of detaching the...
2010-04-08
388 reads
2010 Goals – First Quarter Review
Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.
Community...
2010-04-07
478 reads
A DMV a Day – Day 7
I have three different DMVs for Day 7. The first one is sys.dm_db_missing_index_group_stats, which is described by BOL as:
Returns summary...
2010-04-07
1,223 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