Though duplicate rows are bad practice, sometimes they're necessary for a short time. But how do you clean your tables when they're no longer needed? Sergey Gigoyan provides a few different solutions.
Tables used purely for reporting sometimes lack a unique identifier. Find out how to remove duplicates from such a table when data loads go bad.
So you’re hosting your SQL Server in the cloud, and you’ve noticed that when you’re running a backup or a DBCC CHECKDB, you suffer from extreme performance problems - what's going on? Brent Ozar explains.
ODBC is the closest thing we have to a universal standard for data access across platforms, applications and data sources. So why doesn't DocumentDB support it?
On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.
Power BI has a lot of uses, but one of the most interesting of them is to model and shape data to make it easier for self-service BI. Power BI is a full-stack solution that includes data loading, data modelling, metrics, reporting and distribution. It can take the source data, and perform in-process data modelling relatively easily as well a providing an easy to use and powerful user interface for analytics and reporting.
Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.
This week Steve Jones has a bit of a competition. Share with him how fast you can back up a 1TB database.
Developing JavaScript for web pages can be perplexing. You will get errors that seem to make no sense, You will be given nuggets of advice about how and when you can use JavaScript to manipulate the DOM or make Ajax requests. It is far better to understand the reason for these rules; the single-threaded nature of JavaScript, and how it loads the page and manages the event loop. How can you achieve parallel processing and what is the best way? Igor makes it all clear and obvious.
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers