Outer Web | Explore

Explore >> Select a destination

You are here		matthewmcgiffen.com Avoid "Constants" in T-SQL - Matthew McGiffen Data
\|	\|	explainextended.com SQL Server: Selecting records holding group-wise maximum (with ties) at EXPLAIN EXTENDED	9.4 parsecs away Travel
\|	\|	A series of articles on selecting records holding group-wise maximum. This article covers two ways to return such records with ties: DENSE_RANK and CROSS APPLY / TOP 1 WITH TIES	9.4 parsecs away Travel
\|	\|	dbanuggets.com Query Store Fundamentals: Query Store Hints - Deepthi Goguri's SQL Server Blog	11.8 parsecs away Travel
\|	\|	Source: Image Query Store hints is another amazing feature added and is available in the preview mode in Azure SQL Database, managed instances, elastic pools and hyperscale databases as well. Query Store hints are just like the hints you use in your queries but the difference is you do not have to change the query...	11.8 parsecs away Travel
\|	\|	www.brentozar.com Query Exercise: Finding Long Values Faster - Brent Ozar Unlimited®	12.4 parsecs away Travel
\|	\|	Our developers have come to us with a problem query that isn't as fast as they'd like. Using any Stack Overflow database: [crayon-666370cc67ad1765058225/] It has an index, but SQL Server refuses to use that index in the execution plan: If we force the index with a query hint, we do indeed get dramatically lower logical...	12.4 parsecs away Travel
\|	\|	cardinalguzman.wordpress.com P7090541 \| Cardinal Guzman	37.0 parsecs away Travel
\|		Encyclopedia Miscellaneous - 'quality' blogging since August 2011	37.0 parsecs away Travel