2010-04-01
4,449 reads
humor
2010-04-01
3,279 reads
Decoding the SQL Server Index Structure
A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!
2010-04-01
8,204 reads
Insider Insights
Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.
2010-04-01
2,611 reads
2010-04-01 (first published: 2010-03-31)
4,380 reads
2009-12-25
3,680 reads
2009-07-03
5,242 reads
2009-04-01
5,362 reads
SQLServerCentral To Take Over PASS
After intense negotiations with CA and Microsoft, the founding sponsors of PASS, SQLServerCentral has agreed to take over the organization.
2009-04-01
2,042 reads
2009-04-01
5,209 reads
Blogs
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Breaking Rules in Rome
By Steve Jones
Last week I was honored with a trip to Rome for the Redgate President’s...
Forums
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Distance Metric Algorithms
Comments posted to this topic are about the item Distance Metric Algorithms
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers