A Better (Free) Search in SSMS
A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we...
2016-06-21 (first published: 2016-06-15)
4,068 reads
A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we...
2016-06-21 (first published: 2016-06-15)
4,068 reads
2016-06-21
1,309 reads
I did some work a 3-4 years ago, learning about the Windowing functions and enjoying them so much I built...
2016-06-20
775 reads
After the crash of an US Air Force database was reported, Steve Jones has some advice.
2016-06-20
120 reads
2016-06-20
82 reads
2016-06-20
1,306 reads
I upgraded my SQL Prompt recently, mostly as a habit. The team led by David and Aaron are always adding...
2016-06-17 (first published: 2016-06-09)
2,502 reads
SQL Server 2016 runs faster, sometimes without you changing anything.
2016-06-17
271 reads
2016-06-17
1,272 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-16
653 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