If you have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values, Ghanesh Prasad explains how to accomplish this in a Reporting Services report?.
Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.
Steve Jones talks about organizing and tracking work with kanban and how that might help you.
This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.
In this tip, Daniel Farina explains an unconventional way of deleting millions of old records from a table which is accessed by a system 24x7, and without impacting that system.
If you've never encountered this quirk of the SQL UPDATE statement, you should take a look and find a simple way around it.
This week Steve Jones notes that the little details can sometimes have a big impact in your code.
Today's guest editorial by Andy Warren is more of a movie plot than reality, but perhaps it's worth considering.
More and more applications require the handling of geospatial data. It is easy to store spatial data, but it takes rather more thought to retrieve and manipulate it. Tasks like searching neighborhoods, and calculating distances between points is often required from databases. But how do you start? Roy and Surenda take you through the basics.
It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the old trick mixed with a slick trick to format the duration as extended hours, minutes, seconds, and milliseconds.
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Recently, our dev teams approach me for advice on improving their huge heap table...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Comments posted to this topic are about the item Why Your Index Isn't Being...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers