User Hikari

16 votes

5 answers

76k views

Add autoincrement to existing PK

asked Feb 5, 2016 at 19:03

13 votes

2 answers

44k views

SQL Server : which role grants permission to execute all stored procedures?

asked Nov 10, 2016 at 15:17

12 votes

3 answers

56k views

SQL Server: grant select access to a user in a view and not in its tables

asked Jan 19, 2015 at 13:34

9 votes

3 answers

69k views

Execute stored procedure remotely using linked server

asked Jul 22, 2016 at 14:34

8 votes

1 answer

41k views

Filter first then join or join first then filter?

asked Mar 24, 2016 at 18:16

7 votes

1 answer

651 views

.NET executes a SQL query and Active Monitor shows multiple rows blocking each other

asked Jun 19, 2019 at 13:43

5 votes

3 answers

18k views

Force SQL Server to parse "DDMMYYYY"

asked Sep 14, 2016 at 14:37

4 votes

1 answer

11k views

Create Linked Server using Active Directory account

asked Apr 5, 2016 at 15:41

4 votes

2 answers

8k views

Grant Admin to an Active Directory account in SQL Server

asked Apr 4, 2016 at 14:13

4 votes

1 answer

8k views

How many rows can a SQL Server 2012 table hold, and when should I partition it?

asked Mar 1, 2016 at 17:47

4 votes

1 answer

7k views

Verify if user has read access to a table

asked Nov 24, 2014 at 13:00

3 votes

3 answers

5k views

Index optimization for table that is truncated every day

asked Sep 10, 2014 at 20:08

3 votes

1 answer

6k views

Find out beforehand how many records a query has

asked Jan 29, 2015 at 22:41

3 votes

1 answer

98 views

Tool for quickly backup and restore a table

asked Feb 18, 2015 at 14:24

3 votes

1 answer

1k views

Set a filegroup to readonly

asked Mar 23, 2016 at 18:16

3 votes

2 answers

1k views

Unable to delete secondary data file

asked Apr 13, 2017 at 14:49

2 votes

1 answer

928 views

Hold exclusive lock on a whole DB

asked Mar 24, 2016 at 16:41

2 votes

1 answer

4k views

Order by values with most incidence

asked Aug 14, 2015 at 14:03

2 votes

5 answers

16k views

List all tables from all user databases

asked Sep 14, 2015 at 12:29

2 votes

2 answers

2k views

Are nonclustered indexes used when joining tables?

asked Feb 3, 2015 at 12:46

2 votes

1 answer

2k views

Unable to set user/group as principal on a proxy

asked Apr 5, 2016 at 18:28

2 votes

1 answer

15k views

Windows Authentication fails with "Cannot generate SSPI context"

asked Apr 20, 2016 at 14:03

2 votes

3 answers

521 views

Discover available HD storage from inside SQL Server

asked Nov 12, 2015 at 11:31

1 vote

5 answers

12k views

Query last time a view, function or sp was last used/read

asked Aug 15, 2016 at 15:02

1 vote

4 answers

1k views

SSMS not coloring tables, columns and variables

asked Aug 26, 2016 at 17:20

1 vote

1 answer

718 views

Best solution to keep a big table synched in 2 DB

asked May 31, 2016 at 17:40

1 vote

2 answers

413 views

Linked Server works on SSMS and isn't found on SSDT

asked Jun 2, 2016 at 15:43

1 vote

1 answer

353 views

User on SQLAgentOperatorRole unable to edit jobs

asked Jul 16, 2020 at 15:18

1 vote

1 answer

2k views

SQL Server 2012 SSIS : retrieve line number in Flat File Connection Manager

asked Mar 12, 2015 at 14:49

1 vote

1 answer

121 views

Sum currencies excluding duplicatied records

asked Aug 12, 2015 at 16:45

Stack Exchange Network

42 Questions

Add autoincrement to existing PK

SQL Server : which role grants permission to execute all stored procedures?

SQL Server: grant select access to a user in a view and not in its tables

Execute stored procedure remotely using linked server

Filter first then join or join first then filter?

.NET executes a SQL query and Active Monitor shows multiple rows blocking each other

Force SQL Server to parse "DDMMYYYY"

Create Linked Server using Active Directory account

Grant Admin to an Active Directory account in SQL Server

How many rows can a SQL Server 2012 table hold, and when should I partition it?

Verify if user has read access to a table

Index optimization for table that is truncated every day

Find out beforehand how many records a query has

Tool for quickly backup and restore a table

Set a filegroup to readonly

Unable to delete secondary data file

Hold exclusive lock on a whole DB

Order by values with most incidence

List all tables from all user databases

Are nonclustered indexes used when joining tables?

Unable to set user/group as principal on a proxy

Windows Authentication fails with "Cannot generate SSPI context"

Discover available HD storage from inside SQL Server

Query last time a view, function or sp was last used/read

SSMS not coloring tables, columns and variables

Best solution to keep a big table synched in 2 DB

Linked Server works on SSMS and isn't found on SSDT

User on SQLAgentOperatorRole unable to edit jobs

SQL Server 2012 SSIS : retrieve line number in Flat File Connection Manager

Sum currencies excluding duplicatied records