Paperwork Day
Doing payments for articles, expenses, and a few articles. This is definitely a paperwork day. As much as I like...
2007-10-01
645 reads
Blog Posts
Clustered Indexes
I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports...
2007-09-30
1,292 reads
The Quickest Podcast in the Business
I almost forgot to record the podcast for tomorrow's editorial. In case you're a glutton for punishment, it's here. I'd...
2007-09-30
1,603 reads
I Don't Have a Black Eye
Though it kind of looks like that. Here's the first video podcast.
Halo 3
Actually it's probably the 20th, but it's close...
2007-09-29
1,442 reads
Monitoring and Alerting
I responded in an interesting thread this morning where someone was looking for advice on what to monitor on their...
2007-09-28
1,562 reads
Points or Posts
It's an interesting question that we had come up, and honestly I'm not completely sure what I want. I'll describe...
2007-09-27
1,414 reads
I Am Not In Charge
That is for sure.
We had a development meeting today with my publishing team (meaning I'm on the team, not leading...
2007-09-26
1,459 reads
Development at High Speed
As with any project, despite being fairly pleased with the final product, there were bugs. In fact, quite a few...
2007-09-25
1,379 reads
DTS vs Linked Server
We are trying to move to version 2 of our accounting data warehouse (more likely called a datamart), but it...
2007-09-25
1,599 reads
Flawed URL Validation and Not Eating Your Own Dog Food
MS includes a bunch of reasonably nice validation controls in VS 2005 and one of them includes the ability to...
2007-09-25
1,380 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