The sqlcmd utility in SQL Server
The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures.
Custom Pagination in SQL Server 2005
Building paging routines in SQL Server can be challenging since SQL wants to deal with full result sets. Adam Haines brings us a technique that you can use in SQL Server 2005 with the new Row_Number function.
SQL Server Options to Avoid - SQL School Video
Not every option in SQL Server is useful or appropriate. Brian Knight shows which ones you might not wish to mess with.
The Bionic Office - V2
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service
In the previous installment of our series covering the most relevant features of SQL Server 2005 Express Edition, we started an overview of Service Broker full dialog-level security. In this article, we will conclude this subject by describing the remaining prerequisites and a method to invoke a secure dialog.
Great IT Shops
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
Great IT Shops
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
Great IT Shops
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
Just a Second, Guv.
In which Phil hears about an extra 'leap' second added over the new year, and broods on the missing INTERVAL datatype in SQL Server
Get SSAS Database Properties with PowerShell and AMO
Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
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...
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