User carlo.borreo

16 votes

1 answer

56k views

Give permission to select from system tables

asked Feb 12, 2013 at 17:59

16 votes

2 answers

12k views

Why does dropping foreign keys take long?

asked Apr 12, 2017 at 10:28

12 votes

2 answers

39k views

Scripting a maintenance plan

asked Aug 18, 2014 at 10:18

8 votes

2 answers

976 views

SQL Server: can dynamic data masking be safe when providing a database backup?

asked Aug 17, 2018 at 10:39

6 votes

1 answer

44k views

SQL Server : keep track of all connections/disconnections

asked Dec 5, 2013 at 7:58

6 votes

2 answers

12k views

Log all errors in queries

asked Feb 19, 2013 at 11:41

5 votes

1 answer

2k views

Log all than queries taking more than X seconds

asked Feb 26, 2013 at 9:51

5 votes

2 answers

45k views

Reducing database size to restore to SQL Server Express

asked Aug 28, 2014 at 15:34

5 votes

1 answer

317 views

Tracking errors from prepared SQL statements

asked May 13, 2019 at 15:08

4 votes

1 answer

153 views

Error statement is not logged, only *password---- with many dashes

asked May 2, 2013 at 8:26

4 votes

3 answers

3k views

Identify applications with locks

asked Feb 5, 2013 at 9:22

4 votes

1 answer

2k views

SQL Server 2016: Adding temporal tables to existing application

asked Sep 29, 2017 at 6:56

3 votes

1 answer

4k views

UPDATE, subquery with SELECT TOP

asked Nov 23, 2017 at 17:09

3 votes

2 answers

1k views

Indexed views on double linked server

asked Oct 14, 2014 at 9:56

3 votes

1 answer

528 views

SQL Server: efficient query with (double) linked servers

asked Oct 28, 2014 at 9:05

3 votes

1 answer

515 views

Can I rely on the estimate execution plan to recommend indexes?

asked Jan 20, 2017 at 15:25

2 votes

3 answers

8k views

SQL Server: insert french characters without using them in a query

asked Mar 20, 2017 at 15:40

2 votes

2 answers

266 views

SQL performances of selecting recently modified records Solr

asked Apr 4, 2017 at 8:53

2 votes

2 answers

2k views

Reuse a complex non-deterministic expression in SELECT and WHERE clauses

asked Dec 5, 2014 at 17:25

2 votes

4 answers

4k views

Effective dates, complex requirements

asked Nov 23, 2015 at 11:44

2 votes

1 answer

804 views

Bulk edit tables and columns descriptions

asked Dec 1, 2015 at 14:51

2 votes

3 answers

3k views

Investigating errors from strange query

asked Sep 15, 2017 at 13:32

2 votes

1 answer

1k views

Logging errors with extended events excluding some users

asked Nov 8, 2013 at 14:08

2 votes

1 answer

3k views

Restoring a database, changing recovery model

asked Aug 18, 2014 at 10:08

2 votes

1 answer

2k views

Remote linked servers

asked Oct 1, 2014 at 10:37

2 votes

1 answer

709 views

Foreign key, key split in two tables

asked Aug 20, 2014 at 14:48

2 votes

1 answer

248 views

Catching slow queries with prepared statements

asked Jul 5, 2019 at 12:54

1 vote

3 answers

1k views

Prepared statements with many parameters is slow

asked Jul 5, 2019 at 14:52

1 vote

1 answer

283 views

Transfer data from the cloud to a local database [closed]

asked Apr 27, 2018 at 9:56

1 vote

1 answer

2k views

Optimizing single-row DELETEs from a table with many FOREIGN KEY references

asked Jun 13, 2019 at 10:16

Stack Exchange Network

46 Questions

Give permission to select from system tables

Why does dropping foreign keys take long?

Scripting a maintenance plan

SQL Server: can dynamic data masking be safe when providing a database backup?

SQL Server : keep track of all connections/disconnections

Log all errors in queries

Log all than queries taking more than X seconds

Reducing database size to restore to SQL Server Express

Tracking errors from prepared SQL statements

Error statement is not logged, only *password---- with many dashes

Identify applications with locks

SQL Server 2016: Adding temporal tables to existing application

UPDATE, subquery with SELECT TOP

Indexed views on double linked server

SQL Server: efficient query with (double) linked servers

Can I rely on the estimate execution plan to recommend indexes?

SQL Server: insert french characters without using them in a query

SQL performances of selecting recently modified records Solr

Reuse a complex non-deterministic expression in SELECT and WHERE clauses

Effective dates, complex requirements

Bulk edit tables and columns descriptions

Investigating errors from strange query

Logging errors with extended events excluding some users

Restoring a database, changing recovery model

Remote linked servers

Foreign key, key split in two tables

Catching slow queries with prepared statements

Prepared statements with many parameters is slow

Transfer data from the cloud to a local database [closed]

Optimizing single-row DELETEs from a table with many FOREIGN KEY references