For this post i worked on second puzzle in the Adventofcode series. This wasn’t as challenging as the first one, but still very doable with TSQL. Part 1 of the puzzle was as below: The elves are running low on wrapping paper, and so they need to submit an order for more. They have a list… Continue reading Advent of Code – Day 2 – Using Cross apply
I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL puzzles – these puzzles are from a guy named Eric Wastl and called ‘Advent of Code‘. Your challenge basically after you sign up is to solve a series of puzzles arranged in the form of… Continue reading Advent of Code – Day 1 – Parsing a variable
Continuing with the recipes in SQL Server 2012 T-SQL recipes book – I was drawn to this puzzle that asked for how you would compare data in two identical tables using a single query. Now, if they didn’t specify the means I would readily point them to Red Gate’s SQL Data Compare – a nifty… Continue reading Comparing data in two identical tables
Today’s TSQL post is an answer to a puzzle posted by Adam Machanic. I learnt something new via this puzzle today. The puzzle is as below – what would this query return? SELECT * FROM(VALUES(1),(2)) AS x(i) WHERE EXISTS (SELECT MAX(i) FROM (VALUES(1)) AS y(i) WHERE y.i=x.i) Upon looking at it, I thought I would… Continue reading TSQL Puzzle
I have been out of touch with latest features in TSQL for a while now. That mostly happened because my dba gigs in the past few years have not involved a lot of programming. To come upto speed with TSQL, am working with a book TSQL recipes written by my good friends Wayne Sheffield(blog|twitter), Jason… Continue reading TSQL-Paging through a resultset
Sometime ago I was working with a Microsoft support technician on a ticket related to some database issues on SCOM. The technician wanted to run a stored procedure to clear out some of the backlog we were seeing with a batch job. When he ran the procedure (via Query Analyser) – we encountered an error as… Continue reading What it took to stump the optimizer
We had a requirement on a server supporting a vendor application to monitor users who are given sysadmin rights. This was because vendor personnel would need these privileges every now and then – and it was our job to monitor when they are active and see that they are disabled on time. To achieve this… Continue reading Finding users who are Sysadmins
This is my first response to a TSQL Tuesday. There are lot of things in TSQL that can be done to make DBA’s life easier. We have a large collection of scripts. These are some I have used over the years at multiple jobs – there are several more but I don’t particularly want to… Continue reading T-SQL Tuesday #025 – Invitation to Share Your Tricks
Curious..about data 