seventyeightist's user avatar
seventyeightist's user avatar
seventyeightist's user avatar
seventyeightist
  • Member for 7 years, 1 month
  • Last seen more than a month ago
  • UK
9 votes
Accepted

Why is it faster to do four simple selects instead of one select with left joins?

6 votes
Accepted

How to select multiple id from same table

6 votes
Accepted

Struggling with left join - products

5 votes
Accepted

Rename Availability Group and AG script

4 votes
Accepted

2 GROUP BY WITH DISTINCT , SUM , COUNT : PHP MYQL

4 votes

Which row is selected by DISTINCT?

4 votes
Accepted

SSDT Publish Window: What does checkbox ENABLE mean?

3 votes

SQL DB2 query with where clause

3 votes

SQL Server logins and users -- assign multiple logins to a single user?

3 votes
Accepted

Windows Authentication Server Role Verification

3 votes

How can I get the hierarchical values from the below query?

3 votes
Accepted

Getting error message when opening report server home page ( found 163 but 162 needed)

3 votes

Do I need a partition scheme for each partitioned table

3 votes
Accepted

Difference Between a Staging and the Production DWH

2 votes

How to restore single table in Sql Server 2016

2 votes
Accepted

Multiple COUNT fields, GROUP BY

2 votes
Accepted

SQL Server Merge mandate

2 votes

Select into statement

1 vote

Indexed (Materialized) View for Parent and Newest Child

1 vote

Events-Users Database Design

1 vote
Accepted

Setting An Order For Specific Fields Using SELECT and ORDER BY

1 vote

What is the point of the Script Date in a stored procedure script generated by SSMS?

0 votes

Error on simple Select statement: Subquery returned more than 1 value

0 votes
Accepted

Get rows with minimum value