Arshad Ali discusses the details of creating reports with indicators and gauges in SQL Server 2008 and walks you through designing a one tablix report with two levels of grouping.
Self service in IT is something Steve Jones likes, but it doesn't solve all problems, and might end up creating more issues.
Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.
On Thursday May 17th 12PM noon Central, Mike Fal will discuss "SQL Server's table partitioning gives the DBA tools to manage this beast and support very large tables in a way where index management and data retrieval..."
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
Phil Factor welcomes SQL Server support by Amazon RDS, as an alternative to having Microsoft as service provider as well as software provider, via the PaaS formerly known as Azure.
Software engineering is seen as a dead end career choice, at least by some people. Steve Jones disagrees.
Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.
A guide to the SQL Server 2008 Business Intelligence exams.
This week Steve Jones wants to know if you can find time for your professional development. Regularly improving your skills is an important part of your career in technology, and the poll this weeks asks what time you can make for improvement.
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...
??/WA:0817866887 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
WA:0817866887 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
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