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,379 reads
How my former boss solved a performance issue by changing the business rules, instead of query optimization.
2010-07-14
27,379 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,684 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
10,951 reads
By Rayis Imayev
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach...
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
Hi I am looking to select the output of the data that I plan...
Currently, while installing SQL server we use a local linux account to run the...