Aaron Bertrand (@AaronBertrand), of SQL Sentry, follows up his original running totals post with an article describing different ways to achieve the same types of results for more complex grouping and aggregation.
Continue Reading »Jan 292014
Jan 272014
Paul White (@SQL_Kiwi) relays some useful information about SQL Server execution plans that include StarJoinInfo.
Continue Reading »Jan 232014
After a discussion with a colleague, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a look at the IDENT_CURRENT() function, and demonstrates how it cannot be relied upon for reporting the IDENTITY value that was generated – even under the SERIALIZABLE isolation level.
Continue Reading »Jan 212014
Glenn Berry (@GlennAlanBerry) of SQLskills.com provides excellent background information on your best choices for processor selection if you are building hardware to support SQL Server 2014.
Continue Reading »Jan 172014
SQL Sentry's Aaron Bertrand (@AaronBertrand) talks a little more about in-memory table-valued parameters, and explains why some scenarios you test may not demonstrate the power of this technology.
Continue Reading »Jan 152014
Paul White (@SQL_Kiwi) talks about multiple predicate cardinality, including some new and undocumented trace flags in SQL Server 2014.
Continue Reading »Jan 132014
Aaron Bertrand (@AaronBertrand) explains how he could justify purchasing a new Mac Pro, and shows that it is very tough to order a comparable PC at similar price points.
Continue Reading »
1
2