Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2011

Applied SQL: Server Side Traces

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:

Read more

0 comments, 312 reads

Posted in SQL Awesomesauce on 29 August 2011

Applied SQL: sys.sql_modules

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

1 comments, 557 reads

Posted in SQL Awesomesauce on 18 August 2011

Applied SQL: sys.objects

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

1 comments, 755 reads

Posted in SQL Awesomesauce on 17 August 2011

Applied SQL: You Have Homework

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

0 comments, 236 reads

Posted in SQL Awesomesauce on 17 August 2011

We Are TOTALLY Amused: A T-SQL Error

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

2 comments, 496 reads

Posted in SQL Awesomesauce on 11 August 2011