Hikari's user avatar
Hikari's user avatar
Hikari's user avatar
Hikari
  • Member for 8 years
  • Last seen more than a week ago
16 votes
5 answers
76k views

Add autoincrement to existing PK

13 votes
2 answers
44k views

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

12 votes
3 answers
56k views

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

9 votes
3 answers
69k views

Execute stored procedure remotely using linked server

8 votes
1 answer
41k views

Filter first then join or join first then filter?

7 votes
1 answer
651 views

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

5 votes
3 answers
18k views

Force SQL Server to parse "DDMMYYYY"

4 votes
1 answer
11k views

Create Linked Server using Active Directory account

4 votes
2 answers
8k views

Grant Admin to an Active Directory account in SQL Server

4 votes
1 answer
8k views

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

4 votes
1 answer
7k views

Verify if user has read access to a table

3 votes
3 answers
5k views

Index optimization for table that is truncated every day

3 votes
1 answer
6k views

Find out beforehand how many records a query has

3 votes
1 answer
98 views

Tool for quickly backup and restore a table

3 votes
1 answer
1k views

Set a filegroup to readonly

3 votes
2 answers
1k views

Unable to delete secondary data file

2 votes
1 answer
928 views

Hold exclusive lock on a whole DB

2 votes
1 answer
4k views

Order by values with most incidence

2 votes
5 answers
16k views

List all tables from all user databases

2 votes
2 answers
2k views

Are nonclustered indexes used when joining tables?

2 votes
1 answer
2k views

Unable to set user/group as principal on a proxy

2 votes
1 answer
15k views

Windows Authentication fails with "Cannot generate SSPI context"

2 votes
3 answers
521 views

Discover available HD storage from inside SQL Server

1 vote
5 answers
12k views

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

1 vote
4 answers
1k views

SSMS not coloring tables, columns and variables

1 vote
1 answer
718 views

Best solution to keep a big table synched in 2 DB

1 vote
2 answers
413 views

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

1 vote
1 answer
353 views

User on SQLAgentOperatorRole unable to edit jobs

1 vote
1 answer
2k views

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

1 vote
1 answer
121 views

Sum currencies excluding duplicatied records