A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do window functions run quicker than their conventional equivalent code? Fabiano Amorim gives a definitive answer.
Today's editorial was originally reprinted on Jun 17, 2007. It is being re-run as it is a holiday in the US. Today Steve Jones looks at Jonthan Schwartz, the former CEO of SUN who took over from the founder, Scott McNealy.
DBAs always tend to face many difficulties in maintaining a healthy work-life balance. Brad McGehee encourages some debate on the best strategies to make this work, in the face of long working hours, and the desire to contribute fully to the SQL Server community.
How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.
This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.
The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.
This Friday's poll asks you to tell us what you'd do if you won the lottery. Is there something that you'd rather be doing than your current job? Dream a little and let us know.
Sometimes the requirement arises to provide a copy of your database to an off-site location, such as a disaster recovery datacenter. Log Shipping is one of the most popular, proven technologies used to create a copy of your databases on a remote server.
If you had less resources or compilation too longer, would you code more carefully? Steve Jones talks about the benefits that might come from not having the latest and greatest hardware.
Part II of a discussion and demonstration of ETL of a CSV data file using SSIS.
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