This is the second post in which I am walking through a query that I use to analyze indexes. For some reason the grammar on the title of the first post was a bit jacked so I’ve corrected it for this post and the all following ones. Here’s a summary of what I’ve added to … Continue reading Analyze This – Analyze Your Indexes – Part 2
Shrinks have no idea what’s wrong with you when you walk in the door. In you come you try to describe what appears to be the problem and then they start asking about your mother. But you don’t want to talk about your mother, most likely you’d like some relief to whatever the concern is … Continue reading Analyze This – Your Indexes Analysis – Part 1
This is completely off topic and has everything to do with Outlook and my calendar. While traveling something happened to my contact and calendar synchronization and I ended up with 4 or 5 birthdays for all of my contacts. Some were on a single day and others started and ended 2-hours early – most likely … Continue reading Populating Birthday From Contacts
Happy Pi Day!
Often when I am load testing an application with a client I want to check to see if there is any index contention in a database. To do this, I use the DMF sys.dm_db_index_operational_stats. For a good rundown on this DMF, I recommend reading Louis Davidson’s blog entry on sys.dm_db_index_operational_stats. Instead of repeating that content, … Continue reading Monitoring Index Contention With DMFs
This won’t be the most exciting post. But hey, it’s Monday! What’s exciting about that? Maybe someone will bring in donuts. Or maybe I should since I am still on my couch and not headed to the office yet. Anyways, every now and then I need a big table to test some code out on … Continue reading Big Tempdb Table
Continuing this thread, I was tagged by Rob Boek to post about my first computer and and favorite games. The first computer that I had access to was a Commodore 64 that my dad purchased when I was probably about 10 years old. That thing was awesome! We had it all -- the monitor, keyboard, … Continue reading My First Computer and Favorite Old Games (OT)
A co-worker came over and asked how to round up to the nearest 1,000. He tried to use ROUND but found that it always split between going up or going down depending on the value and the report he was working on always had to round up. Almost before he finished asking, actually before he … Continue reading Rounding Up to the Nearest 1,000
Last week I was tagged by Jason Massie to write up a few things I wish I knew as a Junior DBA. The tagging was started by Mike Walsh a couple weeks back and has been making the rounds. Without much ado, here are some things that I’ve learned through the years that I’d wished … Continue reading Things you Know Now…
I keep hearing this story and similar variations… ”On a dark and stormy night, I developed a SQL Server Integration Services (SSIS) package. It worked wonderfully on my desktop development environment. All the files were properly accessed and the data was processed in a magnificent matter.” ”But suddenly I deployed the SSIS package to production … Continue reading Troubleshooting Permission Issues with CREDENITIALS
Strate SQL 