T-SQL Tuesday

T-SQL Tuesday 66 Monitoring – Agent Alerts

T-SQL Tuesday 66 Monitoring – Agent Alerts

Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you need to get a wriggle on and upgrade to SQL Server 2014. If you are still wondering whether to upgrade I did write a post on it some time back which may help: 5 Top […]

T-SQL Tuesday 41 – Presenting and Loving it!

T-SQL Tuesday 41 – Presenting and Loving it!

Before we dive in to the post, I’d like to give a big thank you to Bob Pusateri (Blog|Twitter) for hosting this months T-SQL Tuesday “Presenting and Loving it!”. T-SQL Tuesday was the brainchild of Adam Machanic (Blog|Twitter) you can find out more about the concept here. Coincidentally I am actually giving a presentation on […]

T-SQL Tuesday #025 – How to view the size of all your databases – #TSQL2sDay

T-SQL Tuesday #025 – How to view the size of all your databases – #TSQL2sDay

It’s that time of the month again, no not time, T-SQL time! If you have not heard of T-SQL Tuesday before it was set up by Adam Machanic (Blog|Twitter) and you can read all about it here: T-SQL Tuesday. This months host is Allen White who asked the question “What T-SQL tricks do you use […]

T-SQL Tuesday 23 – Key Lookups

T-SQL Tuesday 23 – Key Lookups

This post is brought to you by the letter “K”. Those of you that have been following my blog and tweets recently will know all about the SQLRelay event that is happening in the UK this week. Tonight is the second of a four night series of events culminating on the 6th October in London […]

Building Queries, work smarter not harder

Recently I asked a colleague to split up an update statement into smaller batches to reduce locking on the system and the impact on replication, the table in question did not have an identity attribute on it so it had to be segmented a little more manually and he was worried that it would result in a lot of code to write. Now it’s true we could have used NTILE or TOP statements in a loop and split the update statement down that way, but then I wouldn’t have been able to talk about how you can work smarter not harder when it comes to building repeated queries.

T-SQL Tuesday #10: Unused Indexes (Indices)

T-SQL Tuesday #10: Unused Indexes (Indices)

This is my first foray into the now well established T-SQL Tuesday event. If you have not heard of T-SQL Tuesday before it was set up by Adam Machanic (Blog|Twitter) and you can read all about it here: T-SQL Tuesday This months subject is “Indexes” (however I’m one of those annoying people who prefer to […]