I will write and troubleshoot sql server queries with explanations
About this Gig
I write and troubleshoot Microsoft SQL Server (T-SQL) queries and explain how they work.
Useful for:
Reports, filtered lists and joined data
GROUP BY, totals and aggregate functions
Subqueries and basic INSERT, UPDATE or DELETE operations
Fixing SQL errors and making existing queries easier to read
You receive:
Commented .sql query scripts
A plain-English explanation of the logic
Notes on assumptions and how to run the queries
A check against your supplied schema, sample data and expected results
Basic: 1 query using up to 2 tables.
Standard: up to 3 queries using up to 4 tables.
Premium: up to 5 queries using up to 6 tables.
Table limits apply to the agreed set of tables used in the order.
Please send your SQL Server version, table/column structure, existing query and exact error if relevant, anonymised sample data, and the output you need. Message me before ordering if the scope is unclear.
This service covers small, clearly defined query tasks. Database administration, enterprise architecture, migrations and advanced performance tuning are outside these packages.
Database type:
Relational database
Platform:
MS SQL
•
SQL Server
Expertise:
SQL
•
DML
•
DQL
FAQ
What do you need to start?
Please send your SQL Server version, table and column structure, relevant sample data, any existing query or error message, and an example of the output you want.
Which databases do you support?
This gig covers Microsoft SQL Server and T-SQL. MySQL, PostgreSQL, Oracle and NoSQL services are outside the advertised scope.
What is included in a revision?
A revision adjusts the delivered queries to meet the original agreed requirements. New queries, additional tables or changed objectives may require an extra service or a custom offer. Delivery includes query scripts and explanations.
What will I receive?
You receive commented .sql query scripts, a plain-English explanation, run notes and any assumptions. I check the queries against the schema, sample data and expected results you provide. Please supply runnable test data when execution testing is needed.
How do the query and table limits work?
Basic covers 1 query and up to 2 tables; Standard up to 3 queries and 4 tables; Premium up to 5 queries and 6 tables. The table limit applies to the agreed set of tables in the order. Please discuss stored procedures, complex logic or wider scope before ordering.
