User Magier

31 votes

2 answers

25k views

Why is :r SQLCMD command marked as wrong in Post Deployment Script?

asked Sep 7, 2015 at 7:58

16 votes

2 answers

7k views

What is the sense and benefit of using SqlCommand.Prepare()?

asked Feb 18, 2016 at 11:12

11 votes

2 answers

15k views

Good reasons to use SELECT... WITH XLOCK?

asked Jan 21, 2016 at 15:37

11 votes

2 answers

4k views

Can sp_executesql be configured / used by default?

asked Dec 17, 2015 at 17:06

11 votes

1 answer

14k views

How to prevent SSDT publishing from dropping columns

asked May 25, 2016 at 11:42

10 votes

1 answer

616 views

Where does an execution plan come from?

asked Dec 21, 2015 at 14:03

9 votes

1 answer

2k views

Is the WHERE-JOIN-ORDER-(SELECT) rule for index column order wrong?

asked May 25, 2016 at 9:46

8 votes

6 answers

12k views

Does index rebuild time depend on the fragmentation level?

asked Nov 24, 2015 at 10:49

8 votes

6 answers

7k views

Creating SQL Server Performance Baseline Monitoring

asked Aug 17, 2015 at 7:51

7 votes

4 answers

3k views

Manually create index fragmentation

asked Dec 22, 2015 at 14:19

7 votes

3 answers

3k views

Property class Length Annotation PersistedResolvableAnnotation

asked Feb 23, 2016 at 15:20

6 votes

1 answer

739 views

How to GRANT object permission to a user defined server role?

asked May 17, 2017 at 12:22

5 votes

1 answer

696 views

Should Full Text Filter Daemon Service be a cluster resource?

asked Mar 20, 2017 at 10:04

5 votes

1 answer

3k views

Howto avoid textdata of trace gets truncated?

asked Jun 8, 2016 at 12:18

5 votes

1 answer

991 views

Will a nonclustered index with a unique column always address all queries filtering that column first?

asked May 13, 2016 at 13:07

5 votes

1 answer

13k views

How to grant connect and read/write permission to ALL databases?

asked Mar 1, 2016 at 11:25

5 votes

1 answer

642 views

Monitor table permission changes

asked Jan 25, 2016 at 9:12

5 votes

3 answers

4k views

Who is the person using a SQL login?

asked Jan 27, 2016 at 14:28

5 votes

2 answers

559 views

Catch event of auto_shrink in SQL Server Log? [duplicate]

asked Aug 11, 2015 at 10:22

5 votes

1 answer

7k views

SSDT project with working linked server references gets SQL71562 warning

asked Sep 1, 2015 at 11:11

5 votes

2 answers

1k views

Howto Identify Clustered Index Candidates

asked Oct 6, 2015 at 15:43

5 votes

2 answers

126 views

Does a covering nonclustered index help to answer Select * queries?

asked Oct 29, 2015 at 11:21

5 votes

1 answer

1k views

Influence of index rebuild tasks in tempdb on the transaction log?

asked Nov 11, 2015 at 15:43

4 votes

2 answers

662 views

How to handle lock information?

asked Oct 20, 2015 at 10:28

4 votes

1 answer

2k views

Do I have a memory issue?

asked Oct 2, 2015 at 7:33

4 votes

2 answers

2k views

Why are transactions running as distributed (DTCXact)?

asked Jan 28, 2016 at 9:39

4 votes

1 answer

206 views

Performance measuring on complex query

asked Jan 13, 2016 at 18:11

4 votes

1 answer

907 views

Multi-command SQLCMD mode script

asked Dec 7, 2015 at 18:39

4 votes

1 answer

17k views

MERGE with IDENTITY_INSERT ON does not work if Identity is not the primary key

asked Dec 8, 2015 at 15:46

4 votes

1 answer

3k views

Howto create useful dacpac versioning along with SSDT deployment?

asked Mar 2, 2016 at 13:08

Stack Exchange Network

123 Questions

Why is :r SQLCMD command marked as wrong in Post Deployment Script?

What is the sense and benefit of using SqlCommand.Prepare()?

Good reasons to use SELECT... WITH XLOCK?

Can sp_executesql be configured / used by default?

How to prevent SSDT publishing from dropping columns

Where does an execution plan come from?

Is the WHERE-JOIN-ORDER-(SELECT) rule for index column order wrong?

Does index rebuild time depend on the fragmentation level?

Creating SQL Server Performance Baseline Monitoring

Manually create index fragmentation

Property class Length Annotation PersistedResolvableAnnotation

How to GRANT object permission to a user defined server role?

Should Full Text Filter Daemon Service be a cluster resource?

Howto avoid textdata of trace gets truncated?

Will a nonclustered index with a unique column always address all queries filtering that column first?

How to grant connect and read/write permission to ALL databases?

Monitor table permission changes

Who is the person using a SQL login?

Catch event of auto_shrink in SQL Server Log? [duplicate]

SSDT project with working linked server references gets SQL71562 warning

Howto Identify Clustered Index Candidates

Does a covering nonclustered index help to answer Select * queries?

Influence of index rebuild tasks in tempdb on the transaction log?

How to handle lock information?

Do I have a memory issue?

Why are transactions running as distributed (DTCXact)?

Performance measuring on complex query

Multi-command SQLCMD mode script

MERGE with IDENTITY_INSERT ON does not work if Identity is not the primary key

Howto create useful dacpac versioning along with SSDT deployment?