User Kirk Saunders

0 votes

How to structure predicate to trigger a clustered index seek after a certain record with a composite key?

answered Jan 11 at 12:37

3 votes

Help - Database design

answered Jan 4 at 18:27

2 votes

Best way to model the relationship of unique pairs

answered Apr 9, 2020 at 20:07

1 vote

Accepted

How to join different tables with same propriety tables?

answered May 15, 2020 at 14:50

1 vote

Accepted

SQL Server Show table when hovering over a keyword

answered Apr 8, 2020 at 1:26

1 vote

Accepted

How can I fill in a foreign key value after creating the first entry of the table the foreign key is referencing?

answered Apr 4, 2020 at 21:57

2 votes

Accepted

Convert rows into columns and group some colums

answered Apr 4, 2020 at 20:39

1 vote

Why does SQL Server not use the Index it recommends?

answered Apr 2, 2020 at 15:34

1 vote

Do you think is necessary to create an auxiliary translate table for table that has only two elements (id and name)

answered Mar 27, 2020 at 19:07

1 vote

Accepted

Constrain unique value between multiple tables

answered Sep 11, 2019 at 19:46

2 votes

Accepted

Hierarchical references abstraction with strict model

answered Jun 30, 2019 at 16:05

0 votes

Calculate Inventory Costing Based on First in, First Out (FIFO)

answered Jul 15, 2019 at 21:12

2 votes

Create a function/tsql to get strings from the 1st table/data and compare and convert if from the value of second table

answered Jul 3, 2019 at 19:57

1 vote

Accepted

How to query in such a way that values becomes columns?

answered Jul 1, 2019 at 19:48

0 votes

How to avoid conditional join in order to write a tsql view

answered Jun 30, 2019 at 22:44

0 votes

How to delete foreign key with lots of references

answered Jun 30, 2019 at 17:18

3 votes

Example of query execution plan where the cardinality estimation makes a difference

answered Jun 28, 2019 at 14:11

3 votes

Sql restrict insert records for the same client based on 2 columns

answered Jun 27, 2019 at 18:44

3 votes

Accepted

How to get count 0 using group by if record not exist?

answered Jun 27, 2019 at 14:52

0 votes

Split Multiple Columns Into Multiple Columns by Delimiter

answered Jun 26, 2019 at 20:26

2 votes

Accepted

Need help in picking solution and understanding when to add columns vs EAV

answered Jun 25, 2019 at 15:10

1 vote

Accepted

SSIS job -- how to create stored procedure that repeats SSIS jobs?

answered Jun 24, 2019 at 21:10

3 votes

Accepted

How to calculate the sums of two columns, when that two columns brought by join queries?

answered Jun 24, 2019 at 20:14

1 vote

Very similar queries, vastly different performance

answered Jun 18, 2019 at 14:16

2 votes

WHILE Loop for data migration/merge with multiple fields for matching

answered Jun 17, 2019 at 21:35

2 votes

How to merge records in SQL

answered Jun 17, 2019 at 17:55

2 votes

Accepted

How to take make OFFSET & LIMIT with COUNT (OVER?) when having a subquery?

answered Jun 14, 2019 at 20:45

1 vote

GROUP By Statement to detect duplicates

answered Jun 13, 2019 at 14:24

Stack Exchange Network

28 Answers

How to structure predicate to trigger a clustered index seek after a certain record with a composite key?

Help - Database design

Best way to model the relationship of unique pairs

How to join different tables with same propriety tables?

SQL Server Show table when hovering over a keyword

How can I fill in a foreign key value after creating the first entry of the table the foreign key is referencing?

Convert rows into columns and group some colums

Why does SQL Server not use the Index it recommends?

Do you think is necessary to create an auxiliary translate table for table that has only two elements (id and name)

Constrain unique value between multiple tables

Hierarchical references abstraction with strict model

Calculate Inventory Costing Based on First in, First Out (FIFO)

Create a function/tsql to get strings from the 1st table/data and compare and convert if from the value of second table

How to query in such a way that values becomes columns?

How to avoid conditional join in order to write a tsql view

How to delete foreign key with lots of references

Example of query execution plan where the cardinality estimation makes a difference

Sql restrict insert records for the same client based on 2 columns

How to get count 0 using group by if record not exist?

Split Multiple Columns Into Multiple Columns by Delimiter

Need help in picking solution and understanding when to add columns vs EAV

SSIS job -- how to create stored procedure that repeats SSIS jobs?

How to calculate the sums of two columns, when that two columns brought by join queries?

Very similar queries, vastly different performance

WHILE Loop for data migration/merge with multiple fields for matching

How to merge records in SQL

How to take make OFFSET & LIMIT with COUNT (OVER?) when having a subquery?

GROUP By Statement to detect duplicates