For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped… Read More »Testing for Object Existence: DROP … IF EXISTS
(Last updated 2020-01-07) This is more for my own reference than anything. On newer versions of Windows desktop and Windows Server, we may find that… Read More »Configuration Manager Shortcut on Windows 10 and Server 2016
[Last updated February 27, 2020] Brent Ozar Unlimited runs a website called SQL Server Updates which comes in really handy for keeping your on-premises SQL… Read More »Should I upgrade SQL Server 2012, or migrate to Azure?
With permission from Kimberly Tripp, the creator of the fantastic duplicate index finder for SQL Server 2005 and 2008, I have ported this duplicate index… Read More »Remove duplicate indexes in SQL Server 2000
For those of you battling with a 64-bit SQL 2005 Server linking to 32-bit SQL 2000 Servers, here’s a handy solution. This problem has been… Read More »Link 64-bit SQL Server 2005 to 32-bit SQL Server 2000