Common Table Expressions (CTEs), window functions, and views are all common things in SQL Server development these days. When CTEs and window functions were introduced in SQL Server 2005, a lot of developers jumped in and began using them to solve problems and simplify code. While these tools can be a great benefit in SQL [...]
Jonathan Kehayias
The Rambling DBA
Common Table Expressions (CTEs), Window Functions, and Views
Posted on: January 25, 2013 1:00 pm
Performance Tuning SQL Server on Windows Server 2012
Posted on: January 17, 2013 12:52 pm
Properly configuring Windows and SQL Server to get the best performance from your server hardware is an important task for database administrators. There is a lot of information available online with different recommendations about how to configure your servers for the best performance. The challenge is knowing what recommendations are correct and what advice you [...]
