www.JohnTrumbul.com Pragmatic Programmer

Turn the key, hear the engine catch go to put it in drive and... shit Darn it golly gee a stall. This is NOT just for cars anymore. One of the biggest performance issue indicators I have ever used in practice to check for DB issues has been an IO Stall test metric. In days of old, you know when 16 bit gaming consoles made you the man if you had one, and Mortal Kombat was THE GAME to play.. (still is now by the way if anyone is on PSN and wants to take a beating ProphetDE come find me) I had n...
Continue reading...

Over the years I have been guilty so many times of writing a rollback script that rolls column additions to a table. Which is essentially a script that will drop the added columns. When i create a new column with a default value i ALWAYS use a constraint name which i created. In the event you inherit someone else database who does not (not mine of course) :) forgetting to drop the default value constraint (which is something only an inexperienced DBA would do NOT ME of course) :)

As luck woul...
Continue reading...

Hello All,

A 2 part post this month, i guess i finally removed head from arse and got around to posting updates. First a super useful query for IO stats of log and data files. Please note these are at file level. This may exist already and im sure there are better ways to do this, but since i have been going through a ton of logs and data files at work recently, i figured it was worth a post.

[code]
SELECT
DB_NAME(tblFileStat.database_id) AS databaseName ,
tblFileStat.file_id ,tblMasterFile.phy...
Continue reading...

Since I happen to be using this right now, I figure i would throw it up. Table not performing the way you would like? Perhaps the index is fragmented to high hell. Usinf this in combination with a Reorganize and Rebuild script should help a great deal.

SELECT ps.database_id, ps.OBJECT_ID,
ps.index_id, b.name,
ps.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps
INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID
AND ps.index_id = b.index...
Continue reading...

Hello All, for the thousandth time I apologize for the lack of updates. However this time I actually have good reason. The company I currently work for now PlayStudios - www.PlayStudios.com is launching our game soon. I believe July 17th is the release date to be exact. More info to follow (for real this time).

In other news I have again been nominated for the Red Gate Exceptional DBA award. I know people can sign up and nominate themselves and if I had done that I would not announce it. Sinc...
Continue reading...

Sorry for my delay. I know i promised to move all of my old blog posts over, I had fully intended to. Finally I have come to the conclusion that I will not. The reason for this is quite simple, I have a new position and would like to post all new coding examples based on SQL 2k8 R2 and SQL 2012. With my new position as a Senior Database Engineer / DBA with incuBET Inc. I am in the privileged position to be able to do so. That being said, stay tuned to this blog for new monthly reviews, coding...
Continue reading...

Just a quick update, due to my schedule I have been set back porting my old posts over and adding new ones. I am going to be doing this slowly over the next 2 months. If there are any DB, OOP, C#, SSIS, SSRS, etc... topics you would like to see or learn more about feel free to let me know : me@johntrumbul.com don't worry, I will not give lame 1/2 a-- answers. If i don't know I will point you to www.stackoverflow.com where someone will I am sure. :) Happy Hacking!

Continue reading...

I was fortunate enough to get an article published about me in red-gate. While it was for their tools, it gives background on me as well as the company I work for Lumidata. Which is always cool. Check it out : http://www.red-gate.com/products/dba/sql-monitor/case-studies/john-trumbul

Continue reading...