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,531 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,513 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,477 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
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,745 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,371 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,437 reads
Writing a course
Over the last three years, since that first article I submitted to SQLServerCentral, I find myself getting involved in more...
2008-03-21
1,302 reads
Orlando Code Camp Reminder & A Special Raffle - One Laptop Per Child
Reminder that if you're registered the Orlando Code Camp is tomorrow. If you're registered and plans have changed, please cancel...
2008-03-21
1,598 reads
Denver Heros Happen {Here} Launch
I went down to the Denver stop on the Heros Happen Here launch events and as you can tell by...
2008-03-20
1,735 reads
Blogs
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers