MS SQL Server/Expert Profile

Ask A Question


Performance tuning; T-SQL syntax;

Experience in the area

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


Truman State University

This expert accepts donations:      

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
Tejus08/23/16101010Your solution worked perfectly! Thank you for .....
AJ12/07/15101010Thank you for not clicking the stock .....
Katt07/10/15101010Thank You that worked perfectly!!!!
rony05/03/15101010I have tried it on ms access .....

Recent Answers from David Vaughn

2016-08-24 SQL On line Training:

I'm really sorry, but I have exactly no experience with any training sites. Perhaps someone else in this category might?    Offhand if you used SSIS for "years", I think you'd do fine with almost any decent

2015-06-30 Finding Business Days between dates in SQL Server 2008:

I might be missing something, but I'm not seeing a problem (except when the last hire date is a Sunday, which probably shouldn't happen).    I'm assuming by "eligible days" you mean weekdays. I distilled

2015-06-18 Cursor or ?? to do table record counts:

Despite all the hate cursors get, they are (IMO) perfectly fine for small iterations such as this. Yes, there are non-cursor ways to do it, but often people jump through some fairly amazing hoops just

2015-02-09 changing rows into columns:

Apologies for the delay. I think I have an idea, but pivot queries are (to my way of thinking) such unintuitive things that I always have to "play around" with them.     Can you do me a favor and respond

2015-01-15 Connecting to oracle database from SQL application:

I'm afraid I don't know what this means:      we are connecting from SQL (using .net application)       Please provide more information.      Also, I know almost nothing about Oracle, so I might be of


Ask A Question

MS SQL Server

All Answers

Answers by Expert:

Ask Experts


©2017 All rights reserved.

[an error occurred while processing this directive]