Category: Intermediate

24 Hours of PASS Spring 2011 Code Sins

Post author By Jen McCown
Post date March 15, 2011
Categories In 24HOP, 24HOP, Beginner, Intermediate, sql server, SQLPASS, sqlserverpedia-syndication, SSC, Tips, TSQL
5 Comments on 24 Hours of PASS Spring 2011 Code Sins

Here is all the things related to the most awesome Code Sins session I gave at 24 Hours of PASS Spring 2011. Thanks to the 750+ of you that attended, and the many who commented!! I will be updating this blog post with links and answers to questions for a few days yet. The 24HOP recorded sessions […]

T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!

Post author By Jen McCown
Post date March 8, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on T-SQL Tuesday #016: Aggregates and Windowing Functions and Ranking! Yum!

Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday on aggregates to talk about OVER() and PARTITION BY. Aggregates and OVER go together like french fries and catsup…sure, you can have them apart, but together they’re just magical. Note: If you’re not at all familiar […]

RTFM365, Week 1

Post author By Jen McCown
Post date December 10, 2010
Categories In Advanced, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips
2 Comments on RTFM365, Week 1

Big lessons learned this week: 1, its’ always worthwhile to go back and reread the basics. 2, sys.sp_trace_create option 4 doesn’t stop the server side trace, it stops SQL Server itself. Be warned. Boilerplate: For the next year (-10 days now), I will read from SQL Server Books Online a little every day, and blog about […]