Category Archives: Intermediate

SQL Server is Smarter Than You

Posted on December 8, 2011 by Jen McCown

I had a brief email discussion recently, which could be effectively be boiled down to: Them: “Are foreign key constraints more performant than referential integrity triggers?” Me: “Yes.” *stomp*stomp*stomp*stomp* “Yes, they are.” Let’s start with a generic statement, and get … Continue reading →

Posted in Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC | 2 Comments

RSS Tuning Whitepaper notes and clarifications

Posted on October 19, 2011 by Jen McCown

This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning (it came with a catchy SQLCAT logo!) So I clicked, I read, I downloaded and read some more. To summarize (BIG summary!), this paper says that … Continue reading →

Posted in Advanced, Intermediate, Random helpfulness, sqlserverpedia-syndication, SSC | Tagged | Leave a comment

Applied SQL: Server Side Traces

Posted on August 29, 2011 by Jen McCown

It’s time to get your server side trace on, with a little practical application! I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL, basic experience with SQL … Continue reading →

Posted in Applied SQL, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL | Tagged | 3 Comments