Book Review: The Data Warehousing Toolkit 2nd Edition
Longtime author and SQL Server guru David Poole takes a look at a classic book about Data Warehousing.
2009-04-24
2,353 reads
Articles
SCOME - Part 3: The Failed Jobs Report
Monitoring your servers centrally requires a good reporting system. Drew Salem continues with his SCOME journey to tame servers with the building of a job report in this article.
2009-04-24
7,534 reads
Do You Take Notes?
I happen to notice this in a class recently that I had the rare student - one that could take notes that seemed to have value to them the next day. If you watch people take notes, I think they fall into one of these categories: The Highlighter. They have...
2009-04-24
1,989 reads
Ethics and Leaders - Database Weekly (Apr 27, 2009)
This week Steve Jones discusses ethics and leadership in IT.
2009-04-24
766 reads
Ethics and Leaders - Database Weekly (Apr 27, 2009)
This week Steve Jones discusses ethics and leadership in IT.
2009-04-24
1,005 reads
SQL Server Data Mining Programmability
Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios.
2009-04-24
2,532 reads
Creating a Publication - SQL School Video
This SQL School video looks at how you add a publication to a replication scenario.
2009-04-23
3,588 reads
Displaying a Pop-up message in SSRS 2005
Validates user parameter and displays a pop-up message to the user and handles users response.
2009-04-23
16,202 reads
SQL Lunch with the Baton Rouge Area SQL Users Group
Every other Monday is a lunch for the SQL Server group in Baton Rouge. If you live nearby, or are in the area, plan on attending.
2009-04-23
308 reads
Auditing in SQL Server 2008
This paper provides a comprehensive description of the new feature along with usage guidance and then provides some practical examples.
2009-04-23
2,372 reads
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