It's not all that uncommon to start a new job, or inherit a project, and find out that index maintenance hasn't exactly been a priority. One of the first things you want to do is look at fragmentation. This query will pull back all the indexes for My_Database ordered by the average fragmentation in percent. […]
Category: Tech and Learning
Snacks and Keyboard Shortcuts
At the risk of stealing his thunder, I think I'll make my first blog post about Sean's latest greatest idea, the Midnight Snacks. We'll soon be offering daily video snippets, or "Snacks", for your edification. I've just recorded a few vids on one of the great unsung heroes of computing, the keyboard shortcut. Here's the […]
Powershell with –NoExit
Here I show you how to get around the problem of your Powershell window closing down when you call it from either the run window or from other programs. If you get errors or want to see something that was printed on the screen it’s quite often impossible unless you startup PowerShell or dos first. […]