I got a copy of this book back in September of 2009 because I wanted to know more about the hardware configuration of production database servers. Specifically, I wanted to know about best practices and recommendations in the areas of storage, memory and CPU. While at the store, I read chapter 2 “Storage and System … Read more
Bill Karwin style and choice of arranging the material within the chapters made it an easy read. It includes good and accurate examples the reader can test in almost any database system. Overall, the book will save the inexperience from many failures and embarrassment. I purchased this book hoping to find something new. Unfortunately, I … Read more
I recommend this book to all database administrators who still have not jumped in and executed their first PowerShell command. I know of several DBAs who for one excuse reason or another, keep postponing their exposure to the next generation command line shell. This volume makes a good first PowerShell book for DBAs. It covers … Read more
PROBLEM: You manage many MS SQL servers and need an easy way to review jobs that have failed. SOLUTION: I will show you one way to accomplish this task with results displaying on the screen or to a file. To make your life easier, I recommend you download & install PowerGUI from Quest Software. This … Read more
PROBLEM: I need an easy way to script out all the tables from a database in MS SQL 2000 and above. SOLUTION: Like anything in programming, there are a thousand ways to skin a cat. Here, I’ll show you the simplest way I found to meet this request. Go ahead and open a new session … Read more
I purchased my copy back in 1999 and it is one of my favorite SQL books. I find the information very accurate and relevant to the MS SQL versions (6.5 & 7.0) printed on the cover of the book. I think it was the best SQL book for many years. Since 1999, many books for … Read more
By far, this is the best overall MS SQL 2000 server book written until today. Most topics are covered from basic to advance level. This book is a must have for anyone who is looking to get a well rounded knowledge of what’s possible with MS SQL 2000. The chapters I liked the most are: … Read more
Una de las razones por la cual decidí escribir este artículo es porque alguien me sugirió utilizar el procedimiento de sistema SP_DEPENDS para encontrar las tablas que se usan en un SP (procedimiento almacenado). Al iniciar mis pruebas con el SP_DEPENDS utilizando la base de datos AdventureWorks todo parecía andar muy bien, pero cuando lo … Read more
Finding tables referenced in a stored procedure Recently, I was asked for an easy way to list the tables used in a stored procedure. I looked in my list of previously used scripts and found one that did not fully satisfy the requirements of the task. So I decided to come up with a solution … Read more
USE: These queries will display the top 25 most expensive stored procedures that are still in the cache.