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 Profiler

Reading:

• SQLServerPedia article: The Server-side…

Read more

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.

Prerequisites: basic T-SQL (including JOINs and LIKE), basic knowledge of catalog views

Reading: SQL Server Books Online sys.sql_modules article.

Level 1 Assignments: Using sys.sql_modules, write a query… Read more

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.

Prerequisites: basic T-SQL (including JOINs and LIKE), ability to search BOL

Reading: SQL Server Books Online sys.objects article.

Level 1 Assignments: Using sys.objects, write a query for… Read more

I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything.  What do we really need to understand SQL Server and internalize it?  Practice.

Bearing this in mind, I’m starting up an Applied SQL series of blogs, with the sole… Read more

This has to be the best error I’ve ever seen:

Msg 195, Level 15, State 10, Line 2
‘SUM’ is not a recognized built-in function name.

Uhm, I’m sorry to contradict you SQL Server, but yes it is. Here’s the code that produced that error:

SELECT keyID
, SUM(CASE… Read more