SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: June 2011

A Welcome Break

I’m not working, though I have checked some email and kept an eye on a few things while I’m in Pensacola, FL. I have made an effort, however, to not work, and not respond to emails that weren’t very time critical. Mostly I’m just trying to prune down things that… Read more

0 comments, 450 reads

Posted in The Voice of the DBA on 6 June 2011

Duplicate Identity Values?

Can you have duplicate values in a field with the identity property? Of course, and this does it.

DROP TABLE dbo.MyTable

( id INT IDENTITY(1,1)
, mychar VARCHAR(10)

Read more

1 comments, 3,857 reads

Posted in The Voice of the DBA on 2 June 2011

Newer posts