Chris Aldrich
  • Member for 10 years, 10 months
  • Last seen more than 2 years ago
2 answers
90 votes
283k views
24 bookmarks
How to get the current date without the time part
5 answers
65 votes
251k views
21 bookmarks
Write differences between varchar and nvarchar
2 answers
470 votes
246k views
308 bookmarks
What's the difference between a temp table and table variable in SQL Server?
2 answers
98 votes
234k views
55 bookmarks
Connect to SQL Server with Windows Authentication in a different domain
2 answers
31 votes
190k views
10 bookmarks
How to use COALESCE with multiple rows and without preceding comma?
5 answers
51 votes
161k views
30 bookmarks
Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling
8 answers
14 votes
126k views
7 bookmarks
How to write a query to find all tables in a db that have a specific column name
5 answers
141 votes
120k views
46 bookmarks
Guid vs INT - Which is better as a primary key?
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?
6 answers
54 votes
111k views
19 bookmarks
After moving database (backup, restore), I have to re-add user
3 answers
66 votes
78k views
20 bookmarks
What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?
1 answers
39 votes
76k views
18 bookmarks
SIMPLE or FULL recovery model for databases?
6 answers
57 votes
74k views
24 bookmarks
What are the main causes of deadlocks and can they be prevented?
2 answers
20 votes
72k views
5 bookmarks
The certificate chain was issued by an authority that is not trusted
5 answers
18 votes
72k views
5 bookmarks
What is the fastest way to export a table to a text file
2 answers
26 votes
70k views
16 bookmarks
How to partition an existing non-partitioned table
2 answers
30 votes
69k views
5 bookmarks
Is it useful to have the SQL Server instance root directory on a separate drive?
8 answers
137 votes
63k views
76 bookmarks
Why shouldn't we allow NULLs?
2 answers
17 votes
62k views
6 bookmarks
SQL Server 2012 Restore backup to new DB Name
8 answers
75 votes
60k views
51 bookmarks
MAXDOP setting algorithm for SQL Server
2 answers
25 votes
58k views
7 bookmarks
Max number of user connections
6 answers
60 votes
57k views
23 bookmarks
Date range rolling sum using window functions
4 answers
66 votes
57k views
41 bookmarks
Index Seek vs Index Scan
19 answers
167 votes
54k views
47 bookmarks
Should developers be able to query production databases?
1 answers
23 votes
52k views
18 bookmarks
Upgrade SQL Server 2000 database to 2008 R2 and enable new features
8 answers
35 votes
50k views
7 bookmarks
What is the difference between an INNER JOIN and an OUTER JOIN ?
5 answers
31 votes
48k views
12 bookmarks
Archiving of old data
3 answers
58 votes
48k views
10 bookmarks
Performance difference for COALESCE versus ISNULL?
1 answers
5 votes
46k views
2 bookmarks
SQL Server error log entry : Error: 17806, Severity: 20, State: 14
1
2 3 4 5
9