Never, Ever Use Clustered Indexes
This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...
2012-05-31
2,363 reads
Blog Posts
No More SQLRally In the US
I was disappointed to see the mention in the Connector today that there would be no SQLRally 2013 in the...
2012-05-31
1,694 reads
Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1 (Republished)
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-31
3,843 reads
SQL Saturday #167 – Columbus GA
The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus...
2012-05-31
1,715 reads
SSIS Project Connection Managers
With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature...
2012-05-31
3,798 reads
Turn on Instant File Initialization for SQL Server Performance – With Video Demo
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-31
1,815 reads
Denali – Day 30: Deprecated Features
Denali – Day 30: Deprecated Features Deprecated feature means these features are available in the current version of Sql server but...
2012-05-30
2,663 reads
Learning Tree: SQL Server DBA Skills Upgrade
I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week...
2012-05-30
2,132 reads
Syncing your calendars
I have a desktop computer, a laptop, and a iPhone. I frequently add meetings to my Outlook calender on my...
2012-05-30
1,969 reads
Turn on Instant File Initialization for SQL Server Performance
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-30
4,369 reads
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers