Turn on Instant File Initialization for SQL Server Performance – With Video Demo
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-31
1,811 reads
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-31
1,811 reads
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-30
4,369 reads
Have you ever tried to restore a backup over an existing database and receive an error stating the tail of...
2012-05-25 (first published: 2012-05-21)
2,536 reads
A friend of mine contacted me through email today having a very common problem with a query he had written....
2012-05-25
806 reads
I had the pleasure of attending SQL Saturday 112 this past weekend. This was my second time speaking at a...
2012-05-17
599 reads
I am not one of these anti PC sorta guys, but I do love my MacBook Pro. I have owned...
2012-05-05
645 reads
“Why I joined Linchpin People as a Teammate”
It was announced publicly this past weekend at SQL Saturday #111 that I...
2012-04-19
770 reads
In just two days SQL Saturday 107 will be in full swing. Tomorrow begins their precon with the infamous Kalen...
2012-04-19
640 reads
Linchpin People, LLC is an organization led by Brian Moran and Andy Leonard with Mike Walsh and Robert Pearl as...
2012-04-13
1,008 reads
I was chosen to speak at SQL Saturday 111 in Atlanta GA this weekend. I will be doing my session...
2012-04-13
568 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