Skip navigation
Menu

Bill McEvoy

Bill McEvoy is Master Chef/DBA for the Cooking with SQL Web site. He's been a DBA since SQL Server 4.2, and he specializes in batch processing and performance tuning.

[email protected]

Bill’s Recent activity

T-SQL 101, Lesson 3
T-SQL 101, Lesson 3
Apr 28, 2008
Most database administrators and SQL Server administrators know that they can use T-SQL's SELECT statement to retrieve the data stored in Microsoft SQL Server databases. What database administrators and SQL Server...
2 Stored Procedures to Tune Your Indexes
Mar 27, 2008
If you’ve been a DBA for a while, you likely have encountered developers who are extremely proficient in front-end application design but have a rather limited understanding of the database technology they’re using...
T-SQL 101, Lesson 2
T-SQL 101, Lesson 2
Mar 27, 2008
Writing T-SQL queries in SQL Server 2005's Query Editor or SQL Server 2000's Query Analyzer can help you accomplish tasks quickly. However, some database administrators and SQL Server administrators might shy...
T-SQL 101, Lesson 1
T-SQL 101, Lesson 1
Feb 27, 2008
The data stored in a Microsoft SQL Server database is useless without the ability to retrieve and view it. T-SQL's SELECT statement is what you use to get data out of the database and onto your screen. Writing T...
Stored Procedure Documents Scheduled Jobs in SQL Server
Jan 24, 2008
Microsoft SQL Server Management Studio (SSMS) is great at quickly creating jobs and schedules. However, it's not so great at generating a master list of those jobs. Using Microsoft SQL Server Management Studio to...
A Quick and Easy Way to View Errorlog Files
Mar 21, 2007
table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...
Retrieve Triggers from the SQL Command Prompt
Feb 22, 2007
table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...
Prove That the Database Isn't to Blame
Sep 20, 2006
table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; ...
Load More