user avatar
user avatar
user avatar
Chris Aldrich
  • Member for 11 years, 1 month
  • Last seen more than 2 years ago
1 answer
5 votes
636 views
2 bookmarks
ENABLE_BROKER vs NORECOVERY
2 answers
4 votes
7k views
4 bookmarks
OLAP or OLATP - How to determine
1 answer
13 votes
17k views
3 bookmarks
Access view based on table in another database without account in that other database
2 answers
3 votes
12k views
1 bookmarks
Cross-database view - Not able to access database under the current security context
3 answers
5 votes
27k views
3 bookmarks
Can I stop a SQL database backup after it has already started?
4 answers
17 votes
2k views
4 bookmarks
How To Strip Hebrew Accent Marks
2 answers
6 votes
11k views
5 bookmarks
Speed up an aggregate query on an 11 million row table
2 answers
21 votes
74k views
5 bookmarks
The certificate chain was issued by an authority that is not trusted
2 answers
20 votes
5k views
2 bookmarks
DEFAULT CONSTRAINT, worth it?
1 answer
8 votes
6k views
3 bookmarks
Quickest way to NULL or wipe a column
1 answer
3 votes
3k views
1 bookmarks
Deny dbo schema permission
5 answers
4 votes
965 views
3 bookmarks
What is the best practice for selecting from two tables with multiple relations?
1 answer
13 votes
3k views
6 bookmarks
Difference between "and" and "&"
1 answer
4 votes
964 views
2 bookmarks
Why are Op Stats all 0's and yet Usage Stats show 29 seeks
18 answers
241 votes
117k views
110 bookmarks
How do you document your databases?
2 answers
2 votes
7k views
2 bookmarks
How can I check if my log is truncated?
2 answers
31 votes
193k views
10 bookmarks
How to use COALESCE with multiple rows and without preceding comma?
18 answers
102 votes
37k views
34 bookmarks
Is adding the ‘tbl’ prefix to table names really a problem?
1 answer
4 votes
1k views
2 bookmarks
Advantages/Disadvantages of using a multicolumn clustering index
1 answer
28 votes
30k views
9 bookmarks
When to use sort_in_tempdb when rebuilding indexes?
2 answers
31 votes
70k views
5 bookmarks
Is it useful to have the SQL Server instance root directory on a separate drive?
2 answers
99 votes
238k views
55 bookmarks
Connect to SQL Server with Windows Authentication in a different domain
0 answers
1 vote
276 views
1 bookmarks
Accuracy of sys.dm_exec_procedure stats
1 answer
5 votes
47k views
2 bookmarks
SQL Server error log entry : Error: 17806, Severity: 20, State: 14
2 answers
5 votes
720 views
4 bookmarks
SQL Server - What backup/restore strategy should I use to accomplish the following?
2 answers
3 votes
1k views
1 bookmarks
GHOST_CLEANUP Lots of IO and CPU Usage
1 answer
13 votes
22k views
6 bookmarks
Restoring a SQL Server 2012 database in high availability
1 answer
1 vote
481 views
1 bookmarks
Automate: importing xls to table (without microsoft excel)
2 answers
7 votes
11k views
4 bookmarks
moving large number of tables to different filegroups
2 answers
13 votes
10k views
7 bookmarks
Deadlock error isn't returning the deadlock SQL
1
2 3 4 5
9