Louis Davidson

Louis has been in the IT industry for over 20 years as a corporate database developer and data architect. Currently he is the Data Architect for CBN in Virginia Beach. Louis has been a Microsoft MVP since 2004, and is an active volunteer for the PASS locally and globally. He is the author of a series of SQL Server Database Design books, most recently Pro SQL Server Relational Database Design and Implementation.

Follow Louis on

and 11 October 2012
and 11 October 2012

Tune Your Indexing Strategy with SQL Server DMVs

SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you create must ensure that the workload reads the data quickly with a minimum of I/O. As well as a sound knowledge of the way that relational databases work, it helps to be familiar with the Dynamic Management Objects that are there to assist with your indexing strategy.… Read more
and 17 August 2010
and 17 August 2010

DMVs for Query Plan Metadata

Before you can tackle any performance issues with a working database, you need to know which queries to work on first: The ones that are taking the most time in total, and which are the most expensive in terms of cache, CPU and disk. Although SQL Server Management Studio can help, it isn't long before you need an armoury of DMVs to provide you the statistics to find the culprits. … Read more
and 14 June 2010
and 14 June 2010

Performance Tuning with SQL Server Dynamic Management Views

This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own requirements.… Read more
16 October 2007
16 October 2007

Do I Ask Too Much of My Beloved RDBMS?

0
0
OK Simple-Talkers I have a interesting situation driving be nuttier than squirrel poo. I have the following 2 steps in a scheduled SQL job I use to backup logs.  If for some reason a log file does not exist it will throw the error 22049.  I trap for it and want it to proceed with the … Read more
0
0
23 September 2007
23 September 2007

PASS Day 3: Hello Muddah, Hello Faddah

0
0
Here it is, the last day of PASS 2007 and I find myself in a melancholy that comes with the last day of summer camps from many years past.  We are all far past the stage of being exhausted, yet not ready to seek out the family come to collect me and take that long … Read more
0
0
19 September 2007
19 September 2007

It’s PASS 2007 Arg!

0
0
Volunteer meetings, PASS business, PASS SIG Quizbowl, Welcome Reception, SQL Server Central Party and the subsequent after party and after-after party, General Session and four breakout sessions and man is my brain tired! It’s all just a part of being at PASS and being involved in PASS.  Sure it is a great deal of work, but … Read more
0
0