On a few of the mailing lists I am on for developers (primarily ones related to web development), there is a recurring topic that always gets people into rather heated debates: to use stored procedures or prepared statements? Now, either one you choose to use, is largely dependent on two things: preference...
In the world of RDBMS' you may hear the term "table scan" thrown around, this is a term used to describe an event that occurs when you search for data in a table, and your query either doesn't take advantage of an existing index, or there is no index on the table. Generally, a table...
Ok, so this weekend I was reading up on some ways to write high performance T-SQL, as I am always on the hunt for new ideas. I came across this link where the author, Tim Chapman, has written a series of articles on SQL Server programming, administration, performance tuning and other related topics....