Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, Denzil Ribeiro describes the index rebuild process and index maintenance for clustered Columnstore indexes in SQL 2014.
Detecting file differences on two different web servers using T-SQL.
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
An invitation to hack United's IT systems has resulted in vulnerabilities being found and hackers rewarded for disclosing the issues.
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
Steve Jones discusses the decision to hire someone that fits in with your culture at work, and what that means.
Unlike some other industrial-strength database servers, SQL Server lacks a built-in mechanism for protecting individual data records, called row-level security. This stairway level explores why you might want to use such a low-level granularity of data access security and how you can implement row-level security.
One of the more confusing statistics in Oracle is one called the clustering factor. Associated with an index, it's actually dependent on the table data, more specifically the distance between 'jumps' for a given index key. Commonly, a 'jump' is the number of blocks between rows containing the given index key starting with the first block found containing that key. If that sounds confusing don't despair, David Fitzjarrell explains in detail.
An amazing visualization of basketball players has Steve Jones encouraging you to find your own pet project and showcase some skills.
MSDB is a system database used by SQL Server. MSDB stores all sorts of data, such as backup history, log shipping monitor history, SSIS packages and Service Broker queue data to name a few. Just like user databases, MSDB needs regular maintenance, including index optimizations and, more importantly, regular purging. In this article, Tim Radney looks at how neglecting your MSDB can negatively impact on your environment.
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Jl. Sukarjo Wiryopranoto No.28 C, Kb. Klp., Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...
Jl. Sk. Rd. Syahbudin B No.53, RT.004/RW.000, Mayang Mangurai, Kec. Kota Baru, Kota Jambi,...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers