Hikari's user avatar
Hikari's user avatar
Hikari's user avatar
Hikari
  • Member for 9 years, 5 months
  • Last seen more than 1 year ago
16 votes
5 answers
80k views

Add autoincrement to existing PK

14 votes
2 answers
59k views

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

13 votes
1 answer
53k views

Filter first then join or join first then filter?

12 votes
3 answers
61k views

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

9 votes
3 answers
76k views

Execute stored procedure remotely using linked server

8 votes
1 answer
894 views

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

5 votes
1 answer
8k views

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

5 votes
3 answers
21k views

Force SQL Server to parse "DDMMYYYY"

4 votes
2 answers
10k views

Grant Admin to an Active Directory account in SQL Server

4 votes
1 answer
8k views

Verify if user has read access to a table

4 votes
1 answer
13k views

Create Linked Server using Active Directory account

3 votes
2 answers
1k views

Unable to delete secondary data file

3 votes
3 answers
5k views

Index optimization for table that is truncated every day

3 votes
1 answer
7k views

Find out beforehand how many records a query has

3 votes
1 answer
107 views

Tool for quickly backup and restore a table

3 votes
1 answer
2k views

Set a filegroup to readonly

2 votes
1 answer
1k views

Hold exclusive lock on a whole DB

2 votes
1 answer
5k views

Order by values with most incidence

2 votes
5 answers
17k 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
19k views

Windows Authentication fails with "Cannot generate SSPI context"

2 votes
3 answers
772 views

Discover available HD storage from inside SQL Server

2 votes
4 answers
2k views

SSMS not coloring tables, columns and variables

2 votes
1 answer
413 views

Is it secure to store connection password on Pentaho Spoon?

1 vote
5 answers
15k views

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

1 vote
1 answer
805 views

Best solution to keep a big table synched in 2 DB

1 vote
2 answers
458 views

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

1 vote
2 answers
3k views

Fact table Primary Key: Surrogate Key or multi-column Natural Key?

1 vote
1 answer
1k views

User on SQLAgentOperatorRole unable to edit jobs