About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert Login (Experts Only)
About Us  ·  FAQ  ·  Tell Friends About Us  ·  Link To Us  ·  Free Encyclopedia  ·  Disclaimer  ·  Tech Support   
  You are here:  AllExperts > Computing/Technology > Databases > MS SQL Server

Expert Profile: David Vaughn

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

Ask a Question       View Past Answers       View Ratings            
Average Ratings
Prestige Points: 2030
Knowledge   9.91   Best of the best
Clarity of Response   9.86   Best of the best
Timeliness   9.80   Best of the best
Politeness   9.95   Best of the best
Number Of Questions
(in Past 24 Hours)
0
Max Questions to be Asked
(in 24 Hour period)
5
Total Questions
(since joining AllExperts)
247
Recent Reviews from Users
KnowlClarityTimePolitenessDate
10101010/25/08
1010101009/30/08
1010101009/26/08
1010101009/25/08
1010101009/21/08
User Comments
Thank you alot You are the best :)
(eyad on 10/25/08)
Thank you sir
(Hemalatha on 09/30/08)
Dave, thanks for the insight on SCOPE_IDENTITY(). I will give it a try. Also, I know that other statement returns the same value all the time whic
(Heather on 09/26/08)
WOW i'm impressed! Worked like a charm! Thanks a lot, saved my day! Regards -Sveinung
(Sveinung on 09/25/08)
View All Comments
Ask a Question       View Past Answers       View Ratings            

Recent Answers from David Vaughn
2008-10-21  SQL 2000 query to get time difference between adjacent rows I need some questions answered first. 1-Your question text says "SQL 2005", but your subject says "SQL 2000". Which is it? 2-Is there NO other column(s) in the table by which the rows can be uniquely...
2008-10-20  Retrieve the parameters form a stored procedure For SQL 2000, try this (substituting your proc name for "XXXXXXXXXXX", and removing the "and ssp.name=N'dbo'" or changing "dbo" to the appropriate owner as necessary) SELECT param.name AS [Name]...
2008-10-07  And what if ... If you don't have appropriate permissions to the other database (either directly or via Active Directory groups, local groups, and/or Database Roles), then you cannot see the data there. That is the purpose...
2008-10-07  About Dates What do you mean by "Week"? Do you mean "Week of the month"? If so, what are you using to determine that. Also, since 9/28 is the 5th week (of September) 10/1 is the 1st week (of October) and those...
2008-10-02  Select one record every ten, hundred records If I understand correctly, you have a table that gets a new row inserted each minute. And for a give time period (say, 1 day), you want to select a sample of those 1440 rows (24 hours * 60 minutes) such...
More Answers for "MS SQL Server"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.