Image If Everything
How much does the image you project at work matter? Is it more important than the work you do? Steve Jones asks for your opinions for this Friday poll.
Image is Everything
How much does the image you project at work matter? Is it more important than the work you do? Steve Jones asks for your opinions for this Friday poll.
Image is Everything
How much does the image you project at work matter? Is it more important than the work you do? Steve Jones asks for your opinions for this Friday poll.
The sqlcmd utility in SQL Server
The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures.
Custom Pagination in SQL Server 2005
Building paging routines in SQL Server can be challenging since SQL wants to deal with full result sets. Adam Haines brings us a technique that you can use in SQL Server 2005 with the new Row_Number function.
SQL Server Options to Avoid - SQL School Video
Not every option in SQL Server is useful or appropriate. Brian Knight shows which ones you might not wish to mess with.
The Bionic Office - V2
Fog Creek Software has a new headquarters and the offices look amazing. Steve Jones talks about the value of a beautiful space.
Conducting Service Broker Conversation Using Full Dialog Security in SQL Server 2005 Express Service
In the previous installment of our series covering the most relevant features of SQL Server 2005 Express Edition, we started an overview of Service Broker full dialog-level security. In this article, we will conclude this subject by describing the remaining prerequisites and a method to invoke a secure dialog.
Great IT Shops
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
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