Before diving into queries, confirm that sqlservr.exe is the process consuming the CPU, and not an antivirus, backup tool, or OS update. T-SQL Check Run this to see the CPU utilization history over ...

-- - Supports the scenario where log files list consist of both the file name formats -- - When CSV format is used, a check-constraint is added to the child table ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Use Dynamic Management Views (DMVs) to find the top resource-consuming queries. -- Find Top 10 Most Expensive Queries SELECT TOP 10 qs.total_elapsed_time / qs.execution_count AS [Avg Exec Time], ...

SQL Injection (SQLi) is a type of security vulnerability that allows an attacker to interfere with the queries that an application makes to its database. SQL Injection is one of the most common and ...

Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Theft of private information is a significant problem for online applications. For example, a recent investigation found that at least eight million people’s medical records were stolen as a result of ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...