Chris Aldrich
  • Member for 10 years, 10 months
  • Last seen more than 2 years ago
8 answers
75 votes
60k views
51 bookmarks
MAXDOP setting algorithm for SQL Server
9 answers
57 votes
13k views
21 bookmarks
Should you design the database before the application code is written?
6 answers
41 votes
11k views
14 bookmarks
Why does adding a TOP 1 dramatically worsen performance?
2 answers
12 votes
6k views
4 bookmarks
Placing Transaction Log on Separate Volume [solid state]?
5 answers
39 votes
117k views
22 bookmarks
When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?
18 answers
239 votes
117k views
110 bookmarks
How do you document your databases?
4 answers
7 votes
13k views
2 bookmarks
Unable to create restore plan due to break in LSN chain
2 answers
40 votes
21k views
25 bookmarks
What does a DBA have to know about SSAS?
6 answers
86 votes
12k views
32 bookmarks
Do stored procedures prevent SQL injection?
5 answers
51 votes
161k views
30 bookmarks
Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling
1 answers
12 votes
3k views
1 bookmarks
Why is removing the Identity property on a column not supported
2 answers
470 votes
246k views
308 bookmarks
What's the difference between a temp table and table variable in SQL Server?
4 answers
116 votes
20k views
35 bookmarks
Why are numbers tables "invaluable"?
2 answers
25 votes
58k views
7 bookmarks
Max number of user connections
2 answers
26 votes
70k views
16 bookmarks
How to partition an existing non-partitioned table
5 answers
141 votes
120k views
46 bookmarks
Guid vs INT - Which is better as a primary key?
3 answers
7 votes
9k views
2 bookmarks
SQL Server service shutdown due to 'bad?' SSL cert
1 answers
27 votes
29k views
9 bookmarks
When to use sort_in_tempdb when rebuilding indexes?
5 answers
18 votes
72k views
5 bookmarks
What is the fastest way to export a table to a text file
3 answers
30 votes
31k views
12 bookmarks
Stored procedures vs. inline SQL
2 answers
1 votes
13k views
1 bookmarks
How to Start DB2 10.5 HADR on the Standby Database
3 answers
5 votes
26k views
3 bookmarks
Can I stop a SQL database backup after it has already started?
1 answers
2 votes
1k views
2 bookmarks
DB2: Is it good to create the LONG table space to use 32 KB data page
2 answers
18 votes
5k views
2 bookmarks
Why is table variable forcing an index scan while temp table uses seek and bookmark lookup?
1 answers
23 votes
52k views
18 bookmarks
Upgrade SQL Server 2000 database to 2008 R2 and enable new features
2 answers
13 votes
9k views
7 bookmarks
Deadlock error isn't returning the deadlock SQL
2 answers
98 votes
234k views
55 bookmarks
Connect to SQL Server with Windows Authentication in a different domain
1 answers
13 votes
16k views
3 bookmarks
Access view based on table in another database without account in that other database
2 answers
2 votes
3k views
1 bookmarks
DB2 cookbook by Graeme Birchall?
7 answers
18 votes
3k views
7 bookmarks
Group daily schedule into [Start date; End date] intervals with the list of week days
1
2 3 4 5
9