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,360 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,672 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,950 reads
Blogs
Event Notifications Example
By SQLPals
Event notifications are kinda like a trigger in the sense that they respond to...
Did you know we have another SQL Server book coming out?
SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...
Batch Scripting SQLCMD–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
Using sftp in Visual Studio for SSIS packages
Hi, I've inherited the maintenance of SSIS packages that were created by our former...
Merge vs other options
Hi, I need to load a table that has 5,000,000 records, I usually use...
Password changes
I would like my SQL users to be able to change their SQL password.Using...
Ask SSC