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,456 reads
How my former boss solved a performance issue by changing the business rules, instead of query optimization.
2010-07-14
27,456 reads
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,778 reads
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
11,011 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
How many table hints can I include in a query?
See possible answers