user avatar
user avatar
user avatar
Chris Aldrich
  • Member for 11 years, 3 months
  • Last seen more than 2 years ago
475 votes
2 answers
248k views

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

  • 78.1k
241 votes
18 answers
118k views

How do you document your databases?

  • 961
170 votes
19 answers
55k views

Should developers be able to query production databases?

  • 2,099
149 votes
6 answers
130k views

Guid vs INT - Which is better as a primary key?

  • 3,133
138 votes
8 answers
65k views

Why shouldn't we allow NULLs?

116 votes
4 answers
20k views

Why are numbers tables "invaluable"?

  • 2,314
102 votes
18 answers
37k views

Is adding the ‘tbl’ prefix to table names really a problem?

  • 7,104
100 votes
2 answers
239k views

Connect to SQL Server with Windows Authentication in a different domain

  • 1,125
90 votes
2 answers
284k views

How to get the current date without the time part

  • 1,013
86 votes
6 answers
12k views

Do stored procedures prevent SQL injection?

  • 1,483
76 votes
8 answers
61k views

MAXDOP setting algorithm for SQL Server

  • 67.2k
73 votes
10 answers
23k views

Why do people recommend not using the name "Id" for an identity column?

  • 8,269
71 votes
6 answers
43k views

What are the differences between NoSQL and a traditional RDBMS?

  • 2,248
68 votes
4 answers
57k views

Index Seek vs Index Scan

  • 3,152
66 votes
3 answers
80k views

What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?

65 votes
5 answers
252k views

Write differences between varchar and nvarchar

  • 923
61 votes
6 answers
60k views

Date range rolling sum using window functions

  • 70.9k
58 votes
6 answers
75k views

What are the main causes of deadlocks and can they be prevented?

  • 4,382
58 votes
3 answers
50k views

Performance difference for COALESCE versus ISNULL?

  • 6,243
57 votes
9 answers
13k views

Should you design the database before the application code is written?

55 votes
6 answers
114k views

After moving database (backup, restore), I have to re-add user

  • 735
51 votes
5 answers
163k views

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

  • 673
48 votes
4 answers
36k views

Clustering vs. transactional replication vs. availability groups

  • 8,653
47 votes
8 answers
48k views

SQL Server Agent Jobs and Availability Groups

  • 2,747
46 votes
12 answers
7k views

How could DBAs be more 'programmer friendly'?

  • 37.5k
45 votes
1 answer
37k views

Scalability limitations of PostgreSQL and MySQL

  • 739
45 votes
1 answer
18k views

Commonly Used Acronyms by Database Administrators

41 votes
6 answers
12k views

Why does adding a TOP 1 dramatically worsen performance?

41 votes
2 answers
20k views

In SQL Server 2016, what is the difference between Always Encrypted and Transparent Data Encryption?

40 votes
2 answers
22k views

What does a DBA have to know about SSAS?

  • 2,302
1
2 3 4 5
9