Tagged Questions
0
votes
1answer
149 views
Tips for using DML Statements [closed]
I've recently began learning T-SQL and have found that there are some rules to using single table queries. For instance:
GROUP BY
If aggregate and non-aggregate expressions are used together in a ...
23
votes
2answers
769 views
Where can I find database tuning exercises for learning?
As a developer, often DBAs take responsibility for resolving performance issues at the database level so we don't get that much experience diagnosing, tuning, refactoring queries etc.
I'm looking ...
