I heard on Thursday a couple weeks ago that someone who had received a free admission to the PASS conference had cancelled and wasn't able to attend. It was last minute and that pretty much ruled out any chance to have a contest, so I called a friend in Denver who's a DBA and doesn't get much of a budget for training. I offered him the admission and he said he'd let me know Friday.
2007-09-25
1,462 reads
With the new codebase in place, RSS is pervasive throughout the site. Get a few hints here on how this works.
2007-09-25
2,254 reads
2007-09-25
1,770 reads
There was an article last week with a great title: The Mother of All Genealogy Databases, and so I had to take a look at it. It talks about some of the large databases on the Internet that are collection public records and linking them together to help people find out about their individual and family histories. The largest site so far, Ancestry.com, supposedly has 5 billion records.
2007-09-24
239 reads
Lots of changes to the site, see how to work with some of them.
2007-09-24
1,960 reads
The third evolution in the history of SQLServerCentral.com is now out and available. Read all about the changes we've gone through.
2007-09-24
1,458 reads
That's what we were estimating the rewrite of this site would take. After all, to me it's a pretty simple site, a few content sections, some date specific stuff, scheduling, a few admin tools, not that much, right?
2007-09-24
160 reads
2007-09-24
3,154 reads
It's done, it's out, and check it out!!!
I guess if you got here, you've probably noticed 🙂
This was a fairly...
2007-09-22
1,402 reads
Since I've spent most of the week at the PASS Summit, and have been busy meeting with people there instead of working on this site, I opted for a more fun, less thought-requiring poll.
2007-09-21
286 reads
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers