SQL Saturday
I've just received notice that I will be a presenter at the upcoming SQL Saturday event in Jacksonville, Florida. I'll...
2008-03-30
1,530 reads
Blog Posts
How Should It Work?
I was following a debate on the new Merge syntax in SQL Server 2008 with interest. It was somewhat of...
2008-03-28
1,506 reads
More Code Per Module = More Bugs, But More Complex Code <> More Bugs?
SDTimes has an article up about Debunking Cyclomatic Complexity that talks about the results of some research that supports what I...
2008-03-28
1,512 reads
Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...
2008-03-28
1,530 reads
Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is...
2008-03-28
1,446 reads
The Shadow Knows What Procedures Lurk in the SQL Plan Cache
How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You...
2008-03-28
1,474 reads
Getting Reporting Services to work on Vista
I recently ordered a new laptop and this one came with Windows Vista Ultimate. I knew about having to install...
2008-03-26
2,744 reads
More Thoughts on LINQ to SQL
At the recent Orlando Code Camp I had the opportunity to spend a good bit of time discussing LINQ to...
2008-03-26
1,671 reads
Notes About our Raffle of the One Laptop Per Child Laptop at Orlando Code Camp
I've blogged about the OLPC project a couple times already, not as a political statement but just as a fascinating...
2008-03-24
1,368 reads
Orlando Code Code Follow Up
Although attendance was down this year (around 280 attendees) due to it being held Easter weekend, I thought this was...
2008-03-23
1,431 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