User VansFannel

55 votes

4 answers

143k views

Check if a user exists in a SQL Server database

asked Jan 11, 2016 at 13:46

28 votes

2 answers

44k views

Could a null column be part of a primary key?

asked Sep 18, 2015 at 7:56

19 votes

4 answers

39k views

NVARCHAR column as PRIMARY KEY or as UNIQUE column

asked Feb 10, 2015 at 7:51

14 votes

4 answers

37k views

Survey database design: associate an answer to a user

asked Apr 3, 2012 at 13:05

5 votes

1 answer

6k views

Survey database design: first version. Are there errors?

asked Apr 4, 2012 at 10:57

5 votes

1 answer

6k views

How to represent a many to many relationship with Crow Feet diagram

asked May 24, 2014 at 9:52

5 votes

2 answers

25k views

Substring without the first n characters

asked May 4, 2018 at 7:52

4 votes

1 answer

372 views

Optimize two sql sentences adding indices

asked Sep 29, 2016 at 6:45

3 votes

1 answer

549 views

Is this many to many relationship correct? [duplicate]

asked May 25, 2014 at 14:46

2 votes

0 answers

115 views

Deadlock when CODES table has 41900 rows

asked Sep 16, 2014 at 11:02

2 votes

2 answers

4k views

Grant execute on xp_logevent to sa using sa user to do it

asked Jun 30, 2015 at 10:58

2 votes

1 answer

680 views

Are my views slowing down an update?

asked Sep 29, 2016 at 9:35

2 votes

1 answer

2k views

Optimize a UNIQUE CONSTRAINT to make SELECT faster

asked Oct 3, 2016 at 6:12

2 votes

1 answer

479 views

One to one relationship naming conventions [closed]

asked May 13, 2016 at 8:49

2 votes

1 answer

2k views

Generate nested array with OPENJSON very slow

asked Mar 8, 2018 at 13:45

2 votes

2 answers

5k views

Grant user from my database to execute xp_cmdshell

asked Mar 20, 2018 at 10:53

2 votes

1 answer

75 views

Get all of the rows involved between tables relationships

asked Apr 26, 2018 at 10:11

2 votes

4 answers

4k views

Update a table faster than an INNER JOIN

asked Sep 28, 2016 at 14:57

1 vote

1 answer

1k views

Add a column to a table and then "insert into" is invalid in a stored procedure

asked Jun 2, 2017 at 9:43

1 vote

0 answers

892 views

why an update doesn't update a row if the where clause exists?

asked Nov 24, 2016 at 11:14

1 vote

1 answer

90 views

From a user table check if one of them exists on a table

asked Jan 13, 2017 at 9:19

1 vote

2 answers

4k views

Foreign key as part of composite primary key or not?

asked Apr 26, 2016 at 7:31

1 vote

1 answer

1k views

xp_logevent Invalid Parameter Type

asked Oct 30, 2014 at 14:26

1 vote

1 answer

134 views

How can I improve this update?

asked Mar 17, 2015 at 16:09

1 vote

1 answer

2k views

Log debug messages in a SQL CLR C# Stored Procedure

asked Jun 17, 2015 at 12:11

1 vote

2 answers

773 views

I don't know how to read many to many relationships

asked May 24, 2014 at 9:41

1 vote

1 answer

1k views

Deadlock while updating rows and inserting new ones

asked Jun 19, 2014 at 8:55

1 vote

1 answer

87 views

Database design problem: where to put UNIQUE constraint

asked May 8, 2012 at 6:13

0 votes

1 answer

111 views

Unknown relationship

asked May 19, 2012 at 5:32

0 votes

1 answer

315 views

Create a certificate with a private key

asked Apr 11, 2014 at 11:22

Stack Exchange Network

39 Questions

Check if a user exists in a SQL Server database

Could a null column be part of a primary key?

NVARCHAR column as PRIMARY KEY or as UNIQUE column

Survey database design: associate an answer to a user

Survey database design: first version. Are there errors?

How to represent a many to many relationship with Crow Feet diagram

Substring without the first n characters

Optimize two sql sentences adding indices

Is this many to many relationship correct? [duplicate]

Deadlock when CODES table has 41900 rows

Grant execute on xp_logevent to sa using sa user to do it

Are my views slowing down an update?

Optimize a UNIQUE CONSTRAINT to make SELECT faster

One to one relationship naming conventions [closed]

Generate nested array with OPENJSON very slow

Grant user from my database to execute xp_cmdshell

Get all of the rows involved between tables relationships

Update a table faster than an INNER JOIN

Add a column to a table and then "insert into" is invalid in a stored procedure

why an update doesn't update a row if the where clause exists?

From a user table check if one of them exists on a table

Foreign key as part of composite primary key or not?

xp_logevent Invalid Parameter Type

How can I improve this update?

Log debug messages in a SQL CLR C# Stored Procedure

I don't know how to read many to many relationships

Deadlock while updating rows and inserting new ones

Database design problem: where to put UNIQUE constraint

Unknown relationship

Create a certificate with a private key