User J.D.

43 votes

7 answers

9k views

What's a good use case for SELECT * in production code?

asked Nov 21, 2019 at 21:33

36 votes

2 answers

5k views

If a CTE is defined in a query and is never used, does it make a sound?

asked Jun 14, 2018 at 20:25

36 votes

2 answers

8k views

Is it generally faster to select into a temp table than selecting into an actual table?

asked Jan 22, 2020 at 23:49

13 votes

1 answer

3k views

How to get the parameter values of a stored procedure that's in the middle of execution?

asked Nov 18, 2019 at 15:59

12 votes

1 answer

3k views

Why is casting a DATE field to VARCHAR datatype non-deterministic and is there a way to make it deterministic?

asked Dec 11, 2019 at 15:47

12 votes

1 answer

780 views

Is there a reliable way to check if a trigger being fired was the result of a DML action from another specific trigger?

asked Jun 2, 2023 at 16:32

10 votes

1 answer

1k views

Is it possible to re-use a query plan from the plan cache from one database in another database?

asked Nov 1, 2019 at 18:08

9 votes

1 answer

2k views

Is the NOLOCK hint completely safe to use on a table that's guaranteed not to change?

asked Nov 4, 2019 at 18:15

9 votes

5 answers

6k views

Linked Server connection started failing with "Cannot generate SSPI context ... SQL Server Network Interfaces: The logon attempt failed" error?

asked Mar 17, 2021 at 12:50

8 votes

1 answer

389 views

If a stored procedure is altered while it's currently being used in a cursor, does the cursor continue using the old query before it was altered?

asked Nov 14, 2019 at 18:59

8 votes

1 answer

692 views

Is there a reliable way to determine how long it took the optimizer to generate a query plan?

asked Nov 4, 2019 at 0:02

8 votes

2 answers

14k views

The disappearing act of the "Invalid length parameter passed to the LEFT or SUBSTRING function" error

asked Sep 19, 2018 at 20:10

8 votes

3 answers

7k views

Does restarting the SQL Services (on the machine) clear the server cache (for things like query plans and statistics)?

asked May 6, 2019 at 16:27

7 votes

1 answer

10k views

What is the purpose of "Schema Owner"?

asked Sep 10, 2019 at 21:18

7 votes

1 answer

2k views

How to GRANT permission to execute stored procedure?

asked Jul 11, 2018 at 15:40

7 votes

2 answers

10k views

MS SQL Server: Do multiple queries in a batch ever execute in parallel and if so what happens when the second query is dependent on the first?

asked Aug 22, 2018 at 14:26

7 votes

2 answers

10k views

SQL Server 2017 Enterprise vs Standard - Online Indexing and Online Schema Change

asked Apr 27, 2018 at 16:25

7 votes

3 answers

880 views

What events still occur within a transaction that gets rolled back?

asked Nov 15, 2019 at 19:21

7 votes

1 answer

357 views

Is there a way to determine what kind of data is sitting in the Redo Queue for an AlwaysOn AG Secondary Replica?

asked Nov 19, 2019 at 15:17

7 votes

1 answer

4k views

Is there an easy way to SELECT FROM another session's temp table?

asked Dec 10, 2019 at 20:40

7 votes

4 answers

1k views

Is my queue table implementation race condition safe?

asked Mar 13 at 21:46

7 votes

2 answers

1k views

Is the Query Store's Overall Resource Consumption report telling me my database is doing terribly or are the numbers just whacked?

asked Feb 3, 2022 at 19:15

6 votes

1 answer

2k views

Are the results of the STRING_SPLIT() function returned in a deterministic order?

asked Jan 8, 2021 at 2:27

6 votes

1 answer

1k views

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

asked Jun 25, 2020 at 17:09

6 votes

1 answer

112 views

At what point is a (disk-based) table removed from memory after data is read from it?

asked Dec 18, 2019 at 17:52

6 votes

1 answer

651 views

Is there any difference with specifying the primary key as an include column in a nonclustered index?

asked Feb 1, 2020 at 22:41

6 votes

1 answer

3k views

If sp_ExecuteSql creates a new session, how come I can access a local temp table created (prior to it's execution) outside of the dynamic SQL?

asked Dec 9, 2019 at 16:17

5 votes

2 answers

544 views

Does the command SET STATISTICS...ON turn statistics information on for all queries running throughout the server or just the current connection?

asked Dec 10, 2019 at 15:53

5 votes

1 answer

7k views

Why can't I create a new schema with the owner set to dbo?

asked Nov 1, 2019 at 14:16

5 votes

1 answer

2k views

Okay to run sp_refreshview against all views on a regular basis?

asked Jul 25, 2018 at 16:41

Stack Exchange Network

156 Questions

What's a good use case for SELECT * in production code?

If a CTE is defined in a query and is never used, does it make a sound?

Is it generally faster to select into a temp table than selecting into an actual table?

How to get the parameter values of a stored procedure that's in the middle of execution?

Why is casting a DATE field to VARCHAR datatype non-deterministic and is there a way to make it deterministic?

Is there a reliable way to check if a trigger being fired was the result of a DML action from another specific trigger?

Is it possible to re-use a query plan from the plan cache from one database in another database?

Is the NOLOCK hint completely safe to use on a table that's guaranteed not to change?

Linked Server connection started failing with "Cannot generate SSPI context ... SQL Server Network Interfaces: The logon attempt failed" error?

If a stored procedure is altered while it's currently being used in a cursor, does the cursor continue using the old query before it was altered?

Is there a reliable way to determine how long it took the optimizer to generate a query plan?

The disappearing act of the "Invalid length parameter passed to the LEFT or SUBSTRING function" error

Does restarting the SQL Services (on the machine) clear the server cache (for things like query plans and statistics)?

What is the purpose of "Schema Owner"?

How to GRANT permission to execute stored procedure?

MS SQL Server: Do multiple queries in a batch ever execute in parallel and if so what happens when the second query is dependent on the first?

SQL Server 2017 Enterprise vs Standard - Online Indexing and Online Schema Change

What events still occur within a transaction that gets rolled back?

Is there a way to determine what kind of data is sitting in the Redo Queue for an AlwaysOn AG Secondary Replica?

Is there an easy way to SELECT FROM another session's temp table?

Is my queue table implementation race condition safe?

Is the Query Store's Overall Resource Consumption report telling me my database is doing terribly or are the numbers just whacked?

Are the results of the STRING_SPLIT() function returned in a deterministic order?

Can adding a columnstore index to a table affect read performance of a query that uses a rowstore index on the same table?

At what point is a (disk-based) table removed from memory after data is read from it?

Is there any difference with specifying the primary key as an include column in a nonclustered index?

If sp_ExecuteSql creates a new session, how come I can access a local temp table created (prior to it's execution) outside of the dynamic SQL?

Does the command SET STATISTICS...ON turn statistics information on for all queries running throughout the server or just the current connection?

Why can't I create a new schema with the owner set to dbo?

Okay to run sp_refreshview against all views on a regular basis?