Previous T-SQL best practices articles have discussed different coding styles that led to slow and fast query executions, and ways to minimize cached plans. This article will be an extension on those concepts, focusing on how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.
What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.
The next update for SQL Server has had a major release with the CTP of SQL Server 2008 R2. Brad McGehee is wondering if you've seen some of the enhancements that have been added to this new version.
Compression is one of the major features introduced in SQL Server 2008, and one that can significantly reduce disk storage. ...
Rodney Landrum describes in his own unique style how he, as a working DBA, goes about troubleshooting problem queries, and investigating various types of locking and blocking problems. In the process, he passes on valuable tips learned from practical, and sometimes stressful, experience.
This article will cover how we can make use of the WMI Data Reader Task to retrieve information about remote machines. Our example will focus Disk space usage of remote machines.
We sometimes find ourselves in situations that we didn't count on. Or that aren't necessarily a mistake we made in the installation. Steve Jones reminds us that we should keep that in mind when someone is asking for our help.
I attended a presentation recently from Steven Wright of SQL Sentry on Analysis Services (SSAS) memory management and it was...
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
When the schema of an object is changed, SQL Server wipes out the previous...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Comments posted to this topic are about the item 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