How can we help you today? How can we help you today?
Keith_Walton

Activity overview

Latest activity by Keith_Walton

How do I get a blocked index name for a deadlock?
Example: Object blocked: Index/(Key) 72057618332712960 Process detail: dbid: 8, object id: 72057618332712960, index id: (010086470766) Both of these numbers are too long to be the object_id (INT) i...
2 followers 3 comments 0 votes
Stored procedures over 32K always show as changed
Whenever one of my procedures gets really large and exceeds 32K, it always shows up as being different when I try to synchronize it between databases. In the past, I worked around this by splitting...
2 followers 4 comments 0 votes
Does SQL Backup use tempdb?
I'm splitting my backup into two files for performance - each file goes to a different raid 0 drive array. I then copy these files onto my report server and restore them using two different drives....
1 follower 1 comment 0 votes
Split backup - one thread for each file?
Right now I'm using THREADCOUNT = 2 to speed up my backup and restore. If I split the backup into two files instead of using THREADCOUNT (these options are mutually exclusive), will it automaticall...
1 follower 1 comment 0 votes