2016-05-13
1,867 reads
2016-05-13
1,867 reads
In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.
2016-05-12
1,340 reads
A simple change might solve some of those tempdb issues various customers experience.
2016-05-12
194 reads
I was lucky enough to be accepted to speak at SQL Nexus in Copenhagen and I attended the event a...
2016-05-12
652 reads
2016-05-12
1,135 reads
One of the great things about IT is that we have so many tools to help us do our jobs. We can even build tools as needed. So why don't more IT people take advantage of this?
2016-05-11 (first published: 2012-05-23)
467 reads
2016-05-11
1,349 reads
Today Steve Jones wants you to look forward in your career. Do you enjoy working with software and technology? Do you plan on doing this for the rest of your career?
2016-05-10 (first published: 2012-04-27)
269 reads
2016-05-10
1,441 reads
2016-05-09
1,320 reads
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers