Keeping SQL Server Client Tools Up-to-Date
In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...
2009-08-21
1,414 reads
Blog Posts
SQL Down Under Code Camp to be Held in October
If you live in Australia, or are just looking for an excuse for a vacation in Australia, sign up for...
2009-08-21
662 reads
SQL Lunch
Baton Rouge SQL Server group leader and recent SQL Saturday host Patrick LeBlanc is putting together a new learning series. ...
2009-08-21
701 reads
SQL Profiler – Wild Card Filter on TextData
WARNING: This may be very obvious to most of you. However, several people that I have encountered did not realize...
2009-08-21
37,270 reads
SQL Quiz #5 – SANs the Star the Show Must Go On(Mirroring)?
Okay, Jorge Segarra (@SQLChicken) tagged me in Chris Shaw’s (@SQLShaw) latest SQL Quiz, SAN’s and Mirroring. I’m a little behind...
2009-08-21
337 reads
The Kindle Update - A Month on the iPhone/iTouch
Ever since my Kindle broke, I've been reading on my iTouch for the most part. I've been using both the...
2009-08-21
774 reads
What happens when you use WITH RECOMPILE
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,325 reads
Costco & Blueberry Muffins
You’ve probably heard of Costco, one of those warehouse type stores that sells stuff in bulk. We buy stuff there...
2009-08-20
567 reads
Managing Your Database
It seems that I see posts like this one more often than I'd like. Or at least some variation on...
2009-08-20
864 reads
Practical or Silly?
I won $25 from Thinkgeek via Intel from a twitter contest. Can you follow that? I posted a question for...
2009-08-20
1,098 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