Recognizing Talent
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
Recognizing Talent
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
Recognizing Talent
Microsoft made a sizeable big for Yahoo and Steve Jones talks about one of the more interesting aspects of that bid that didn't receive much press.
Simplify SQL Server 2005 queries with a Dates table
Learn what a Dates table is and how to create one, and then try it out for yourself
SQL Server source code analysis and management adds database security
SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.
Database Weekly - May 5, 2008
A look back at the news of the past week dealing with SQL Injection, slow SQL Server growth and two level security.
The Dedicated Administrator Connection
New to SQL Server 2005 is the Dedicated Administrator Connection (DAC), which provides a way to ensure you can always connect to your server. No more getting locked out of a busy server as could occur in prior versions. Wayne Fillis brings us a short tutorial on this handy new feature.
Getting Organized
As DBAs we should be very detail oriented, but Steve Jones talks about some challenges with keeping up with your tasks and projects and some software that might help.
Getting Organized
As DBAs we should be very detail oriented, but Steve Jones talks about some challenges with keeping up with your tasks and projects and some software that might help.
SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back?
In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.
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