As you probably are already aware, a view in SQL Server is generated off of a pre-defined select statement, and is a flexible solution to use when ever you are doing database driven application development; particularly when you are using an ORM tool (like SubSonic or EntitySpaces as examples). However...
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...
Found this great article on interpreting PERFMON statistics. Being able to make sense of this is critical to doing advanced performance tuning on your SQL Server. This type of stuff goes more towards system administration more than programming. I myself tend more towards fixing things from a programmatic...
ClearTrace is a free tool available for download that will analyze SQL Server trace files and trace tables to give you a normalized view of query performance. It offers various sorting capabilities From the site: ClearTrace imports SQL Server 2000 and 2005 trace (and profiler) files into SQL Server and...
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....