Click here to monitor SSC
A service from Red Gate
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in  | Join  | Help
Authors  >  Greg Larsen

Greg Larsen Greg Larsen
Greg started working in the computer industry in 1982. In 1985, he got his first DBA job, and since then he has held five different DBA jobs and managed a number of different database management systems. Currently works as a DBA for Department of Health in Washington State managing SQL Server databases, and also does part-time consulting. He has published numerous articles in SQL Server Magazine, and many online web sites dedicated to SQL Server. He also is a SQL Server MVP and holds a number of Microsoft Certification. Greg can be reached at gregalarsen@msn.com.
SQL Server Database Growth and Autogrowth Settings
by Greg Larsen | 23 November 2011 |  18 comments |
It's easy to create a database nowadays with point-'n-click, but if you've left your database's autogrowth settings at their default, you may hit problems in the future. Why? What do I do about it? Read on! Read more...
Which of Your Stored Procedures are Using the Most Resources?
by Greg Larsen | 11 January 2011 |  14 comments |
Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their... Read more...
Parameter Sniffing
by Greg Larsen | 20 September 2010 |  2 comments |
If a SQL query has parameters, SQL Server creates an execution plan tailored to them to improve performance, via a process called 'parameter sniffing'. This plan is stored and reused since it is usually the best execution plan. Just occasionally, it isn't, and you... Read more...
Creative Solutions by Using a Number Table
by Greg Larsen | 03 August 2010 |  12 comments |
One irritating thing for the occasional SQL Server Developer is that the experts assume that you are familiar with the use of number tables when they write about techniques. We therefore asked Greg Larsen to spell it out in a way that would help the beginner and... Read more...
Deploying Reports using the ReportingServices2005 Class and the RS Utility
by Greg Larsen | 16 April 2010 |
Much of the routine administration of Reporting Services (SSRS), such as the routine deployment of RDL reports, can be automated by using the Reporting Service 2005 class library and web services. To make things easier, Microsoft supply the RS utility to run Visual... Read more...
Custom reports in Management Studio, using the Performance Dashboard
by Greg Larsen | 18 July 2007 |  28 comments |
If you are using SSMS and SQL Server 2005 sp2 You've probably tried out the database reports that are available in the Performance Dashboard, and decided how useful they are, but did you know that you can create your own dashboard reports? Read more...
Choosing between CLR and T-SQL stored procedures: a simple benchmark
by Greg Larsen | 24 April 2007 |  2 comments |
In this short article, Greg Larsen performance benchmarks alternative CLR-based and T-SQL stored procedure solutions for retrieving operating system file information. He also assesses other factors to be considered when choosing the correct implementation for your... Read more...
Building my First SQL Server 2005 CLR
by Greg Larsen | 06 December 2006 |  16 comments |
Greg Larsen provides a step-by-step tour of the hurdles he had to jump in building and deploying his first serious CLR stored procedure. Read more...
Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk


Privacy policy | Terms and conditions | ©2005-2012 Red Gate Software
About | Site map | Become an author | Newsletters | Contact us