Database Administrators
Profile Activity
Meta user
Network profile
9,123
reputation
2
23
50

J.D.

Hated databases in college, love them now...

310
answers
144
questions
~124k
people reached
  • Long Island, NY
  • jondeagro@yahoo.com
  • Member for 2 years, 9 months
  • 859 profile views
  • Last seen 28 mins ago

Communities (11)

Top network posts

Top tags (311)

Score 196
Posts 274
Posts % 60
Score 52
Posts 22
Score 45
Posts 49
Score 40
Posts 108
Score 32
Posts 36
Score 31
Posts 45
View all tags →

Top posts (454)

All Questions Answers
Votes Newest
37 What's a good use case for SELECT * in production code? Nov 21 '19
34 Is it generally faster to select into a temp table than selecting into an actual table? Jan 22 '20
32 If a CTE is defined in a query and is never used, does it make a sound? Jun 14 '18
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
12 Indexed view not used in actual execution plan? Dec 16 '20
10 How to dispose of large tables with the least impact to log shipping? Dec 31 '20
9 Is it possible to re-use a query plan from the plan cache from one database in another database? Nov 1 '19
8 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
8 Does restarting the SQL Services (on the machine) clear the server cache (for things like query plans and statistics)? May 6 '19
View all questions and answers →

Badges (75)

Gold

2

Rarest

Silver

23

Rarest

Bronze

50

Rarest

View all badges →