User Magier

12 votes

Accepted

Can sp_executesql be configured / used by default?

answered Dec 18, 2015 at 10:36

8 votes

Does index rebuild time depend on the fragmentation level?

answered Apr 25, 2016 at 14:59

8 votes

Accepted

Creating SQL Server Performance Baseline Monitoring

answered Nov 25, 2016 at 10:21

7 votes

Accepted

Property class Length Annotation PersistedResolvableAnnotation

answered Feb 23, 2016 at 15:31

4 votes

Accepted

SQL Server remote connection to 2nd instance impossible

answered Sep 7, 2015 at 16:18

4 votes

Accepted

Merge performs always additional INSERTS

answered Nov 22, 2016 at 14:59

3 votes

Execute xp_cmdshell as a non-windows user

answered Aug 9, 2016 at 13:07

3 votes

Referencing system views in SSDT?

answered Feb 10, 2017 at 7:50

3 votes

SQL queries to only show most recent purchase records for individual food items

answered Dec 3, 2015 at 12:37

2 votes

Calculating daily growth using previous row value in new column - SQL Server

answered Aug 26, 2015 at 20:02

2 votes

Accepted

Sql Script takes much longer than estimated

answered Aug 12, 2015 at 6:53

2 votes

Issues with Indexed Views in SQL Server 2008r2 on a table with persisted columns and with low DML activity

answered Aug 19, 2015 at 16:00

2 votes

Accepted

Sql Server log: is 'Backup|Log was backed up' the same as 'BackupDatabase: Log files done'?

answered Apr 13, 2016 at 12:32

2 votes

Accepted

Innovative solution required - Remotely create stored procedure

answered Apr 25, 2016 at 18:08

2 votes

Accepted

Howto create useful dacpac versioning along with SSDT deployment?

answered Aug 29, 2016 at 11:18

2 votes

Why does SSRS not update a report's description?

answered Sep 14, 2016 at 15:20

2 votes

Accepted

In a school database, do I need to have repeating data when a student can also be a teacher?

answered Nov 23, 2016 at 1:15

2 votes

How to export an image column to files in SQL Server?

answered Jun 20, 2016 at 11:52

2 votes

T-SQL Count in single select

answered Aug 3, 2016 at 13:33

1 vote

Accepted

How should I log changes to an object when the datatype of the changed property can vary?

answered Aug 9, 2016 at 12:46

1 vote

Accepted

What options are there for security on shared data sources for SSRS?

answered May 18, 2017 at 18:08

1 vote

Is it possible to redirect queries to another server?

answered Apr 13, 2018 at 22:24

1 vote

Cleanup Error Messages in SQL Server ERRORLOG

answered Apr 13, 2018 at 22:42

1 vote

SSDT publish multiple referenced database projects to new instance

answered Apr 13, 2018 at 23:06

1 vote

Accepted

Howto transfer tracefile into a trace table without loosing the sort order?

answered May 31, 2016 at 15:02

1 vote

Move extended property comments to create table comment

answered Apr 14, 2016 at 9:16

1 vote

Accepted

Problem executing multiple procedures

answered Dec 22, 2015 at 16:04

1 vote

Query to calculate database growth

answered Aug 26, 2015 at 19:40

1 vote

Force Sql server to use index seek in merge join

answered Nov 24, 2015 at 14:10

0 votes

Output parameter in stored procedure

answered Dec 16, 2015 at 11:26

Stack Exchange Network

40 Answers

Can sp_executesql be configured / used by default?

Does index rebuild time depend on the fragmentation level?

Creating SQL Server Performance Baseline Monitoring

Property class Length Annotation PersistedResolvableAnnotation

SQL Server remote connection to 2nd instance impossible

Merge performs always additional INSERTS

Execute xp_cmdshell as a non-windows user

Referencing system views in SSDT?

SQL queries to only show most recent purchase records for individual food items

Calculating daily growth using previous row value in new column - SQL Server

Sql Script takes much longer than estimated

Issues with Indexed Views in SQL Server 2008r2 on a table with persisted columns and with low DML activity

Sql Server log: is 'Backup|Log was backed up' the same as 'BackupDatabase: Log files done'?

Innovative solution required - Remotely create stored procedure

Howto create useful dacpac versioning along with SSDT deployment?

Why does SSRS not update a report's description?

In a school database, do I need to have repeating data when a student can also be a teacher?

How to export an image column to files in SQL Server?

T-SQL Count in single select

How should I log changes to an object when the datatype of the changed property can vary?

What options are there for security on shared data sources for SSRS?

Is it possible to redirect queries to another server?

Cleanup Error Messages in SQL Server ERRORLOG

SSDT publish multiple referenced database projects to new instance

Howto transfer tracefile into a trace table without loosing the sort order?

Move extended property comments to create table comment

Problem executing multiple procedures

Query to calculate database growth

Force Sql server to use index seek in merge join

Output parameter in stored procedure