User Elaskanator

18 votes

1 answer

9k views

SQL Server - Adding non-nullable column to existing table - SSDT Publishing

asked Jun 1, 2018 at 20:07

6 votes

1 answer

2k views

SQL Server - TRY/CATCH does not work in certain cases

asked Jul 3, 2019 at 19:51

4 votes

2 answers

648 views

SQL Server - Inconsistent, hidden machine precision error when truncating result of LOG to integer

asked Jun 13, 2018 at 14:37

4 votes

4 answers

443 views

Leveraging an index on another column with the same ordering guarantee

asked Nov 20, 2019 at 20:30

3 votes

2 answers

2k views

SSMS - How to do case-insensitive searches in Object Explorer

asked Jan 28, 2019 at 16:10

2 votes

0 answers

425 views

SQL Server - How to track down error thrown in SSDT publish preview?

asked May 18, 2018 at 17:09

2 votes

4 answers

1k views

SQL Server - Any way to validate insert statements for mismatching column names?

asked Jun 27, 2018 at 15:42

1 vote

1 answer

889 views

SQL Server - Standard Deviation in a Windowed Query

asked Jun 13, 2018 at 16:41

1 vote

1 answer

625 views

SQL Server and TFS - How to rename stored procedures

asked Jun 18, 2018 at 15:51

1 vote

1 answer

107 views

SSDT Publish failing with an error without even running any statements

asked Jul 18, 2019 at 18:27

1 vote

1 answer

9k views

SQL Server - MERGE duplicate SOURCE rows validation is only evaluated on UPDATE and DELETE clauses

asked Aug 22, 2019 at 15:03

1 vote

1 answer

49 views

SQL Server - Migration script testing - Refresh table definition manually without dropping it

asked Sep 26, 2019 at 16:02

1 vote

1 answer

776 views

Safeguard against infinite looping in case of missing FETCH NEXT

asked Nov 5, 2019 at 16:19

1 vote

2 answers

2k views

SQL Server switched to use pagefile exclusively instead of RAM and effectively froze the world

asked Jul 18, 2018 at 14:51

1 vote

2 answers

665 views

Impossible to log errors after dooming a transaction within an INSERT-EXEC statement

asked Oct 23, 2018 at 21:02

0 votes

1 answer

179 views

SQL Server Agent appears to be treating sysprocesses (and dm_exec_sessions) differently

asked May 16, 2018 at 17:15

0 votes

1 answer

377 views

How to find the erroneous code failing the SSDT publish?

asked Aug 6, 2018 at 19:58

0 votes

1 answer

1k views

SSDT - Deprecated table trigger preventing publish

asked Aug 24, 2018 at 22:33

0 votes

1 answer

2k views

SQL Server Profiler Exception tracing - Error procedure and line number omitted

asked Jun 18, 2018 at 18:49

0 votes

0 answers

3k views

SQL Server - What is the RAISERROR substitution parameter for boolean/bit type?

asked Jun 25, 2018 at 21:25

0 votes

2 answers

671 views

SQL Server Profiler - Disable auto scroll by default

asked Jul 11, 2018 at 18:59

0 votes

0 answers

543 views

Service broker stuck infinitely looping using outdated activation stored procedure

asked May 24, 2018 at 15:20

0 votes

1 answer

427 views

SQL Server - Defining and populating a new temp table column fails only once

asked Feb 10, 2020 at 15:23

Stack Exchange Network

23 Questions

SQL Server - Adding non-nullable column to existing table - SSDT Publishing

SQL Server - TRY/CATCH does not work in certain cases

SQL Server - Inconsistent, hidden machine precision error when truncating result of LOG to integer

Leveraging an index on another column with the same ordering guarantee

SSMS - How to do case-insensitive searches in Object Explorer

SQL Server - How to track down error thrown in SSDT publish preview?

SQL Server - Any way to validate insert statements for mismatching column names?

SQL Server - Standard Deviation in a Windowed Query

SQL Server and TFS - How to rename stored procedures

SSDT Publish failing with an error without even running any statements

SQL Server - MERGE duplicate SOURCE rows validation is only evaluated on UPDATE and DELETE clauses

SQL Server - Migration script testing - Refresh table definition manually without dropping it

Safeguard against infinite looping in case of missing FETCH NEXT

SQL Server switched to use pagefile exclusively instead of RAM and effectively froze the world

Impossible to log errors after dooming a transaction within an INSERT-EXEC statement

SQL Server Agent appears to be treating sysprocesses (and dm_exec_sessions) differently

How to find the erroneous code failing the SSDT publish?

SSDT - Deprecated table trigger preventing publish

SQL Server Profiler Exception tracing - Error procedure and line number omitted

SQL Server - What is the RAISERROR substitution parameter for boolean/bit type?

SQL Server Profiler - Disable auto scroll by default

Service broker stuck infinitely looping using outdated activation stored procedure

SQL Server - Defining and populating a new temp table column fails only once