Tag Archives: T-SQL

Republish: I Feel Like a Magician

I’m off in the UK and buried with other work, so a republish today. I Feel Like a Magician

Posted in Editorial | Tagged | Leave a comment

T-SQL Tuesday #106 – Trigger Headaches or Happiness

Since I took over the T-SQL Tuesday a few months ago, I decided I ought to host again. Especially since I’ve done it twice, but Wayne Sheffield got his third spot last month. Gotta keep up with Mr. Sheffield. Triggers, … Continue reading

Posted in Blog | Tagged , , | 37 Comments

Generating a Constrained Random Date–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There have been lots of posts on the topic of generating random values, and some great articles. One of … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Remember the Default Window

I ran across a question recently from a user about why they had strange results from a windowing query. This is better explained with an example, so let’s look at one. I have some data in a table. This is … Continue reading

Posted in Blog | Tagged , | 5 Comments

Will Terminators Be Required?

I was looking at an article the other day and noticed that there was a CTE sample with the semicolon on the line before the code. I’ve been seeing this convention for years, starting your CTE with a semicolon because … Continue reading

Posted in Editorial | Tagged | Leave a comment

Solving Ken’s FizzBuzz 3D–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I like the FizzBuzz test. It’s cute and fun, and I’ve had my kids solve it, just to think … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Finding Inconsistent Key Values–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was reading Iris Classon’s blog recently and ran across a post on her day at work. I think … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Getting All Users

I saw someone that wanted to get all users from all databases on their instance. Seems like that ought to be simple, right? The user wanted to use sp_MSforeachdb to query users, but wanted a single result set for all … Continue reading

Posted in Blog | Tagged ,

Defining FKs in CREATE TABLE–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the important things that a database developer can do is to define Foreign Keys (FK) at table … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Exploring the Caves of Code Analysis in #SQLPrompt

I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes and go through it. I wrote about a few of the items, and this post continues on with a feature … Continue reading

Posted in Blog | Tagged , , , | 2 Comments