Database Administrators
J.D.
Profile Activity
Stats
17,844
reputation
239k
reached
756
answers
149
questions
About

Hated databases in college, love them now...

Communities (11)

Top network posts

3
gold badges
31
silver badges
66
bronze badges
View all badges

Top tags (433)

Score 519
Posts 494
Posts % 55
Score 136
Posts 113
Score 126
Posts 107
Score 92
Posts 88
Score 71
Posts 140
Score 70
Posts 53
View all tags →

Top posts (905)

All Questions Answers
Votes Newest
40 What's a good use case for SELECT * in production code? Nov 21 '19
35 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
18 Recommended way: "SELECT *" vs "SELECT COLUMN_LIST" from same table, multiple times Jul 8
14 Indexed view not used in actual execution plan? Dec 16 '20
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
11 Size Requirement of SQL Database Feb 24
11 How to dispose of large tables with the least impact to log shipping? Dec 31 '20
10 Is it possible to re-use a query plan from the plan cache from one database in another database? Nov 1 '19
View all questions and answers →

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.