MAXDOP and Azure SQL DB
The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when...
2018-09-12
557 reads
All About SQL
Hello Cloud Goodbye DBA
No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs...
2018-09-10
643 reads
Moving an Azure SQL Database across Resource Groups
In my mind there are a couple of ways to move a database across resource groups. They vary from scripting...
2018-09-05
932 reads
Azure SQL Database – Detecting Threats
At first I was nervous but then I realized it was me triggering “Someone has logged on to your server ...
2018-09-03
839 reads
Deleting Azure SQL DB
So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database...
2018-08-28
229 reads
My Azure SQL Database Elastic Job is Broken!
I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is...
2018-08-23
329 reads
The Good The Bad and The SLA
Lets just get straight to the point, Azure SQL Database across all service tiers gives you the customer a SLA...
2018-08-20
257 reads
SQL Reserved vCores
Have you ever heard of SQL Reserved vCores? Well I never until recently. With this concept you have the ability...
2018-08-16
343 reads
Azure SQL DW – Query Labels
Using a query label in Azure SQL DW (Data Warehouse) can be a really handy technique to track queries via...
2018-08-14
363 reads
Azure SQL Data Warehouse and Backups
Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills...
2018-08-07
414 reads
Blogs
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
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...
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