In a previous tip we looked at the steps to Create a Trace Template in Profiler. In this tip we will look at a few more tips such as creating a trace template from an existing trace file and saving a trace file to a SQL Server table.
Today we have an editorial reprinted from Dec 12, 2005 as Steve is on vacation. Steve talks about the hassles of poor data quality and why it can hurt a business.
This article contains an introduction to SQL Server indexes and how they are used in your queries.
When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when you are designing your databases.
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
This week was T-SQL Tuesday week, the brainchild of Adam Machanic, and hosted by Pat Wright. The theme of Automation produced some very interesting posts. Some of them might inspire you to change the way you tackle the solutions for a variety of problems.
A review of SQL Monitor, the new DBA utility from Red Gate Software that can help you keep an eye on what your SQL Server instances are doing.
Today we have a reprint of an editorial from Sept 22, 2005. In this one, Steve Jones reminds you that blogging is a public event and you want to be careful about what you write.
I sometimes want to perform auditing or other actions in a trigger based on some criteria. More specifically, there are a few cases that may warrant an e-mail; for example, if a web sale takes place that requires custom or overnight shipping and handling. It is tempting to just add code to the trigger that sends an e-mail when these criteria are met. But this can be problematic for two reasons: (1) your users are waiting for that processing to occur, and (2) if you can't send the e-mail, how do you decide whether or not to roll back the transaction, and how do you bring the problem to the attention of the administrator?
Come learn about SQL Server in Phoenix on Feb 19, 2011. For free! Spread the word to anyone you know in the area.
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