John G Hohengarten's user avatar
John G Hohengarten's user avatar
John G Hohengarten's user avatar
John G Hohengarten
  • Member for 7 years, 5 months
  • Last seen this week
476 votes
2 answers
250k views

What's the difference between a temp table and table variable in SQL Server?

  • 78.6k
457 votes
5 answers
880k views

List all columns for a specified table

373 votes
4 answers
697k views

How do I list all schemas in PostgreSQL?

  • 4,815
293 votes
4 answers
330k views

Why Does the Transaction Log Keep Growing or Run Out of Space?

  • 17.9k
254 votes
7 answers
128k views

When should I use a unique constraint instead of a unique index?

  • 11.8k
241 votes
18 answers
118k views

How do you document your databases?

  • 961
199 votes
5 answers
146k views

When should a primary key be declared non-clustered?

194 votes
5 answers
499k views

Granting access to all tables for a user

  • 2,045
186 votes
7 answers
201k views

What's the difference between a CTE and a Temp Table?

  • 8,299
171 votes
19 answers
56k views

Should developers be able to query production databases?

  • 2,109
160 votes
13 answers
304k views

How can I move a database from one server to another?

  • 1,761
129 votes
15 answers
289k views

PostgreSQL not running on Mac

  • 1,951
122 votes
4 answers
96k views

Difference between Sharding And Replication on MongoDB

  • 1,341
118 votes
10 answers
322k views

mysql: Show GRANTs for all users

  • 10.6k
102 votes
8 answers
20k views

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

  • 1,245
101 votes
2 answers
242k views

Connect to SQL Server with Windows Authentication in a different domain

  • 1,135
99 votes
6 answers
71k views

Retrieving n rows per group

  • 73.8k
90 votes
2 answers
285k views

How to get the current date without the time part

  • 1,013
89 votes
4 answers
17k views

Authoritative source that <> and != are identical in performance in SQL Server

  • 4,155
87 votes
3 answers
426k views

How do I insert a row which contains a foreign key?

  • 4,815
80 votes
4 answers
197k views

How to identify which query is filling up the tempdb transaction log?

  • 1,023
75 votes
8 answers
62k views

MAXDOP setting algorithm for SQL Server

  • 67.6k
68 votes
4 answers
57k views

Index Seek vs Index Scan

  • 3,152
65 votes
8 answers
40k views

What is the difference between a "record" and a "row" in SQL Server?

  • 10.5k
63 votes
1 answer
22k views

What event information can I get by default from SQL Server?

61 votes
6 answers
217k views

Why use WHERE 1 or WHERE 1=1?

  • 1,921
60 votes
5 answers
41k views

Why does ALTER COLUMN to NOT NULL cause massive log file growth?

58 votes
4 answers
60k views

SQL Server: How to track progress of CREATE INDEX command?

51 votes
3 answers
84k views

How do I get back some deleted records?

50 votes
2 answers
55k views

Does a re-index update statistics?

  • 615
1
2 3 4 5
7