Database Administrators
Meta user
Network profile
3,417
reputation
1
13
28

J.D.

Apparently, this user prefers to keep an air of mystery about them.

13
answers
94
questions
~66k
people reached
  • Member for 1 year, 9 months
  • 577 profile views
  • Last seen 2 days ago

Communities (9)

Top network posts

Top tags (127)

Score 16
Posts 102
Posts % 95
Score 11
Posts 50
Score 4
Posts 14
Score 4
Posts 11
Score 4
Posts 8
Score 0
Posts 22
View all tags →

Top posts (107) All Questions Answers | Votes Newest

33 What's a good use case for SELECT * in production code? Nov 21 '19
32 If a CTE is defined in a query and is never used, does it make a sound? Jun 14 '18
31 Is it generally faster to select into a temp table than selecting into an actual table? Jan 22
12 Why is casting a DATE field to VARCHAR datatype non-deterministic and is there a way to make it deterministic? Dec 11 '19
12 How to get the parameter values of a stored procedure that's in the middle of execution? Nov 18 '19
9 Is it possible to re-use a query plan from the plan cache from one database in another database? Nov 1 '19
8 Does restarting the SQL Services (on the machine) clear the server cache (for things like query plans and statistics)? May 6 '19
7 Is there a reliable way to determine how long it took the optimizer to generate a query plan? Nov 4 '19
7 What events still occur within a transaction that gets rolled back? Nov 15 '19
7 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? Nov 14 '19
View all questions and answers →

Badges (42)

Gold

1

Rarest

Silver

13

Rarest

Bronze

28

Rarest

View all badges →