Every week, Pragmatic Works offers up its "Training on the Ts" webcast series and this month, in honor of Women's History Month, the series is showcasing all of its sessions with women speakers. Doing this offers all of us a chance highlight some of the female voices in our male dominated field. Hopefully, this focus inspires some … Continue reading Pragmatic Works Webcasts This Week #passwit
It's just coming up in just a few more weeks... this is the first SQL Saturday in Fargo. North Dakota is one of the few states that hasn't had a SQL Saturday. With the help of my fellow PASS Regional Mentor Ted Krueger (Blog | @Onpnt), my wife Sarah Strate (Blog | @DanceM0m), and my good friend Jes Borland … Continue reading Fargo SQL Saturday (#SQLSat175) Schedule Is Up
After this month's Index Analysis update, I was contacted by a reader about the index analysis script. Reader Dick Baker let me know that he found and had a fix for an issue with the missing_index_impact column. Thanks to Dick for this fix. If you find issues or have suggestions for changes to the script, please … Continue reading A Second March ‘Index Analysis’ Update
It's coming up in just a couple weeks... the SQL Saturday in Madison, Wisconsin. On April 6th, a couple hundred of your closest SQL Server peers will be meeting in the state of beer and cheese to do a little learning and networking around SQL Server. I'll be there, with unicorn on hand and my … Continue reading Madison SQL Saturday (#SQLSat206) Coming Up
Every week, Pragmatic Works offers up its "Training on the Ts" webcast series and this month, in honor of Women's History Month, the series is showcasing all of its sessions with women speakers. Doing this offers all of us a chance highlight some of the female voices in our male dominated field. Hopefully, this focus inspires some … Continue reading Pragmatic Works Webcasts This Week #passwit
Every week, Pragmatic Works offers up its "Training on the Ts" webcast series and this month, in honor of Women's History Month, the series is showcasing all of its sessions with women speakers. Doing this offers all of us a chance highlight some of the female voices in our male dominated field. Hopefully, this focus inspires some … Continue reading Pragmatic Works Webcasts This Week #passwit
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure today. Without further ado, you can jump to the bottom and download it. There are a few things I've fixed from comments from people using the script and then major change is the addition of … Continue reading Index Analysis March Update
As I've worked with clients on performance tuning through index improvements, one of the common areas that I discuss with them are duplicate indexes. The problem with duplicate indexes is that they are pointless and redundant. All they provide is an additional physical copy of the index and all you get is another index for … Continue reading That’s Actually A Duplicate Index
It's the first Monday of the month, do you know where your servers are? Hopefully, they are still in your data center. If not, I'm not sure this post will help you out, so you better just call the police. But if they are in your data center, then do you know how they are … Continue reading March 2013 – Monthly SQL Server Checklist
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session A Functions Is A Function – Comparison of the Performance Impacts of User Defined Functions. A Function by Any Other Name is a Function from Jason Strate Download: [download id="68"] Other resources: http://msdn.microsoft.com/en-us/library/ms189294.aspx http://www.sqlteam.com/article/intro-to-user-defined-functions-updated http://www.amazon.com/Transact-SQL-User-Defined-Functions/dp/1556220790/ref=sr_1_1?ie=UTF8&s=books&qid=1268026139&sr=8-1
Strate SQL 