I opened (right-click server instance in Object Explorer). Saw the batch requests/sec spike, then settle. No blocking. No heavy waits. Perfect.
CREATE NONCLUSTERED INDEX IX_FactSales_OrderDate_Include ON Sales.FactSales (OrderDate) INCLUDE (CustomerID, ProductID, Revenue);
Ten minutes later, it suggested three missing indexes and one statistic update. I scripted them out – because in 2014, you never let the advisor run automatically on production. You read every CREATE INDEX like a surgeon reading a consent form. sql studio 2014
SELECT CustomerID, Quarter, Revenue FROM Sales.FactQuarters UNPIVOT (Revenue FOR Quarter IN ([Q1_2014],[Q2_2014],[Q3_2014],[Q4_2014],...,[Q4_2024])) AS unpvt; The little red squiggly line appeared under UNPIVOT . SSMS 2014’s parser didn't highlight syntax errors in real-time – but the did something worse when I pressed F5 : Msg 102, Level 15, State 1, Line 5 Incorrect syntax near 'UNPIVOT'. I laughed. Of course. SQL Server 2014 supports UNPIVOT, but someone had changed the database compatibility level to 90 (SQL Server 2005). A trap.
But the server hummed a little quieter that day. And somewhere in the logs, a 2014 query plan smiled. Tools age, but fundamentals don't. Execution plans, indexing, statistics, and parameter sniffing – SSMS 2014 forced you to know them. And knowing them still saves the day. I opened (right-click server instance in Object Explorer)
I closed SSMS 2014. The splash screen flashed for a second – the classic blue SQL Server logo. I saved my session (Session > Save as .sql) into a folder called Phoenix_Fixes . No Git. No CI/CD. Just a network drive and a prayer.
I wrote one last script in the – the place where SSMS 2014 truly shined for T-SQL development. No notebooks, no extensions, just pure SQL: No heavy waits
I connected to the production instance: FIN-SRV-03\LEGACY . The Object Explorer slowly populated – Databases > System Databases > WideWorldImporters (a test restore, thankfully, not live). Tables, Views, Stored Procedures… thousands of them.