In my current role, we have a mixture of SQL Server and MySQL installations and over the courses of time, I have built up a fair size collection of books on these two database platforms. I keep some of them at home. As we have grown as a family, available space in the house has subsequently reduced and I sometimes receive polite complaints from my better half because of the … [Read more...] about SQL books that I frequently use
SQL Server Error Log Consuming Lots of Disk Space
I came across a problem this week with one of our SQL Servers whereby one of the drives was very low on space. Whenever I come across a disk space problem, I use my trusty friend Treesize which is a free download and it enables me to quickly find where the space is being consumed. Having run the tool, I quickly found the culprit. It was the SQL Server error log consuming … [Read more...] about SQL Server Error Log Consuming Lots of Disk Space
Using DBCC INPUTBUFFER for SQL Server troubleshooting
In my last post on sp_who2 I demonstrated how this handy utility can help you in your SQL Server troubleshooting efforts. Continuing on from this, I am going to cover DBCC INPUTBUFFER What is DBCC INPUTBUFFER ? It is a command used to identify the last statement executed by a particular SPID. You would typically use this after running sp_who2. The great thing about … [Read more...] about Using DBCC INPUTBUFFER for SQL Server troubleshooting
Using exec sp_who2 to help with SQL Server troubleshooting
If you haven't used sp_who2 before then it is a great utility to help in diagnosing a problem with your database application. What is sp_who2 in SQL Server and what is it used for ? It's a stored procedure which is installed with SQL Server which when run, outputs a row for each "SPID". SPID stands for Server Process ID and one is created every time an application needs to … [Read more...] about Using exec sp_who2 to help with SQL Server troubleshooting
New T-SQL features in SQL Server 2012 – THROW
New in SQL Server 2012 as part of exception handling in T-SQL is THROW Exception handling in previous versions of SQL Server THROW will raise an exception inside of the catch block and there are already ways to do this in previous versions of SQL Server but where this is an improvement over previous methods is that it simplifies writing the code to raise them. So lets … [Read more...] about New T-SQL features in SQL Server 2012 – THROW