SQLStudies

My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and...

2012-09-02

4,115 reads

At Startup SSMS setting

I came across this handy dandy little setting earlier this year. It was well hidden from me, by which I...

2012-08-27

662 reads

In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...

2012-08-20

1,341 reads

Every organization I talk to has the same problem dressed up in different clothes....

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...

Ten years (and a couple jobs) ago, I wrote about naming default constraints to...

Comments posted to this topic are about the item The day-to-day pressures of a...

I am annoyed. We have a CMS server that has hundreds of servers saved...

Comments posted to this topic are about the item The Problem Isn't Always Your...

What happens when I run this code?

CREATE TABLE dbo.IdentityTest
(
     id int IDENTITY(10) PRIMARY KEY,
     somevalue VARCHAR(20)
)
GO