This is going to be a bit of a brain storming post that comes from an interesting question that I was asked today... "I've got a table with a ID code field, now some of the rows have a value in that field and some are NULL. How can I go about filling in those... Continue Reading →
#TSQL2sDay – #112 – Mini cookies
This months TSQL Tuesday is hosted by Shane O'Neill (Blog | Twitter) Shane explains the Topic as: Dipping into the Cookie Jar is about when the going gets tough and you don’t think you can handle anymore, then you think back about your accomplishments and take some sustenance from them. Cookie One: is remembering... Continue Reading →
TSQL Tuesday #112 – Dipping into the Cookie Jar
This month's TSQL Tuesday comes from Shane O'Neil and he's asking us to 'dip into the cookie jar' (or raid the biscuit tin, for us Brits 😉 ), essentially how we use past accomplishments to help us through difficult or challenging times. I've been trying to think about this and while like everyone I've had... Continue Reading →
Using Indexing To Solve Blocking and Deadlocking Issues
A while back, I was having a conversation about a deadlocking issue and suggested that an index could perhaps help solve it. The reaction I got was along the lines of, 'What, how can in index solve a deadlocking issue?' So, can we solve a deadlocking issue with an index? Let's create a rather simple,... Continue Reading →