Showing posts with label T-SQL. Show all posts
Showing posts with label T-SQL. Show all posts
Wednesday, November 29, 2017

Use T-SQL to create caveman graphs

›
I found this technique on Rich Benner's SQL Server Blog:  Visualising the Marvel Cinematic Universe in T-SQL  and decided to play arou...
5 comments:
Monday, July 10, 2017

T-SQL Tuesday #92, Lessons learned the hard way

›
This month's T-SQL Tuesday is hosted by Raul Gonzalez , he proposed the following:   For this month, I want you peers to write about t...
1 comment:
Sunday, January 01, 2017

Running queries against the songs you played with Alexa

›
My son got an Amazon Echo for Christmas. We use the Echo mostly to play music. I have setup IFTTT (If This Then That) to save the name o...
Sunday, August 17, 2008

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code

›
Take a look at this query. SELECT * FROM ( SELECT customer_id, ‘MTD’ AS record_type, COUNT ( * ) , SUM ( … ) , AVG ( … ) FROM payment_t...
Tuesday, May 27, 2008

Interview With Erland Sommarskog About SQL Server and Transact SQL

›
I have interviewed Erland Sommarskog, you can find that interview here: Interview With Erland Sommarskog About SQL Server and Transact SQL E...
Monday, May 07, 2007

Three Ways To Return All Rows That Contain Uppercase Characters Only

›
How do you select all the rows that contain uppercase characters only? There sre three ways to do this 1 Compare with BINARY_CHECKSUM 2 Use ...
2 comments:
Sunday, February 11, 2007

Ten SQL Server Functions That You Hardly Use But Should

›
Below are 10 SQL Server functions that are hardly used but should be used a lot more I will go in more detail later on but here is a list of...
6 comments: