Shrinking SQL Server Transaction Logs

By Wednesday, September 10, 2014 Permalink 1

Under some specific circumstances you will find yourself in the need of reducing/shrinking the physical size of transaction logs. Let's see a quick example of how to achieve this: 1) You can use DBCC SQLPERF (LOGSPACE) to quickly and easily list the size and percentage of use of all your databases' transaction logs. You will get something like ...

SQL Server 2014 is here!

By Wednesday, September 10, 2014 Permalink 0

I believe that some of us are still catching up with all the new great features introduced by SQL Server 2012 and now there is more work to do as with April came the general availability of SQL Server 2014, so what's new with SQL Server 2014?With this release, perhaps due to the short time-span ...