Why You Should Come to SQL Saturday #48 - Columbia, SC
SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in...
2010-09-22
942 reads
Blog Posts
Instant File Initialization – Is it Turned On?
I have posted a short note on instant file initialization previously, that post can be found here. The crux of...
2010-09-21
1,728 reads
On Vacation
I’ve hit that point where it feels like I need to work longer and harder to keep up, which is...
2010-09-21
581 reads
Putting Priorities into Practice
Yesterday I posted a review on the book Choosing to Cheat. I had begun putting some of the principles into...
2010-09-21
901 reads
September PASSMN Meeting Tonight
As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location. This is a ...
2010-09-21
434 reads
Software Review: Idera’s Virtual Database
Ever since the upgrade from SQL Server 6.5 to 7.0 one of the most requested features I’ve heard people complain...
2010-09-21
3,180 reads
SQL Saturday 50 (#sqlsat50) – A Tale
This past weekend I went to SQL Saturday 50 – this is a day long SQL training event that is put...
2010-09-21
820 reads
Table Variables and Transactions
I actually had a question of the day submitted on SQLServerCentral about table variables and transactions, but the person didn’t...
2010-09-21
9,338 reads
What Did that Geek Just Say?
The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...
2010-09-21
6 reads
What Did that Geek Just Say?
Working in a technical field has it’s ups and downs. One of the more common annoyances I run into is...
2010-09-21
325 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