Oracle and Microsoft are in the Cloud Together
What an interesting week this has been. On Monday Microsoft and Oracle announced a partnership that rocked the cloud world....
2013-06-26
1,352 reads
Blog Posts
PASS Nominating Committee for 2013 Elections Announced
I was pleased to see the email this morning announcing that community volunteers Erin Stellato, Ryan Adams, and Tamera Clark...
2013-06-26
1,245 reads
SQL Server 2014 CTP1 Now Available!
Sweet! SQL Server 2014 CTP1 is now available for download at Microsoft.com! Get it while it is hot, and start...
2013-06-26
745 reads
SQL Server: Identifying Edition Specifc features Used in a Database
I had a situation which forced me to do a feasibility study to move SQL server 2008 enterprise edition environment to standard edition. It is...
2013-06-26
1,688 reads
SSWUG Summer Camp
I'm speaking at SSWUG Summer Camp! Thankfully, I can be at home, in my pool AND be at summer camp...
2013-06-26
916 reads
This Can Be the Best Thing in SQL Server 2014
New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that...
2013-06-26
1,488 reads
Using OUTPUT to back up a change
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back...
2013-06-26
2,425 reads
Visiting Atlantis
This week I got to visit Atlantis. Not the mythical island, but rather the ship, the Space Shuttle Atlantis at...
2013-06-26
1,351 reads
Exploring Excel 2013 for BI Tip #9: Adding Calculated Members
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-06-25
1,347 reads
Installing SQL Server 2014 CTP1 – Step by Step
Great news !!! SQL Server 2014 CTP1 is out and the wait is over. Drop everything(Except the databases !) and download your...
2013-06-25
2,965 reads
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Question of the Day
An Unusual Identity
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