Category: sql server

New Hotness: sys.sql_modules

I’m still old school in many ways. And they’re not the ways that let you get away with wearing wayfarers, or shouting “get off my lawn, you kids!” In this case, I’m still havin a hard time weaning myself off the old system table “syscomments”. I LOVE syscomments…I can find a piece of code anywhere in […]

Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!

Content rating: Beginner     This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for T-SQL Tuesday #10, with apologies for being too gosh-darn busy to write something new.  This is a companion blog to “Get Index Included Column Info“.  What are indexes for? We need to talk indexes […]

Rats in the Corn again, Paw!

Last Edit: Oh, look! YOU wrote SSMS Tools Pack, too? Mladen Prajdic has posted an excellent recap of yesterday’s events: Plagiarism and second chances  Happily, all seems to have ended well. -J I think we’ve already found our nominee for Cornhole of the Week, and it’s only Monday!  Troops, meet our latest blatant plagarizer, “SQLDigs”, […]