MS SQL Server/Expert Profile

Average Ratings

• Knowledgeability 9.90
• Clarity of Response 9.91
• Politeness 9.96
• Response Time(hr) 31.8
• Response Time(hr, last 90 days) 2.8

• Number of Questions Today 0
• Max Questions to be Asked in a Day 5
• Total Questions (since joining AllExperts) 435
• Volunteer Since 2007-06-11
• Prestige Points 3530

Recent Reviews from Users

Read More Comments

Recent Answers from David Vaughn

2012-03-22 SQL Server Agent:

Sounds good. If you want/need assistance with the whole "iteratively check for file X" thing, let me know.    Another thought, in case you can't change the flat file creation process: You MIGHT be able

2012-03-22 SQL Server Agent:

SQL Mail (not DB Mail) had some procs by which you could -- supposedly -- process incoming emails, but SQL expects them to be in the format of a SELECT query. I've never used them and I don't know anyone

2012-03-15 Bulk Copy:

Given that it's only once a week (usually), and assuming that the table isn't TOO big, your bulk export/import idea is probably best. It's for sure the simplest.     Is bandwidth between CO and local an

2012-03-08 Bulk Copy:

There are several questions/factors to be answered & considered before a solution can be recommended:    1) How many of those 3 million rows are updated every week? How many new rows added? It's possible

2012-01-11 Can't open Sql server 2005:

Are the SQL Services actually running?     Do I understand that SQL Server services and SSMS are both on the Windows XP computer in question?    I would try running the services as an actual account (yours