Category Archives: T-SQL

Quick Script: Finding Specific Columns

A quick script that can help you to find columns of a certain pattern. Continue reading

Posted in T-SQL | Tagged | Leave a comment

Quick Script: Finding Database Owners & Security Admins

A quick script to identify where you might have permission issues at the database level. Continue reading

Posted in T-SQL | Tagged | Leave a comment

Procedure Creation – Correct Syntax, Wrong Database

A brief look at why a procedure is created even with a reference to an object that isn’t valid. Continue reading

Posted in Administration, Internals, T-SQL | Tagged , | Leave a comment

Quick Script: Finding Columns

A T-SQL script that I wrote to hunt for certain columns based off their names. Continue reading

Posted in T-SQL | Tagged , | Leave a comment

Query Optimizer Wins Again

A quick look at why the Query Optimizer was correct in stopping me in my tracks. Continue reading

Posted in Internals, T-SQL | Tagged , , | Leave a comment

Configuration Validation – Max Memory

A look at a script that validates the max memory setting for our installed SQL Servers. Continue reading

Posted in Administration, T-SQL | Tagged , , | 6 Comments

Add A Procedure to Master Database? Yes Please!

In this post I talk about adding a procedure to the master database so that you can access it regardless of which database you are located in. Continue reading

Posted in T-SQL | Tagged , , | 6 Comments

LIKE, No Way!

Have you ever used a tool for ever and a day, and then suddenly one day, you discover that there is so much more that single tool can do? Well, that happened to me. In this post I talk about the popular ‘LIKE’ function and it’s other uses. Continue reading

Posted in General Conversations, T-SQL | Tagged , | Leave a comment

T-SQL To The Rescue for Puzzle Friday!

Answers to the puzzle friday question and how I solved it with a little bit of T-SQL code. Continue reading

Posted in T-SQL | Tagged , , | 3 Comments

Puzzle Friday!

It’s puzzle Friday at work and this week’s puzzle can be solved by some T-SQL. Take the puzzle and see if you can come up with another solution! Continue reading

Posted in General Conversations, T-SQL | Tagged , | 3 Comments