MS SQL Server/Expert Profile


Ask A Question

Expertise

Performance tuning; T-SQL syntax;

Experience in the area

Over 25 years of IT experience, the last 10 as a SQL Server developer/DBA.

Education/Credentials

Truman State University


This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
UserDateKCPComments
Richard03/22/12101010Excellent ideas
bob10/19/11101010Excellent! Works perfectly. I was trying something .....
Florence07/25/11101010 
P06/26/11101010 
stwd05/30/11101010 

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

 

Ask A Question

MS SQL Server

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2012 About.com, a part of The New York Times Company. All rights reserved.