User Hikari

16 votes

5 answers

75k views

Add autoincrement to existing PK

asked Feb 5, 2016 at 19:03

13 votes

2 answers

42k views

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

sql-server sql-server-2012 permissions security

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

sql-server schema permissions

asked Jan 19, 2015 at 13:34

9 votes

3 answers

69k views

Execute stored procedure remotely using linked server

sql-server sql-server-2012 stored-procedures

asked Jul 22, 2016 at 14:34

7 votes

1 answer

637 views

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

sql-server sql-server-2014 optimization ado.net activity-monitor

asked Jun 19, 2019 at 13:43

6 votes

1 answer

40k views

Filter first then join or join first then filter?

sql-server sql-server-2012 optimization

asked Mar 24, 2016 at 18:16

5 votes

3 answers

18k views

Force SQL Server to parse "DDMMYYYY"

sql-server sql-server-2012 date-format

asked Sep 14, 2016 at 14:37

4 votes

1 answer

11k views

Create Linked Server using Active Directory account

sql-server sql-server-2012 permissions security linked-server

asked Apr 5, 2016 at 15:41

4 votes

2 answers

8k views

Grant Admin to an Active Directory account in SQL Server

sql-server sql-server-2012 permissions security active-directory

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?

sql-server sql-server-2012 partitioning

asked Mar 1, 2016 at 17:47

4 votes

1 answer

7k views

Verify if user has read access to a table

sql-server sql-server-2012 permissions ssis-2012

asked Nov 24, 2014 at 13:00

3 votes

3 answers

5k views

Index optimization for table that is truncated every day

sql-server clustered-index nonclustered-index optimization query-performance

asked Sep 10, 2014 at 20:08

3 votes

1 answer

6k views

Find out beforehand how many records a query has

sql-server sql-server-2012 optimization query-performance

asked Jan 29, 2015 at 22:41

3 votes

1 answer

98 views

Tool for quickly backup and restore a table

sql-server sql-server-2012 backup restore

asked Feb 18, 2015 at 14:24

3 votes

1 answer

1k views

Set a filegroup to readonly

sql-server sql-server-2012 optimization read-only-database

asked Mar 23, 2016 at 18:16

3 votes

2 answers

1k views

Unable to delete secondary data file

sql-server sql-server-2012 delete

asked Apr 13, 2017 at 14:49

2 votes

1 answer

914 views

Hold exclusive lock on a whole DB

sql-server sql-server-2012 deadlock blocking locking

asked Mar 24, 2016 at 16:41

2 votes

1 answer

4k views

Order by values with most incidence

sql-server sql-server-2012 t-sql

asked Aug 14, 2015 at 14:03

2 votes

5 answers

16k views

List all tables from all user databases

sql-server sql-server-2012

asked Sep 14, 2015 at 12:29

2 votes

2 answers

2k views

Are nonclustered indexes used when joining tables?

sql-server index optimization nonclustered-index query-performance

asked Feb 3, 2015 at 12:46

2 votes

1 answer

1k views

Unable to set user/group as principal on a proxy

sql-server sql-server-2012 permissions jobs proxy

asked Apr 5, 2016 at 18:28

2 votes

1 answer

15k views

Windows Authentication fails with "Cannot generate SSPI context"

sql-server sql-server-2012 authentication active-directory

asked Apr 20, 2016 at 14:03

2 votes

3 answers

515 views

Discover available HD storage from inside SQL Server

sql-server sql-server-2012 storage dmv

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

sql-server sql-server-2012

asked Aug 15, 2016 at 15:02

1 vote

4 answers

1k views

SSMS not coloring tables, columns and variables

sql-server ssms

asked Aug 26, 2016 at 17:20

1 vote

1 answer

712 views

Best solution to keep a big table synched in 2 DB

sql-server sql-server-2012 linked-server data-synchronization

asked May 31, 2016 at 17:40

1 vote

2 answers

412 views

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

sql-server sql-server-2012 linked-server ssdt dts

asked Jun 2, 2016 at 15:43

1 vote

1 answer

298 views

User on SQLAgentOperatorRole unable to edit jobs

sql-server sql-server-2012 sql-server-agent

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

sql-server ssis-2012

asked Mar 12, 2015 at 14:49

1 vote

1 answer

121 views

Sum currencies excluding duplicatied records

sql-server join group-by duplication sum

asked Aug 12, 2015 at 16:45

Stack Exchange Network

current community

your communities

more stack exchange communities

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

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

Filter first then join or join first then filter?

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