Help With SQL

Using a Staging Environment for Tracking Down Bugs

• by Andrew-Zwicker

• Help With SQL

A discussion why having a staging environment with data that mirrors production is vital to tracking down issues.
Being able to...

2011-06-08

2,120 reads

Using Nightly Populated Tables For Faster SQL Queries

• by Andrew-Zwicker

• Help With SQL

A discussion about nightly populated tables and how they have reduced SQL Server load.
What’s more important – speed or data accuracy/quality...

2011-06-05

1,269 reads

Avoiding OR Conditions with Joins

• by Andrew-Zwicker

• Help With SQL

Why OR conditions in join statements should be avoided and an example fix.
OR conditions and join statements – some things just...

2011-06-03

1,845 reads

SQL Exercise During Candidate Interview Process

• by Andrew-Zwicker

• Help With SQL

A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...

2011-06-01

2,690 reads

SQL Query Run Time Estimation

• by Andrew-Zwicker

• Help With SQL

A followup to a post about subqueries with an estimation for how long it would take for the query to...

2011-05-30

2,510 reads

Using Views for Faster SQL Query Development

• by Andrew-Zwicker

• Help With SQL

A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...

2011-05-28

829 reads

Random Ordering of Results using NEWID

• by Andrew-Zwicker

• Help With SQL

A discussion of how NEWID can be used to help randomize the results returned from a SQL query.
A scenario I...

2011-05-26

1,131 reads

Efficiency of Subqueries and OR conditions in SQL

• by Andrew-Zwicker

• Help With SQL

A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...

2011-05-25

925 reads

Double digits in posts!

• by Andrew-Zwicker

• Help With SQL

Thank you to everyone reading this site - Please enjoy your stay!
HelpWithSQL has hit double digits in posts! I hope everyone...

2011-05-24

605 reads

SQL Joins and Subqueries

• by Andrew-Zwicker

• Help With SQL

A discussion about SQL joins and subqueries with information about how to format join statements properly.
In any non-trivial task, developers...

2011-05-22

1,083 reads