VansFannel's user avatar
VansFannel's user avatar
VansFannel's user avatar
VansFannel
  • Member for 11 years, 6 months
  • Last seen more than a month ago
54 votes
4 answers
134k views

Check if a user exists in a SQL Server database

26 votes
2 answers
40k views

Could a null column be part of a primary key?

19 votes
4 answers
36k views

NVARCHAR column as PRIMARY KEY or as UNIQUE column

14 votes
4 answers
36k views

Survey database design: associate an answer to a user

5 votes
1 answer
6k views

Survey database design: first version. Are there errors?

5 votes
1 answer
5k views

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

5 votes
2 answers
22k views

Substring without the first n characters

4 votes
1 answer
353 views

Optimize two sql sentences adding indices

3 votes
1 answer
535 views

Is this many to many relationship correct? [duplicate]

2 votes
0 answers
113 views

Deadlock when CODES table has 41900 rows

2 votes
2 answers
4k views

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

2 votes
1 answer
524 views

Are my views slowing down an update?

2 votes
1 answer
2k views

Optimize a UNIQUE CONSTRAINT to make SELECT faster

2 votes
1 answer
450 views

One to one relationship naming conventions [closed]

2 votes
4 answers
4k views

Update a table faster than an INNER JOIN

2 votes
1 answer
2k views

Generate nested array with OPENJSON very slow

2 votes
2 answers
4k views

Grant user from my database to execute xp_cmdshell

2 votes
1 answer
60 views

Get all of the rows involved between tables relationships

1 vote
1 answer
1k views

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

1 vote
0 answers
686 views

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

1 vote
1 answer
89 views

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

1 vote
2 answers
3k views

Foreign key as part of composite primary key or not?

1 vote
1 answer
1k views

xp_logevent Invalid Parameter Type

1 vote
1 answer
133 views

How can I improve this update?

1 vote
1 answer
2k views

Log debug messages in a SQL CLR C# Stored Procedure

1 vote
2 answers
743 views

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

1 vote
1 answer
1k views

Deadlock while updating rows and inserting new ones

1 vote
1 answer
84 views

Database design problem: where to put UNIQUE constraint

0 votes
1 answer
110 views

Unknown relationship

0 votes
1 answer
256 views

Create a certificate with a private key