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

Performance difference for COALESCE versus ISNULL?

3 votes
1 answer
6k views

How to estimate database size needed?

241 votes
18 answers
118k views

How do you document your databases?

152 votes
6 answers
132k views

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

102 votes
18 answers
37k views

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

139 votes
8 answers
65k views

Why shouldn't we allow NULLs?

16 votes
1 answer
20k views

Why does UPDLOCK cause SELECTs to hang (lock)?

2 votes
1 answer
17k views

Check if relation is in BCNF

475 votes
2 answers
249k views

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

7 votes
2 answers
11k views

moving large number of tables to different filegroups

75 votes
8 answers
62k views

MAXDOP setting algorithm for SQL Server

57 votes
9 answers
13k views

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

41 votes
6 answers
12k views

Why does adding a TOP 1 dramatically worsen performance?

12 votes
2 answers
6k views

Placing Transaction Log on Separate Volume [solid state]?

39 votes
5 answers
118k views

When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?

7 votes
4 answers
13k views

Unable to create restore plan due to break in LSN chain

40 votes
2 answers
22k views

What does a DBA have to know about SSAS?

86 votes
6 answers
12k views

Do stored procedures prevent SQL injection?

51 votes
5 answers
164k views

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

12 votes
1 answer
3k views

Why is removing the Identity property on a column not supported

116 votes
4 answers
20k views

Why are numbers tables "invaluable"?

25 votes
2 answers
60k views

Max number of user connections

26 votes
2 answers
71k views

How to partition an existing non-partitioned table

7 votes
3 answers
9k views

SQL Server service shutdown due to 'bad?' SSL cert

29 votes
1 answer
30k views

When to use sort_in_tempdb when rebuilding indexes?

18 votes
5 answers
73k views

What is the fastest way to export a table to a text file

30 votes
3 answers
32k views

Stored procedures vs. inline SQL

1 vote
2 answers
14k views

How to Start DB2 10.5 HADR on the Standby Database

5 votes
3 answers
27k views

Can I stop a SQL database backup after it has already started?

2 votes
1 answer
1k views

DB2: Is it good to create the LONG table space to use 32 KB data page

1
2 3 4 5
9