Using a Staging Environment for Tracking Down Bugs
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,126 reads
Help With SQL
Using Nightly Populated Tables For Faster SQL Queries
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,282 reads
Avoiding OR Conditions with Joins
Why OR conditions in join statements should be avoided and an example fix.
OR conditions and join statements – some things just...
2011-06-03
2,753 reads
SQL Exercise During Candidate Interview Process
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,705 reads
SQL Query Run Time Estimation
A followup to a post about subqueries with an estimation for how long it would take for the query to...
2011-05-30
3,284 reads
Using Views for Faster SQL Query Development
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
840 reads
Random Ordering of Results using NEWID
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,138 reads
Efficiency of Subqueries and OR conditions in 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
939 reads
Double digits in posts!
Thank you to everyone reading this site - Please enjoy your stay!
HelpWithSQL has hit double digits in posts! I hope everyone...
2011-05-24
610 reads
SQL Joins and Subqueries
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,096 reads
Blogs
Stepping into Event Streaming with Microsoft Fabric
By Rayis Imayev
(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...
Sabbatical le Troisième: A Recharge Week
By Steve Jones
It’s been a week since I flew home from London and Redgate to begin...
SQL Server Careers: Still a Goldmine, or a Dead End?
When you're searching about the future of a career in MS SQL Server, you're...
Forums
Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
how to move all SP from one db to another db?
Hi everyone I have two db - one is test and other is archive. ...
The Long Weekend
Comments posted to this topic are about the item The Long Weekend
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers