Why the term relation(al)?

7yr ⋅

⋅

ADVERTISEMENT

Can MySQL reasonably perform queries on billions of rows?

12yr ⋅

⋅

Why doesn't this query use an index spool?

7yr ⋅

⋅

SQL server databases stuck in restoring state

11yr ⋅

⋅

Large (>22 trillion items) geospatial dataset with rapid (<1s) read query performance

8yr ⋅

⋅

SQL Deadlock on the same exclusively locked clustered Key (with NHibernate) on delete / insert

9yr ⋅

⋅

Multi-statement TVF vs Inline TVF Performance

8yr ⋅

⋅

Seek and you shall Scan... on partitioned tables

9yr ⋅

⋅

Why does Concatenation operator estimate fewer rows than its inputs?

8yr ⋅

⋅

MongoDB MMAPv1 vs WiredTiger storage engines

9yr ⋅

⋅

SQL Server 2016 Bad Query Plan locks up DB once a week

7yr ⋅

⋅

What's up with the collation of some columns in sys.databases?

9yr ⋅

⋅

Max number of user connections

9yr ⋅

⋅

Optimization issue with user defined function

9yr ⋅

⋅

How do I generate a pivoted CROSS JOIN where the resulting table definition is unknown?

7yr ⋅

⋅

Capitalize only the first letter of each word of each sentence in SQL Server

8yr ⋅

⋅

Can SQL Server system tables be defragmented?

8yr ⋅

⋅

Queries without Good Enough Plan Found

8yr ⋅

⋅

How can I convert the first 100 million positive integers to strings?

7yr ⋅

⋅

Why does performing a delete on my partitioned view result in a Clustered Index Insert?

7yr ⋅

⋅

Select all records, join with table A if join exists, table B if not

9yr ⋅

⋅

SET STATISTICS IO- worktable/workfile

9yr ⋅

⋅

ADVERTISEMENT

How to check what Database Engine is installed on the DataBase server that I have acces to run queries on?

7yr ⋅

⋅

Ascending Key Problem - Leading column branded Stationary - SQL Server

8yr ⋅

⋅

How to reload a linked server?

9yr ⋅

⋅

Problem getting zips in radius via MySQL

7yr ⋅

⋅

Do BIT columns offer any performance advantages for CCIs?

7yr ⋅

⋅

How to Drop Table with Non-Printable Character on its name

9yr ⋅

⋅

When converting dynamic SQL (pivot query) to xml output, why is the first digit of the date converted to unicode?

7yr ⋅

⋅

Massive INSERTs blocking SELECTs

8yr ⋅

⋅

DROP USER takes too long when there are many users

8yr ⋅

⋅

Why does this seek on BIGINT col have extra constant scan, compute scalar, and nested loops operators?

7yr ⋅

⋅

How can I seamlessly upgrade the major version of an AWS RDS postgres database?

8yr ⋅

⋅

Implementation of a many-to-many relationship with total participation constraints in SQL

8yr ⋅

⋅

Change in microsoft documentation

7yr ⋅

⋅

Odd Stream Aggregate behaviour

8yr ⋅

⋅

Problem creating a transaction in an SSIS package

9yr ⋅

⋅

ADVERTISEMENT

Encoding issue with SQL Server VARCHAR column retrieved in Python

7yr ⋅

⋅

SQL Server sample Update of Statistics misses highest RANGE_HI_KEY on ascending key column

8yr ⋅

⋅

Why would a table use its primary key as a foreign key to itself

10yr ⋅

⋅

SQL Server detected a logical consistency-based I/O error: incorrect pageid on RESTORE

7yr ⋅

⋅

Computed Column Index Not Used

9yr ⋅

⋅

Transaction with lock on a specific table

7yr ⋅

⋅

Can old collation type impact database performance?

7yr ⋅

⋅

Paging performance with customizable sorting over many millions of rows

10yr ⋅

⋅

Hierarchical permissions in a table stored hierarchy

8yr ⋅

⋅

Cardinality Estimation for >= and > for intra step statistics value

8yr ⋅

⋅

Why does referencing a variable in a join predicate force nested loops?

9yr ⋅

⋅

ADVERTISEMENT

DISTINCT on one column and return TOP rows

7yr ⋅

⋅

Sql Server: A seemingly strange behaviour of BEGIN TRAN - COMMIT

8yr ⋅

⋅

Database Design challenge: One (Table)-to-Many (Tables) Relationship?

7yr ⋅

⋅

SSRS 2016 Report Portal - KPI option no available in drop down

8yr ⋅

⋅

Extracted data WAY bigger than deficit left from deleted rows

7yr ⋅

⋅

Is it possible to do this math in a view?

8yr ⋅

⋅

SSIS 2012 VS_ISBROKEN on Derived Column

7yr ⋅

⋅

Only one administrator can connect at this time (MS SQL Server error 18461)

7yr ⋅

⋅

SQL INDEX - how it works?

10yr ⋅

⋅

Getting a scan though I expect a seek

8yr ⋅

⋅

Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring

7yr ⋅

⋅

Error message - view server state permission was denied - when connecting to SQL Server 2014 using SQL Server 2012 Management Studio

9yr ⋅

⋅

How SQL server generates a Query plan with Auto Create Statistics set to OFF

7yr ⋅

⋅

SARG cardinality estimate, why not full-scan?

9yr ⋅

⋅

Is there any security risk in having many foreign keys referencing a single table?

8yr ⋅

⋅

ISO Week vs SQL Server Week

12yr ⋅

⋅

Postgres Count with different condition on the same query

9yr ⋅

⋅

ADVERTISEMENT

A query that lists all mapped users for a given login

10yr ⋅

⋅

Estimated Operator Cost Calculation

8yr ⋅

⋅

Scalar Operator in Seek Predicate and a Row Estimate of 1

7yr ⋅

⋅

Storing the correct answer to check against

8yr ⋅

⋅

Is it possible to disable the remember password checkbox in SSMS?

8yr ⋅

⋅

Why is TOP operation in SQL execution plan

9yr ⋅

⋅

Restore database with a FileTable

8yr ⋅

⋅

Rolling sum / count / average over date interval

9yr ⋅

⋅

how to query SSISDB to find out the errors in the packages?

9yr ⋅

⋅

Why does this execution plan have Compute Scalars?

8yr ⋅

⋅

SQL Server Transactional Replication snapshot delivery loop

7yr ⋅

⋅

Query 100x slower in SQL Server 2014, Row Count Spool row estimate the culprit?

9yr ⋅

⋅

ADVERTISEMENT

Blocked sessions waiting with PAGELATCH_* wait types?

9yr ⋅

⋅

SQL Comments disappear with psql and `\\e`

7yr ⋅

⋅

Postgres with pgpool architecture

8yr ⋅

⋅

TempDB internal space usage slowly growing from service broker

8yr ⋅

⋅

While using Cross Apply, can I force empty records to appear?

7yr ⋅

⋅

Storing NULL versus storing ' in a varchar column

7yr ⋅

⋅

Can db_datareader user block ALTER TABLE statement?

7yr ⋅

⋅

Factors to consider while Rebuild/Reorganize of index in SQL Server 2012

7yr ⋅

⋅

Why does SQL Server allow a float(53) value that falls outside the range specified by Microsoft?

8yr ⋅

⋅

Why adding SQL Server user to Perform volume maintenance tasks improves the speed of database resizing so much?

9yr ⋅

⋅

zero-or-one to zero-or-one

9yr ⋅

⋅

Can't open a view's design in SSMS

7yr ⋅

⋅

SQL Server 2008 R2 Partitioning - same FileGroup, 1 File, 2 partition_numbers - HELP

9yr ⋅

⋅

Migrating or exporting a database from azure to SQL Server 2016

7yr ⋅

⋅

ADVERTISEMENT

Find highest level of a hierarchical field: with vs without CTEs

13yr ⋅

⋅

Tiny table causes extreme performance degradation, fixed by forced VACUUM. Why?

7yr ⋅

⋅

What is BMK Operator in SQLServer

8yr ⋅

⋅

Reducing the duration of this COUNT() query

7yr ⋅

⋅

Design a relational database (Access) that identifies breaches in records based on user defined limits

7yr ⋅

⋅

Is there anything wrong with linking two identical primary keys in two different tables?

7yr ⋅

⋅

Giving Special Permissions to a Stored Procedure in SQL Server

7yr ⋅

⋅

Index Allocation Maps

8yr ⋅

⋅

How can I model a medical scenario in an entity-relationship diagram?

8yr ⋅

⋅

save/export PGAdmin server list configuration settings

11yr ⋅

⋅

Best way to backup & truncate transaction logs on a schedule

8yr ⋅

⋅

Query Plans Change Performance Worse in SQL Server 2014

9yr ⋅

⋅

How can I represent the entity types depicted in an ERD as relations with attribute headers?

8yr ⋅

⋅

ADVERTISEMENT

Is my implementation of type/subtype design pattern (for mutually exclusive subclasses) correct?

8yr ⋅

⋅

How to create user that can access to master database

7yr ⋅

⋅

Diagnosing a maintenance plan that's ballooned in execution time

7yr ⋅

⋅

Operator used tempdb to spill data during execution with spill level 2

8yr ⋅

⋅

Why does CCI creation on an empty table request a huge memory grant?

7yr ⋅

⋅

Understanding Transaction Recovery

7yr ⋅

⋅

Shrink Transaction Log While Using AlwaysOn Availability Group

10yr ⋅

⋅

Execution plan vs STATISTICS IO order

11yr ⋅

⋅

SSMS 2016, Availability Groups, database is encrypted error

7yr ⋅

⋅

How do I Continue After a Failure in SSIS

10yr ⋅

⋅

How to import export.sql in sql developer?

9yr ⋅

⋅

Collation conflict ... Could not use dbo.sysdac_instances

8yr ⋅

⋅

The curious case of HADR_SYNC_COMMIT waits

9yr ⋅

⋅

Aggressive Autovacuum on PostgreSQL

12yr ⋅

⋅

Delete millions of rows disabling Indexes

7yr ⋅

⋅

SQL Server Management Studio 2016 (Release 16) keeps on crashing

8yr ⋅

⋅

Configuring SQL Server 2016 to allow remote connections

9yr ⋅

⋅

ADVERTISEMENT

TSQL Execution Plan - Estimated Number of Rows = 1 - Poor Performing Query

7yr ⋅

⋅

Optimize finding newest x rows from category

7yr ⋅

⋅

Why should I create an ID column when I can use others as key fields?

13yr ⋅

⋅

How to keep smaller transaction logs files while rebuilding index of very large table

7yr ⋅

⋅

Help constructing a query specifically querying against different dates

7yr ⋅

⋅

How can I improve speed of select?

7yr ⋅

⋅

varchar and nvarchar in tuning a stored procedure - how to improve performance in this scenario?

8yr ⋅

⋅

How to insert a large amount of records to the database in a short time?

9yr ⋅

⋅

MySQL instance stalling doing SYNC index

10yr ⋅

⋅

Rejoining range seek on nullable composite index?

10yr ⋅

⋅

left outer join - sort operations in the query plan - any ways of tuning this simple query?

7yr ⋅

⋅

Hash Match inner join in simple query with in statement

8yr ⋅

⋅

Can't create a server role using GUI in SQL Server 2014 Express

7yr ⋅

⋅

ADVERTISEMENT

SQL Server Select Query Is Slow Even With NC-Index and Full-Text Index

7yr ⋅

⋅

How can I resolve SSIS Excel Connection Manager Error 0xC0209303?

9yr ⋅

⋅

What is the best practice for selecting from two tables with multiple relations?

7yr ⋅

⋅

Oracle is not using a unique index for a long key

11yr ⋅

⋅

SQL, SQLCLR objects & effective memory utilization

8yr ⋅

⋅

High CXPACKET and LATCH_EX waits

11yr ⋅

⋅