User J. Mini

22 votes

2 answers

6k views

Why is COALESCE not a function?

asked Apr 28 at 12:12

8 votes

5 answers

4k views

Copying a table (and all of its data) from one server to another?

asked Nov 23, 2023 at 19:00

8 votes

6 answers

3k views

How can we prevent Agent Jobs running twice when the clocks change?

asked Oct 27 at 21:00

6 votes

1 answer

462 views

What does SQL Server's Error Log actually log?

asked May 17 at 23:15

4 votes

1 answer

127 views

Why does adding an empty columnstore index to my tables consistently make execution plans ignore bitmaps?

asked Jun 26 at 20:15

4 votes

2 answers

3k views

Are views logically redundant?

asked Feb 21 at 20:13

4 votes

1 answer

577 views

Does compressing indexes reduce the size of already compressed backups?

asked Oct 16 at 8:43

4 votes

2 answers

406 views

If LATERAL is optional for table-valued functions, then why does this query error without it?

asked Dec 1 at 15:30

3 votes

1 answer

176 views

Does rebuilding a clustered index offline require extra space for each non-clustered index?

asked Sep 21 at 15:08

3 votes

2 answers

470 views

Is there any benefit to declaring an index that contains a primary key as unique?

asked Sep 9 at 17:57

3 votes

1 answer

196 views

Should tiny dimension tables be considered for row or page compression on servers with ample CPU room?

asked Sep 13 at 16:23

3 votes

1 answer

794 views

What exact error messages do UMPPC.DLL and SCRIPTCONTROL.DLL cause SQL Server Agent when it fires SSIDB packages?

asked Apr 24 at 18:19

3 votes

1 answer

402 views

Is sys.dm_os_memory_clerks a good source to use when setting max server memory (MB)?

asked Jun 14 at 15:17

3 votes

3 answers

888 views

Given that CREATE PROCEDURE must be the first statement of its batch, what is the use of Temporary Stored Procedures?

asked Dec 27, 2023 at 21:38

3 votes

3 answers

269 views

How can I know how many tables my DELETE has changed?

asked Jan 27 at 17:37

2 votes

2 answers

229 views

How to measure the cost of enabling Query Store?

asked Jan 13 at 19:06

2 votes

1 answer

533 views

What are the advantages and disadvantages of inspecting the Plan Cache rather than the Query Store?

asked Jan 13 at 20:45

2 votes

1 answer

1k views

Is there any benefit to WITH RECOMPILE or OPTION (RECOMPILE) in a stored procedure that uses temp tables at every stage?

asked Dec 17, 2023 at 12:23

2 votes

2 answers

1k views

Does PERCENTILE_CONT still give terrible performance when calculating medians in 2022 versions of SQL Server?

asked Aug 13, 2023 at 12:12

2 votes

1 answer

353 views

How should MAXDOP be configured on stacked instances?

asked Jun 13 at 18:16

2 votes

2 answers

1k views

Why does the SERIALIZABLE transaction isolation level not guarantee point-in-time views of data?

asked May 3 at 22:44

2 votes

3 answers

660 views

Are unique filtered indexes considered an antipattern for enforcing constraints?

asked Jul 13 at 18:33

2 votes

1 answer

121 views

Does enabling backup compression in a Back Up Database Task enable checksums, no matter what setting you pick for them?

asked Jul 20 at 13:01

2 votes

4 answers

358 views

How does SMO make it easy to grab all code on a Microsoft SQL Server?

asked Aug 29 at 19:22

2 votes

1 answer

104 views

Is there any information in Query Store that can be used to find block leaders?

asked Nov 23 at 20:20

1 vote

2 answers

254 views

Do parallel SELECTs make a transaction?

asked Oct 17 at 15:51

1 vote

2 answers

73 views

Given that they require schema modification locks, why are sparse columns considered an alternative to EAV?

asked Oct 19 at 23:34

1 vote

2 answers

98 views

How can I do arithmetic in the ORDER BY clause with a column aliased in my SELECT clause?

asked Sep 8 at 20:29

1 vote

1 answer

102 views

Does Postgres have anything analogous to Microsoft SQL Server's Batch Mode?

asked Sep 23 at 21:53

1 vote

1 answer

103 views

Should unique filtered indexes include their filtering column?

asked Jul 31 at 7:37

Stack Exchange Network

102 Questions

Why is COALESCE not a function?

Copying a table (and all of its data) from one server to another?

How can we prevent Agent Jobs running twice when the clocks change?

What does SQL Server's Error Log actually log?

Why does adding an empty columnstore index to my tables consistently make execution plans ignore bitmaps?

Are views logically redundant?

Does compressing indexes reduce the size of already compressed backups?

If LATERAL is optional for table-valued functions, then why does this query error without it?

Does rebuilding a clustered index offline require extra space for each non-clustered index?

Is there any benefit to declaring an index that contains a primary key as unique?

Should tiny dimension tables be considered for row or page compression on servers with ample CPU room?

What exact error messages do UMPPC.DLL and SCRIPTCONTROL.DLL cause SQL Server Agent when it fires SSIDB packages?

Is sys.dm_os_memory_clerks a good source to use when setting max server memory (MB)?

Given that CREATE PROCEDURE must be the first statement of its batch, what is the use of Temporary Stored Procedures?

How can I know how many tables my DELETE has changed?

How to measure the cost of enabling Query Store?

What are the advantages and disadvantages of inspecting the Plan Cache rather than the Query Store?

Is there any benefit to WITH RECOMPILE or OPTION (RECOMPILE) in a stored procedure that uses temp tables at every stage?

Does PERCENTILE_CONT still give terrible performance when calculating medians in 2022 versions of SQL Server?

How should MAXDOP be configured on stacked instances?

Why does the SERIALIZABLE transaction isolation level not guarantee point-in-time views of data?

Are unique filtered indexes considered an antipattern for enforcing constraints?

Does enabling backup compression in a Back Up Database Task enable checksums, no matter what setting you pick for them?

How does SMO make it easy to grab all code on a Microsoft SQL Server?

Is there any information in Query Store that can be used to find block leaders?

Do parallel SELECTs make a transaction?

Given that they require schema modification locks, why are sparse columns considered an alternative to EAV?

How can I do arithmetic in the ORDER BY clause with a column aliased in my SELECT clause?

Does Postgres have anything analogous to Microsoft SQL Server's Batch Mode?

Should unique filtered indexes include their filtering column?