Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.
2014-06-02
6,957 reads
Comparing columns of different data types can be a drain on resources, as well as our sanity. This is a look into a few strategies for dealing with implicit conversions.
2014-05-19
9,736 reads
An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?
2014-05-05
6,815 reads
Inevitably, every DBA is eventually asked to delete, merge, or otherwise report on duplicate data. There are many tools at our disposal to make this task both simple and efficient to complete. Read on for simple steps and examples to effectively deal with duplicate data.
2014-04-29
6,683 reads
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
By Brian Kelley
Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...
By Steve Jones
the wends– n. the frustration that you’re not enjoying an experience as much as...
Hello all, I am thinking of creating a "shopping cart" in our application. My...
Hello there. I have the following Pipeline I want to get the property error...
I'm installing a cluster prior to my 2019 SQL build. Failover Cluster tools...
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers