So where have I been? Sorry for no posts, or other updates of sort. I been busy a bit since July; I tried to get
Getting Index count for all tables
Davide Mauri wrote a nice script, I have done similar work without using CTE. So I really liked the script; I notice in his comments
Error 17182: SQL Service Error
While fixing SQL Server configuration I ran into some rather interseting/unique errors: Server local connection provider failed to listen on [ \\.\pipe\sql\query ]. Error: 0x50
Listing blocking chain by tasks
References: #20
Windows Internal Database
I haven’t ran into this much, as it seems it is optional component that can be installed when configuring Microsoft Windows. The reason I say
Multi-path I/O (MPIO) does not work for disk with identifier … on node …
How to configure MPIO in Windows 2008 Cluster
SQL Canada (SQLCAN) 