Posted inSQL Server
Coalesce vs ISNULL
The difference between ISNULL and COALESCE? It is quicker to type ISNULL. Plus COALESCE always takes me a few goes to spell correctly, luckily there is intellisense and I can…
Posted inBlog SQL Server
SQL Events 2013 Part 2
Just to make everyone aware that SQL Relay is back in November this year. These are all day events, and well worth attending. The link you will need is: http://www.sqlrelay.co.uk/register.html The…
Posted inSQL Server
Suppress messages in SQL log
Previously we had looked at how to configure alerts to log the messages that we are interested in picking up. In this previous post I very briefly showed how to…
Posted inSQL Server
Configure Alerts SQL Server
As a base set of alerts for monitoring SQL Server I tend to use the following out of the box categories, with the obvious exception of syntax errors. This will…
Posted inSQL Server
SQL Server Page Types
There are lots of different page types and Paul Randall list them in his article. However as I tend to have a rather poor memory for remembering them first off…
Posted inSQL Server
SQL Server Row Internals
Row Storage A Row is stored on a Page which is 8192 Bytes, and this is broken down in two key areas when considering physical storage. Firstly on all pages…
Posted inBlog SQL Server
MCM 2008 Success
I got an email from Microsoft! The lab I took on the 11th April. (Yesterday). I passed!!! So.... a long time ago in a place....no wait... I passed the prerequisite and…
Posted inSQL Server
SQL Server Partitioning Data Movement
Introduction This is a continuation to the partitioning overview post to help explain how data movement is performed using Alter Partition with Merge and Split Commands. Getting Started In order to…
Posted inSQL Server
SQL Server Partitioning Overview
Introduction This is a guide to help explain partitioning setup; which although introduced way back in SQL 2005 is still an area which throws up a lot of questions. Requirements…
Posted inBlog SQL Server
SQL Events 2013
2013 is shaping up to be a good year for me getting to events, so far penciled in are SQLSaturday in Exeter and SQLBits XI in Nottingham. Hope to see lots of…