Archives: December 2010
Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the transaction log should be sized and maintained, I run into many databases that have a high number of virtual log files inside the transaction log file.
Even though I have… Read more
Time for the third week of blogging about the things that I’m doing to study for the MCM exam. Last week wasn’t too spectacular – with the holidays and all I was pretty lazy on the studying. The formatting issues did get fixed, so if you see… Read more
My friend Malathi (Mala) Mahadevan has chaired the Louisville PASS Chapter for the past couple years, and will be heading up their second SQLSaturday in January 2011. She’s started a blog at http://beyondrelational.com/blogs/diligentdba/default.aspx that I wanted to share. Getting started and finding your voice takes time, hope you’ll follow along… Read more
I’ve been thinking about the upcoming 24HOP event planned for March 15 and 16 which will showcase 24 women speakers. Karen Lopez (post | twitter), Jenn Stirrup (post | twitter), and Jen McCown (post | twitter Read more
In order to use the 16GB, and get VMs to run more smoothly, I need 64 bit Windows 7. I…
There is one thing that have been bothering me for quite some time. I thought I would blog about it. (And make some enemies in the process :-))
The thing that bothers me is the working of the MVP Program or the lack of it. I have noticed at least… Read more
Once upon a time a group of twelve bloggers agreed to each pick a post (or posts) they found interesting from the previous year, blog about them, comment, and call attention to them. I was tapped to summarize things, and here we go.
On the twelfth day of Christmas Stuart… Read more
Hi people, following a script that deletes all tables in a database. Enjoy.
SET NOCOUNT ON;
DECLARE @Tabela TABLE
( Seq INT,
DECLARE @Loop INT, @Qt INT;
-- While there ForeignKey exclude objects that are not referenced recursively
WHILE (SELECT COUNT(*) FROM… Read more
I’m not really planning on getting the MCM. Perhaps I’ll change my mind, but it’s not the time for me to do it. I’m not consulting, and not planning on doing it anytime soon. If I studied enough to pass the lab, likely my skills would atrophy without some… Read more
In this article, I thought of explaining different types and levels of index pages. but while start preparing for that, I realise , newbies need to understand concepts on Index architecture before moving on to see what is there inside index pages.
So, before going see internals of Clustered and NonClustered index pages, lets quickly recap some… Read more
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to automate many of the traditional daily (or more frequent) checklists*. Although PBM is useable out-of-box there are several key features missing:
- Unable to capture results of policy evaluations…
Most of us are aware of tracing queries using SQL profiler. But an effective way of performing tracing is using a server side trace.
Whats special about server side trace?
1) Server Side trace uses much less resources than SQL Profiler.
2) Server side trace runs within the server which…
Red Gate Software has released a new, free tool for database administrators and developers called SQL Script Manager. It includes 25 scripts written by many well-known DBAs, such as Ola Hallengren, Louis Davidson, Glenn Berry, Tim Ford, and many more, that can help you to automate common troubleshooting, diagnostic,… Read more
Speakers and bloggers alike crave feedback (good or bad) so I was excited to see my session evaluations from the 2010 PASS Summit arrive in my inbox this week. First I'll show the results, then I'll share some thoughts about them.
Eval forms had 6 questions with a… Read more
I’m inspired by Brent Ozar‘s and Andy Leonard‘s sharing of their PASS feedback scores and comments. But first, I’m going to tell you how I think my PASS session went: I give it a C+. 118 people attended… Read more
As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit. Feedback is a gift. I received a great many gifts this year and I’m extremely happy about all of them.
There are a set of questions with ratings, the… Read more
Imagine that you are writing a script that looks at data grouped by the minute. You notice that there are no rows for some minutes, and you’d like to display a value when that is the case, probably showing a count of zero.
In… Read more
There are times when I wonder why I get so few comments on this blog, however there are assumptions I have made which were confirmed to me recently again by those who wrote to me directly, or spoke with. Some told me that fewer comments are a good thing… Read more