Richard Waymire

Richard
Waymire

Richard Waymire is a consultant and trainer, as well as a mentor with SolidQ. Richard is also a contributing editor to SQL Server Pro.

Articles
Choosing Log Shipping or Replication
Richard Waymire answers a reader's question about using log shipping or replication to keep a backup server ready.
Controlling Tempdb Size
Richard Waymire answers a reader’s question about controlling tempdb database growth.
Using Sysxlogins to Retrieve Objects
Richard Waymire answers a reader’s question about using system tables to retrieve login names.
Archiving Outdated Data
Richard Waymire answers a reader’s question about archiving outdated database records automatically.
Connecting to SQL Server Through Query Analyzer
Richard Waymire answers a reader’s question about problems using Query Analyzer to log in to SQL Server.
Failing to Access Virtual Server 1
Richard Waymire answers a reader's question about problems accessing Virtual Server.
Explaining MDAC and TDS Compatibility
Richard Waymire answers a reader’s question about MDAC's adjusting its TDS stream to the server's level.
Eliminating a Database-in-Use Error Message During a Reload 3
Richard Waymire answers a reader's question about an error message saying the database is in use.
Preventing a Gap in Auto-Increment Numbers
Richard Waymire answers a reader’s question about triggering an uninterrupted series of numbers.
Answers from Microsoft - 25 Jul 2001 3
Richard Waymire answers readers’ questions about estimating replication time, changing database names during a restore, and more.
Answers from Microsoft - 20 Jun 2001 2
Richard Waymire answers readers’ questions about installing the MSDTC Resource, calling a DoEvents in VBScript, securing tables, and more.
Answers from Microsoft - 23 May 2001 2
Richard Waymire answers readers’ questions about mapping a logical drive, reinstalling a clustered SQL Server 2000 Enterprise Edition, securing tables, and more.
Answers from Microsoft - 26 Apr 2001 1
Richard Waymire tells readers how to append extra characters to a fixed-character column, how to troubleshoot fluctuations in backup tape speed, and more.
Answers from Microsoft - 21 Mar 2001
Microsoft’s Richard Waymire explains security with dynamic T-SQL, triggers on multiple tables, and much more.
Answers from Microsoft - 22 Feb 2001
Richard Waymire answers questions about security with dynamic T-SQL, executing local temporary tables, and more.
Upcoming Conferences

Register now to get the best rate available!

From the Blogs
Save money red computer keyboard key
Jul 30, 2014
blog

When More Expensive Processors Actually Cost Less

Smart organizations are always looking for ways to cut costs when it comes to licensing SQL Server. Here are two ideas, or options, to save money....More
Health check note on computer keyboard
Jul 28, 2014
Sponsored

Grasp the Business Value of a Complete SQL Server Health Check

A comprehensive SQL Server health check will provide you with a better understanding of your complex database environment, and delivers answers you need....More
Baby duck swimming alone
Jul 15, 2014
blog

The Marginalization of SQL Server Standard Edition 6

Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×