How to Increase Query Speed With a Little Communication
How my former boss solved a performance issue by changing the business rules, instead of query optimization.
2010-07-14
27,432 reads
Stephen Hirsch
Beauty is in the Eye of the Beholder
Is dynamic SQL good or bad? We've had lots of arguments over the years in the forums and articles on both sides of the coin, though with most of the opinions being that dynamic SQL is bad. Stephen Hirsch brings us his own view that beauty is in the eye of the beholder.
2006-09-19
5,722 reads
What is XML?
The use of XML is growing all the time and if you listen to the media, XML is a technology you cannot do without. New author Stephen Hirsch brings us a look at XML from more of a skeptic's point of view.
2006-07-24
10,973 reads
Blogs
Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21
By kleegeek
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...
The Effectiveness of Solar Estimation
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and...
Forums
how to remove duplicate rows in sysobjvalues
Hi, Can you advise how to remove Duplicated rows in sysobjvalues. or remove the...
Few questions about cloud computing course
Hi I'm currently doing a networks management degree level 7. I'm in the final...
Interview question to test beginner SQL competency?
Hello, I need to help my boss come up with a simple-ish SQL quiz....
Ask SSC