Partitioning Part 4 Posted on SSC
Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series...
2008-01-17
559 reads
Blog Posts
The Interviewer is Wrong
Michael Coles had an interesting post about a job interview a friend went on. The person answered questions correctly, but...
2008-01-17
882 reads
Sun Acquires MySQL
Just posted on Jonathan Schartz's blog. They've definitely been playing more in the open source arena, now they've got a...
2008-01-16
641 reads
Two Acquisitions of Note
Saw both of these on ComputerWorld:
Oracle buying BEA
Sun buying MySQL
It'll be interesting to see how this changes the...
2008-01-16
735 reads
Upcoming Presentations
I'll be attending the South Florida Code Camp on Feb 2 and also SQLSaturday Tampa on Feb 16th. For both...
2008-01-16
522 reads
Covert It Live
I watch the Geekbrief update a few times a week, partially to see new gadgets and partially to see how...
2008-01-15
735 reads
SQL Server 2005 Replication bug?
Last week, in our production, we noticed some records are missing in the subscriber side while existing on the publisher...
2008-01-15
920 reads
E-Readers, Will They Ever Take Off?
I was discussing the Kindle recently with business partner Steve Jones and while we both like the idea of having...
2008-01-14
484 reads
Hot Subtract
Over the last few weeks I've seen a few posts about the new Hot-Add CPU feature in SQL Server 2008....
2008-01-14
793 reads
Evaluating Speakers at Events
Speakers tend to live for the evals. Hopefully it's a validation of work done well after a lot of time...
2008-01-09
912 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
DB Design Methods
I've read a few posts regarding what we use to design DB models and...
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...
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