sqlSentry, a leading developer of management solutions for Microsoft SQL Server, today announced that it has released the 64-bit version of its industry-leading scheduling and notification management system for SQL Server 2005, supporting both x64 and Itanium-based systems.
2006-01-11
2,714 reads
A new product has just been released in Beta to help you with source control for your SQL Server development. Beta testers are wanted, so if you're interested, read on.
2005-12-01
3,727 reads
With a new version supporting SQL Server 2005, Periscopde for SQL Server is offering a 25% discount for SQLServerCentral.com members. This product helps with performance monitoring.
2007-09-22 (first published: 2005-10-05)
3,868 reads
Newly surfaced Tableau Software aims to revolutionize the acquisition and deployment process with its product suite, Tableau Professional and Standard Editions. To a significant degree, it has succeeded...
2005-08-26
2,499 reads
If you live in the US, take a few minutes for this performance survey and you could win an Amazon gift certificate.
2005-08-02
3,280 reads
We periodically negotiate a discount withe vendors for the SQLServerCentral.com readers. We've gotten another one from DBxtra for a Professional license if you're interested in this reporting tool.
2005-04-28
2,807 reads
Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.
2005-04-18
4,145 reads
As the online news service called NewsScape moves into its sixth year, it exhibits a lot of the characteristics of a child at the same age: It has a huge appetite for information, grows by leaps and bounds each year, and makes those who oversee it wonder if they can maintain control as it gets bigger. It is maintained by "a man and a dog – an aging golden retriever named Sambucus," according to the man, Andrew Clarke.
2005-04-15
1,744 reads
Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.
2005-04-05
3,822 reads
With it's VizQL, Tableau Software is revolutionizing the way that you will analyze data. Built to work with multiple data sources, including SQL Server databases and Analysis Services cubes, this software will amaze you.
2005-04-04
3,536 reads
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...
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
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