Vote for @SQLBits Sessions (pick me, pick me)
The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like...
2017-01-12
462 reads
The SQL Bits sessions are out and it’s time to vote for me. Well, vote for the sessions you’d like...
2017-01-12
462 reads
At last year’s SQL in the City, I played the part of a manual DBA making changes and deploying those...
2017-01-12 (first published: 2017-01-05)
1,561 reads
2017-01-12
924 reads
I posted this, but here it is again. A a shot from our engineer, behind the scenes of my live...
2017-01-11
547 reads
2017-01-11
172 reads
Today, Steve Jones looks at the popularity of SQL Server, which was named DBMS of 2017.
2017-01-10
141 reads
2017-01-10
1,128 reads
SQLServerCentral is getting an upgrade, and Steve Jones has a few words.
2017-01-09
142 reads
It’s a new year, and the perfect time for you to start blogging about your SQL Server work. I think...
2017-01-09
731 reads
I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time,...
2017-01-09 (first published: 2017-01-02)
3,214 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