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
Blog Posts
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,473 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,743 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,367 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
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,595 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,291 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,733 reads
A Minor Rant About Statistics
If you've ever taken a look at the auto generated statistics that SQL builds (typically on non indexed columns when...
2008-03-19
1,336 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers