Have You Designed a Database from Scratch?
An interesting question from Steve Jones today, asking what is your experience with designing databases.
2016-06-24
185 reads
An interesting question from Steve Jones today, asking what is your experience with designing databases.
2016-06-24
185 reads
I’ve had an aging desktop for some time. I originally bought it from Glenn Berry (b | t), who I think...
2016-06-24
538 reads
I first heard this little acronym from Grant Fritchey (b | t). He used it when talking about backups and restores,...
2016-06-24 (first published: 2016-06-17)
1,807 reads
2016-06-24
1,406 reads
This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for...
2016-06-23
492 reads
R Services were added to SQL Server 2016, and there are customers using this feature to improve their business processes.
2016-06-23
186 reads
2016-06-23
1,311 reads
Tldr: A bit of a rant. I’m not spending a bunch of time crafting this.
I have mixed feelings about searching...
2016-06-22
497 reads
2016-06-22
1,217 reads
Larry Page is a very interesting person, one that is looking to change the world.
2016-06-21
128 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