Category: Beginner

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 for each of the following: Find all object definitions […]

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 each of the following: Get a list of all […]

Search Argument Case Study: WHERE the year was 2002…

Content Rating: Beginner, Tips It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the boost a good index gives your query.  Here’s a quick demonstration of the power of a well-thought-out search clause on a date column.  For this example we’ll use AdventureWorks (freely available at Codeplex). Let’s […]